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)
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)
No comments:
Post a Comment