459: l_req_status, l_po_curr
460:
461: FROM
462: PO_LINES_ALL PLA,
463: FINANCIALS_SYSTEM_PARAMS_ALL FSPA,
464: PO_HEADERS_ALL PHA,
465: PO_CHANGE_REQUESTS POCR
466:
467: WHERE
844: l_shipment_type, l_drop_ship_flag, l_po_curr
845: FROM
846: PO_LINE_LOCATIONS_ALL PLLA,
847: PO_LINES_ALL PLA,
848: FINANCIALS_SYSTEM_PARAMS_ALL FSPA,
849: -- MTL_UNITS_OF_MEASURE_TL MUOMTL,
850: PO_RELEASES_ALL PRAA, PO_HEADERS_ALL PHA,
851: PO_CHANGE_REQUESTS POCR
852: WHERE
927: l_shipment_type, l_drop_ship_flag, l_po_curr
928: FROM
929: PO_LINE_LOCATIONS_ALL PLLA,
930: PO_LINES_ALL PLA,
931: FINANCIALS_SYSTEM_PARAMS_ALL FSPA,
932: PO_HEADERS_ALL PHA,
933: PO_CHANGE_REQUESTS POCR
934: WHERE
935: PLA.PO_Line_id= PLLA.PO_Line_ID and