Query to check Internal Requisition Number and Internal Sales Order Number

Query to check Internal Requisition Number and Internal Sales Order Number

select ORIG_SYS_DOCUMENT_REF from OE_ORDER_HEADERS_ALL
where 1=1
and ORDER_NUMBER=’736953′

select * from po_requisition_HEADERs_all
where SEGMENT1=’45643′

1. OE_ORDER_LINES_ALL.SOURCE_DOCUMENT_LINE_ID =
po_requisition_lines_all.REQUISITION_LINE_ID
2.  OE_ORDER_LINES_ALL.ORIG_SYS_DOCUMENT_REF=
po_requisition_HEADERs_all.SEGMENT1(Requisition Number)
3.  OE_ORDER_HEADERS_ALL.ORIG_SYS_DOCUMENT_REF=
po_requisition_HEADERs_all.SEGMENT1(Requisition number)

Advertisements