APPS.PA_FUNDS_CONTROL_PKG dependencies on PO_REQ_DISTRIBUTIONS_ALL

Line 5391: ,po_req_distributions_all req

5387: )
5388: and ((( a.document_type = 'PO' and b.document_type = 'REQ')
5389: and exists ( select 'Y'
5390: from po_distributions_all po
5391: ,po_req_distributions_all req
5392: where req.distribution_id = b.document_distribution_id
5393: and po.po_distribution_id = a.document_distribution_id
5394: and po.req_distribution_id = req.distribution_id
5395: and a.packet_id = b.packet_id

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

11222: and (pbc.document_type = decode(gl.source_distribution_type,'AP_INV_DIST','AP','AP_PREPAY','AP','X')
11223: OR
11224: pbc.document_type = decode(gl.source_distribution_type,'PO_DISTRIBUTIONS_ALL','PO','X')
11225: OR
11226: pbc.document_type = decode(gl.source_distribution_type,'PO_REQ_DISTRIBUTIONS_ALL','REQ','X')
11227: OR
11228: pbc.document_type = decode(gl.source_distribution_type,'CC','CC_C_PAY')
11229: OR
11230: pbc.document_type = decode(gl.source_distribution_type,'CC','CC_P_PAY')

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

11258: -- 'AP','PA_AP_BURDEN',
11259: -- 'PO','PO_DISTRIBUTIONS_ALL',
11260: -- 'PO','PA_PO_BURDEN',
11261: -- 'REQ','PA_REQ_BURDEN',
11262: -- 'REQ','PO_REQ_DISTRIBUTIONS_ALL') source_distribution_type
11263: from pa_bc_packets pb
11264: where pb.packet_id = p_packet_id
11265: UNION ALL
11266: Select pb.source_event_id,

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

11270: -- 'AP','PA_AP_BURDEN',
11271: -- 'PO','PO_DISTRIBUTIONS_ALL',
11272: -- 'PO','PA_PO_BURDEN',
11273: -- 'REQ','PA_REQ_BURDEN',
11274: -- 'REQ','PO_REQ_DISTRIBUTIONS_ALL') source_distribution_type
11275: from pa_bc_packets pb
11276: where pb.packet_id = p_packet_id);
11277:
11278: If g_debug_mode = 'Y' Then

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

11516: -- 'AP','PA_AP_BURDEN',
11517: -- 'PO','PO_DISTRIBUTIONS_ALL',
11518: -- 'PO','PA_PO_BURDEN',
11519: -- 'REQ','PA_REQ_BURDEN',
11520: -- 'REQ','PO_REQ_DISTRIBUTIONS_ALL') source_distribution_type
11521: from pa_bc_packets pb
11522: where pb.packet_id = p_packet_id
11523: UNION ALL
11524: Select pb.source_event_id,

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

11528: -- 'AP','PA_AP_BURDEN',
11529: -- 'PO','PO_DISTRIBUTIONS_ALL',
11530: -- 'PO','PA_PO_BURDEN',
11531: -- 'REQ','PA_REQ_BURDEN',
11532: -- 'REQ','PO_REQ_DISTRIBUTIONS_ALL') source_distribution_type
11533: from pa_bc_packets pb
11534: where pb.packet_id = p_packet_id);
11535:
11536:

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

13196: 'PA_AP_BURDEN','AP',
13197: 'PO_DISTRIBUTIONS_ALL','PO',
13198: 'PA_PO_BURDEN','PO',
13199: 'PA_REQ_BURDEN','REQ',
13200: 'PO_REQ_DISTRIBUTIONS_ALL','REQ') source_distribution_type
13201: FROM gl_bc_packets gl
13202: WHERE gl.packet_id = v_packet_id
13203: AND ( (nvl(substr(gl.result_code,1,1),'P') = 'F'
13204: AND gl.status_code in ('F','R'))

Line 14144: OR pb.document_type = decode(l_source_distribution_type,'PO_REQ_DISTRIBUTIONS_ALL','REQ','X')

14140: ); */ -- Modified for bug 14665683
14141: /* Removed for bug #14635279 (pb.source_event_id = l_event_id
14142: and (pb.document_type = decode(l_source_distribution_type,'AP_INV_DIST','AP','AP_PREPAY','AP','X')
14143: OR pb.document_type = decode(l_source_distribution_type,'PO_DISTRIBUTIONS_ALL','PO','X')
14144: OR pb.document_type = decode(l_source_distribution_type,'PO_REQ_DISTRIBUTIONS_ALL','REQ','X')
14145: OR pb.document_type = decode(l_source_distribution_type,'CC','CC_C_PAY')
14146: OR pb.document_type = decode(l_source_distribution_type,'CC','CC_P_PAY')
14147: )
14148: )