APPS.PO_ENCUMBRANCE_POSTPROCESSING dependencies on PO_REQUISITION_HEADERS_ALL

Line 626: FROM po_requisition_headers_all

622: --DIST.SEGMENT1,
623: ( CASE
624: WHEN reference1 = 'REQ'
625: AND ( EXISTS (SELECT 1
626: FROM po_requisition_headers_all
627: WHERE To_char(requisition_header_id) =
628: dist.reference2
629: AND par_flag = 'Y') ) THEN (SELECT
630: modification_number

Line 3161: PO_REQUISITION_HEADERS_ALL PRH

3157: ( SELECT
3158: PRH.authorization_status
3159: , PRH.type_lookup_code
3160: FROM
3161: PO_REQUISITION_HEADERS_ALL PRH
3162: WHERE PRH.requisition_header_id = SCRATCH.num1
3163: )
3164: WHERE SCRATCH.key = l_gt_key
3165: ;

Line 4222: from psa_xla_accounting_errors pba,po_requisition_headers_all prh

4218: , g_result_TRANSACTION -- message type
4219: , pba.ENCODED_MSG
4220: , 'Y' --
4221: , prh.segment1
4222: from psa_xla_accounting_errors pba,po_requisition_headers_all prh
4223: where pba.event_id = PO_ENCUMBRANCE_POSTPROCESSING.g_event_id
4224: and pba.source_id_int_1 = prh.requisition_header_id;
4225: else
4226: