APPS.PA_FUNDS_CONTROL_PKG dependencies on AP_INVOICE_DISTRIBUTIONS_ALL

Line 5403: ,ap_invoice_distributions_all ap

5399: )
5400: OR (( a.document_type = 'AP' and b.document_type = 'PO' )
5401: and exists ( select 'Y'
5402: from po_distributions_all po
5403: ,ap_invoice_distributions_all ap
5404: where po.po_distribution_id = b.document_distribution_id
5405: and ap.invoice_id = a.document_header_id
5406: and ap.distribution_line_number = a.document_distribution_id
5407: and ap.po_distribution_id = po.po_distribution_id

Line 5427: ,ap_invoice_distributions_all ap

5423: )
5424: OR (( a.document_type = 'AP' and b.document_type in ( 'CC_P_PAY','CC_C_PAY' ))
5425: and exists ( select 'Y'
5426: from po_distributions_all po
5427: ,ap_invoice_distributions_all ap
5428: where po.po_distribution_id = ap.po_distribution_id
5429: and ap.invoice_id = a.document_header_id
5430: and ap.distribution_line_number = a.document_distribution_id
5431: and po.req_header_reference_num = b.document_header_id

Line 5454: from ap_invoice_distributions_all ap

5450: OR (( a.document_type = 'EXP' and b.document_type = 'AP' )
5451: and (abs(nvl(a.accounted_dr,0) - nvl(a.accounted_cr,0)) =
5452: abs(nvl(b.accounted_dr,0) - nvl(b.accounted_cr,0)))
5453: and exists (select 'Y'
5454: from ap_invoice_distributions_all ap
5455: ,pa_bc_packets pbc
5456: where ap.invoice_id = b.document_header_id
5457: and ap.distribution_line_number = b.document_distribution_id
5458: /** and pbc.packet_id = 4003 commented out NOCOPY the hardcoded **/

Line 13922: from ap_invoice_distributions_all a

13918: decode (pbc.document_type , 'PO' , to_number(pbc.reference3) , 'AP' , pbc.document_distribution_id)) IN
13919: /** Select to fetch all related invoice distributions associated with a failed record in packet.
13920: This sql fetches all invoice distributions linked to each other with charge_applicable_to_dist_id and related id**/
13921: ( select distinct b.invoice_id,b.invoice_distribution_id
13922: from ap_invoice_distributions_all a
13923: ,ap_invoice_distributions_all b
13924: where (a.invoice_id,a.invoice_distribution_id) in
13925: /**select to fetch Invoice id and Inv distribution id associated with failed AP/PO records in a packet**/
13926: (select DECODE(pbc1.document_type,'PO',to_number(pbc1.reference2),pbc1.document_header_id),

Line 13923: ,ap_invoice_distributions_all b

13919: /** Select to fetch all related invoice distributions associated with a failed record in packet.
13920: This sql fetches all invoice distributions linked to each other with charge_applicable_to_dist_id and related id**/
13921: ( select distinct b.invoice_id,b.invoice_distribution_id
13922: from ap_invoice_distributions_all a
13923: ,ap_invoice_distributions_all b
13924: where (a.invoice_id,a.invoice_distribution_id) in
13925: /**select to fetch Invoice id and Inv distribution id associated with failed AP/PO records in a packet**/
13926: (select DECODE(pbc1.document_type,'PO',to_number(pbc1.reference2),pbc1.document_header_id),
13927: DECODE(pbc1.document_type,'PO',to_number(pbc1.reference3),pbc1.document_distribution_id)