DBA Data[Home] [Help]

APPS.PO_DOCUMENT_CANCEL_PVT dependencies on PO_REQUISITION_HEADERS_ALL

Line 3264: PO_REQUISITION_HEADERS_ALL PRH

3260: INTO l_parent_req_line_id,
3261: l_auth_status
3262: FROM PO_REQUISITION_LINES_ALL PORL_OLD,
3263: PO_REQUISITION_LINES_ALL PORL_NEW,
3264: PO_REQUISITION_HEADERS_ALL PRH
3265: WHERE PORL_OLD.requisition_line_id = (-1) * PORL_NEW.parent_req_line_id
3266: AND PRH.requisition_header_id = PORL_NEW.requisition_header_id
3267: AND PORL_NEW.requisition_line_id = p_req_line_id;
3268:

Line 3311: PO_REQUISITION_HEADERS_ALL PRH

3307:
3308: SELECT PRH.AUTHORIZATION_STATUS
3309: INTO l_auth_status
3310: FROM PO_REQUISITION_LINES_ALL PORL,
3311: PO_REQUISITION_HEADERS_ALL PRH
3312: WHERE PRH.requisition_header_id = PORL.requisition_header_id
3313: AND PORL.requisition_line_id = p_req_line_id;
3314:
3315:

Line 6555: FROM po_requisition_headers_all PRH,

6551: BEGIN
6552: BEGIN
6553: SELECT COUNT(*)
6554: INTO l_cto_order
6555: FROM po_requisition_headers_all PRH,
6556: po_requisition_lines_all PRL,
6557: po_line_locations POLL
6558: WHERE PRH.interface_source_code = 'CTO'
6559: AND PRH.requisition_header_id = PRL.requisition_header_id