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 AP_SELF_ASSESSED_TAX_DIST_ALL

Line 5414: ,ap_self_assessed_tax_dist_all ap

5410: and b.packet_id = p_packet_id
5411: union /*Bug 13602288: Self Assessed Tax Changes*/
5412: select 'Y'
5413: from po_distributions_all po
5414: ,ap_self_assessed_tax_dist_all ap
5415: where po.po_distribution_id = b.document_distribution_id
5416: and ap.invoice_id = a.document_header_id
5417: and ap.distribution_line_number = a.document_distribution_id
5418: and ap.po_distribution_id = po.po_distribution_id

Line 5439: ,ap_self_assessed_tax_dist_all ap

5435: and b.packet_id = p_packet_id
5436: union /*Bug 13602288: Self Assessed Tax Changes*/
5437: select 'Y'
5438: from po_distributions_all po
5439: ,ap_self_assessed_tax_dist_all ap
5440: where po.po_distribution_id = ap.po_distribution_id
5441: and ap.invoice_id = a.document_header_id
5442: and ap.distribution_line_number = a.document_distribution_id
5443: and po.req_header_reference_num = b.document_header_id

Line 5469: from ap_self_assessed_tax_dist_all ap

5465: and a.bc_packet_id = p_bc_pkt_id
5466: and b.packet_id = p_packet_id
5467: union /*Bug 13602288: Self Assessed Tax Changes*/
5468: select 'Y'
5469: from ap_self_assessed_tax_dist_all ap
5470: ,pa_bc_packets pbc
5471: where ap.invoice_id = b.document_header_id
5472: and ap.distribution_line_number = b.document_distribution_id
5473: and pbc.packet_id = p_packet_id

Line 13938: from ap_self_assessed_tax_dist_all a

13934: and COALESCE(b.charge_applicable_to_dist_id,b.related_id,b.invoice_distribution_id) =
13935: COALESCE(a.charge_applicable_to_dist_id,a.related_id,a.invoice_distribution_id)
13936: UNION /*Bug 13602288: Self Assessed Tax Changes - If one transaction is failed funds check, we need to fail all other transactions which are associated to that packet */
13937: select distinct b.invoice_id,b.invoice_distribution_id
13938: from ap_self_assessed_tax_dist_all a
13939: ,ap_self_assessed_tax_dist_all b
13940: where (a.invoice_id,a.invoice_distribution_id) in
13941: /**select to fetch Invoice id and Inv distribution id associated with failed AP/PO records in a packet**/
13942: (select DECODE(pbc1.document_type,'PO',to_number(pbc1.reference2),pbc1.document_header_id),

Line 13939: ,ap_self_assessed_tax_dist_all b

13935: COALESCE(a.charge_applicable_to_dist_id,a.related_id,a.invoice_distribution_id)
13936: UNION /*Bug 13602288: Self Assessed Tax Changes - If one transaction is failed funds check, we need to fail all other transactions which are associated to that packet */
13937: select distinct b.invoice_id,b.invoice_distribution_id
13938: from ap_self_assessed_tax_dist_all a
13939: ,ap_self_assessed_tax_dist_all b
13940: where (a.invoice_id,a.invoice_distribution_id) in
13941: /**select to fetch Invoice id and Inv distribution id associated with failed AP/PO records in a packet**/
13942: (select DECODE(pbc1.document_type,'PO',to_number(pbc1.reference2),pbc1.document_header_id),
13943: DECODE(pbc1.document_type,'PO',to_number(pbc1.reference3),pbc1.document_distribution_id)