DBA Data[Home] [Help]

APPS.PO_REQCHANGEREQUESTNOTIF_PVT dependencies on PO_REQUISITION_HEADERS_ALL

Line 2215: PO_REQUISITION_HEADERS_ALL PRH, --

2211: begin
2212: select to_char(OOH.ORDER_NUMBER), OOL.FLOW_STATUS_CODE, OOL.LINE_ID
2213: INTO l_so_number, l_status_code, l_line_id
2214: from PO_REQUISITION_LINES PRL,
2215: PO_REQUISITION_HEADERS_ALL PRH, --
2216: OE_ORDER_HEADERS_ALL OOH,
2217: OE_ORDER_LINES_ALL OOL,
2218: PO_SYSTEM_PARAMETERS PSP
2219: WHERE PRL.REQUISITION_HEADER_ID = PRH.REQUISITION_HEADER_ID