eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PA_FUNDS_CONTROL_PKG dependencies on PO_REQ_DISTRIBUTIONS_ALL

Line 5291: ,po_req_distributions_all req

5287: )
5288: and ((( a.document_type = 'PO' and b.document_type = 'REQ')
5289: and exists ( select 'Y'
5290: from po_distributions_all po
5291: ,po_req_distributions_all req
5292: where req.distribution_id = b.document_distribution_id
5293: and po.po_distribution_id = a.document_distribution_id
5294: and po.req_distribution_id = req.distribution_id
5295: and a.packet_id = b.packet_id

Line 10960: pbc.document_type = decode(gl.source_distribution_type,'PO_REQ_DISTRIBUTIONS_ALL','REQ','X')

10956: and (pbc.document_type = decode(gl.source_distribution_type,'AP_INV_DIST','AP','AP_PREPAY','AP','X')
10957: OR
10958: pbc.document_type = decode(gl.source_distribution_type,'PO_DISTRIBUTIONS_ALL','PO','X')
10959: OR
10960: pbc.document_type = decode(gl.source_distribution_type,'PO_REQ_DISTRIBUTIONS_ALL','REQ','X')
10961: OR
10962: pbc.document_type = decode(gl.source_distribution_type,'CC','CC_C_PAY')
10963: OR
10964: pbc.document_type = decode(gl.source_distribution_type,'CC','CC_P_PAY')

Line 10996: -- 'REQ','PO_REQ_DISTRIBUTIONS_ALL') source_distribution_type

10992: -- 'AP','PA_AP_BURDEN',
10993: -- 'PO','PO_DISTRIBUTIONS_ALL',
10994: -- 'PO','PA_PO_BURDEN',
10995: -- 'REQ','PA_REQ_BURDEN',
10996: -- 'REQ','PO_REQ_DISTRIBUTIONS_ALL') source_distribution_type
10997: from pa_bc_packets pb
10998: where pb.packet_id = p_packet_id
10999: UNION ALL
11000: Select pb.source_event_id,

Line 11008: -- 'REQ','PO_REQ_DISTRIBUTIONS_ALL') source_distribution_type

11004: -- 'AP','PA_AP_BURDEN',
11005: -- 'PO','PO_DISTRIBUTIONS_ALL',
11006: -- 'PO','PA_PO_BURDEN',
11007: -- 'REQ','PA_REQ_BURDEN',
11008: -- 'REQ','PO_REQ_DISTRIBUTIONS_ALL') source_distribution_type
11009: from pa_bc_packets pb
11010: where pb.packet_id = p_packet_id);
11011:
11012: If g_debug_mode = 'Y' Then

Line 11254: -- 'REQ','PO_REQ_DISTRIBUTIONS_ALL') source_distribution_type

11250: -- 'AP','PA_AP_BURDEN',
11251: -- 'PO','PO_DISTRIBUTIONS_ALL',
11252: -- 'PO','PA_PO_BURDEN',
11253: -- 'REQ','PA_REQ_BURDEN',
11254: -- 'REQ','PO_REQ_DISTRIBUTIONS_ALL') source_distribution_type
11255: from pa_bc_packets pb
11256: where pb.packet_id = p_packet_id
11257: UNION ALL
11258: Select pb.source_event_id,

Line 11266: -- 'REQ','PO_REQ_DISTRIBUTIONS_ALL') source_distribution_type

11262: -- 'AP','PA_AP_BURDEN',
11263: -- 'PO','PO_DISTRIBUTIONS_ALL',
11264: -- 'PO','PA_PO_BURDEN',
11265: -- 'REQ','PA_REQ_BURDEN',
11266: -- 'REQ','PO_REQ_DISTRIBUTIONS_ALL') source_distribution_type
11267: from pa_bc_packets pb
11268: where pb.packet_id = p_packet_id);
11269:
11270:

Line 12872: 'PO_REQ_DISTRIBUTIONS_ALL','REQ') source_distribution_type

12868: 'PA_AP_BURDEN','AP',
12869: 'PO_DISTRIBUTIONS_ALL','PO',
12870: 'PA_PO_BURDEN','PO',
12871: 'PA_REQ_BURDEN','REQ',
12872: 'PO_REQ_DISTRIBUTIONS_ALL','REQ') source_distribution_type
12873: FROM gl_bc_packets gl
12874: WHERE gl.packet_id = v_packet_id
12875: AND ( (nvl(substr(gl.result_code,1,1),'P') = 'F'
12876: AND gl.status_code in ('F','R'))