APPS.PA_FUNDS_CONTROL_PKG dependencies on PO_DISTRIBUTIONS_ALL

Line 5290: from po_distributions_all po

5286: or (a.parent_bc_packet_id is not null and b.parent_bc_packet_id is not null)
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

Line 5302: from po_distributions_all po

5298: )
5299: )
5300: OR (( a.document_type = 'AP' and b.document_type = 'PO' )
5301: and exists ( select 'Y'
5302: from po_distributions_all po
5303: ,ap_invoice_distributions_all ap
5304: where po.po_distribution_id = b.document_distribution_id
5305: and ap.invoice_id = a.document_header_id
5306: and ap.distribution_line_number = a.document_distribution_id

Line 5315: from po_distributions_all po

5311: )
5312: )
5313: OR (( a.document_type = 'AP' and b.document_type in ( 'CC_P_PAY','CC_C_PAY' ))
5314: and exists ( select 'Y'
5315: from po_distributions_all po
5316: ,ap_invoice_distributions_all ap
5317: where po.po_distribution_id = ap.po_distribution_id
5318: and ap.invoice_id = a.document_header_id
5319: and ap.distribution_line_number = a.document_distribution_id

Line 10958: pbc.document_type = decode(gl.source_distribution_type,'PO_DISTRIBUTIONS_ALL','PO','X')

10954: and pbc.document_distribution_id = gl.source_distribution_id_num_1
10955: and ((pbc.source_event_id = gl.event_id
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')

Line 10993: -- 'PO','PO_DISTRIBUTIONS_ALL',

10989: pb.document_distribution_id
10990: --,decode(pb.document_type,
10991: -- 'AP','AP_INV_DIST',
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

Line 11005: -- 'PO','PO_DISTRIBUTIONS_ALL',

11001: pb.document_distribution_id
11002: --,decode(pb.document_type,
11003: -- 'AP','AP_INV_DIST',
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

Line 11251: -- 'PO','PO_DISTRIBUTIONS_ALL',

11247: pb.document_distribution_id
11248: --,decode(pb.document_type,
11249: -- 'AP','AP_INV_DIST',
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

Line 11263: -- 'PO','PO_DISTRIBUTIONS_ALL',

11259: pb.document_distribution_id
11260: --,decode(pb.document_type,
11261: -- 'AP','AP_INV_DIST',
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

Line 12869: 'PO_DISTRIBUTIONS_ALL','PO',

12865: decode(gl.source_distribution_type,
12866: 'AP_INV_DIST','AP',
12867: 'AP_PREPAY','AP',
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