APPS.PA_FUNDS_CONTROL_PKG dependencies on AP_INVOICE_DISTRIBUTIONS_ALL

Line 5303: ,ap_invoice_distributions_all ap

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
5307: and ap.po_distribution_id = po.po_distribution_id

Line 5316: ,ap_invoice_distributions_all ap

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
5320: and po.req_header_reference_num = b.document_header_id

Line 5331: from ap_invoice_distributions_all ap

5327: OR (( a.document_type = 'EXP' and b.document_type = 'AP' )
5328: and (abs(nvl(a.accounted_dr,0) - nvl(a.accounted_cr,0)) =
5329: abs(nvl(b.accounted_dr,0) - nvl(b.accounted_cr,0)))
5330: and exists (select 'Y'
5331: from ap_invoice_distributions_all ap
5332: ,pa_bc_packets pbc
5333: where ap.invoice_id = b.document_header_id
5334: and ap.distribution_line_number = b.document_distribution_id
5335: /** and pbc.packet_id = 4003 commented out NOCOPY the hardcoded **/

Line 13574: from ap_invoice_distributions_all a

13570: decode (pbc.document_type , 'PO' , to_number(pbc.reference3) , 'AP' , pbc.document_distribution_id)) IN
13571: /** Select to fetch all related invoice distributions associated with a failed record in packet.
13572: This sql fetches all invoice distributions linked to each other with charge_applicable_to_dist_id and related id**/
13573: ( select distinct b.invoice_id,b.invoice_distribution_id
13574: from ap_invoice_distributions_all a
13575: ,ap_invoice_distributions_all b
13576: where (a.invoice_id,a.invoice_distribution_id) in
13577: /**select to fetch Invoice id and Inv distribution id associated with failed AP/PO records in a packet**/
13578: (select DECODE(pbc1.document_type,'PO',to_number(pbc1.reference2),pbc1.document_header_id),

Line 13575: ,ap_invoice_distributions_all b

13571: /** Select to fetch all related invoice distributions associated with a failed record in packet.
13572: This sql fetches all invoice distributions linked to each other with charge_applicable_to_dist_id and related id**/
13573: ( select distinct b.invoice_id,b.invoice_distribution_id
13574: from ap_invoice_distributions_all a
13575: ,ap_invoice_distributions_all b
13576: where (a.invoice_id,a.invoice_distribution_id) in
13577: /**select to fetch Invoice id and Inv distribution id associated with failed AP/PO records in a packet**/
13578: (select DECODE(pbc1.document_type,'PO',to_number(pbc1.reference2),pbc1.document_header_id),
13579: DECODE(pbc1.document_type,'PO',to_number(pbc1.reference3),pbc1.document_distribution_id)