SELECT OOHA.ORDER_NUMBER,
OOHL.LINE_NUMBER,
PRHA.SEGMENT1 REQUISITION_NUMBER,
PRLA.LINE_NUM REQUISITION_LINE_NUMBER,
PHA.SEGMENT1 PO_NUMBER,
PLA.LINE_NUM PO_LINE_NUMBER
FROM OE_ORDER_HEADERS_ALL OOHA,
OE_ORDER_LINES_ALL OOHL,
PO_REQUISITION_HEADERS_ALL PRHA,
PO_REQUISITION_LINES_ALL PRLA,
PO_REQ_DISTRIBUTIONS_ALL PRDA,
PO_DISTRIBUTIONS_ALL PDA,
PO_HEADERS_ALL PHA,
PO_LINES_ALL PLA
WHERE OOHA.HEADER_ID = OOHL.HEADER_ID
AND PRHA.INTERFACE_SOURCE_LINE_ID = OOHL.LINE_ID
AND PRHA.REQUISITION_HEADER_ID = PRLA.REQUISITION_HEADER_ID
AND PRLA.REQUISITION_LINE_ID = PRDA.REQUISITION_LINE_ID
AND PRDA.DISTRIBUTION_ID = PDA.REQ_DISTRIBUTION_ID
AND PDA.PO_HEADER_ID = PHA.PO_HEADER_ID
AND PHA.PO_HEADER_ID = PLA.PO_HEADER_ID;
OOHL.LINE_NUMBER,
PRHA.SEGMENT1 REQUISITION_NUMBER,
PRLA.LINE_NUM REQUISITION_LINE_NUMBER,
PHA.SEGMENT1 PO_NUMBER,
PLA.LINE_NUM PO_LINE_NUMBER
FROM OE_ORDER_HEADERS_ALL OOHA,
OE_ORDER_LINES_ALL OOHL,
PO_REQUISITION_HEADERS_ALL PRHA,
PO_REQUISITION_LINES_ALL PRLA,
PO_REQ_DISTRIBUTIONS_ALL PRDA,
PO_DISTRIBUTIONS_ALL PDA,
PO_HEADERS_ALL PHA,
PO_LINES_ALL PLA
WHERE OOHA.HEADER_ID = OOHL.HEADER_ID
AND PRHA.INTERFACE_SOURCE_LINE_ID = OOHL.LINE_ID
AND PRHA.REQUISITION_HEADER_ID = PRLA.REQUISITION_HEADER_ID
AND PRLA.REQUISITION_LINE_ID = PRDA.REQUISITION_LINE_ID
AND PRDA.DISTRIBUTION_ID = PDA.REQ_DISTRIBUTION_ID
AND PDA.PO_HEADER_ID = PHA.PO_HEADER_ID
AND PHA.PO_HEADER_ID = PLA.PO_HEADER_ID;
No comments:
Post a Comment