APPS.CSTPAPPR dependencies on AP_INVOICE_DISTRIBUTIONS_ALL

Line 1081: ap_invoice_distributions_all aida,

1077: into
1078: l_acq_cost_ent_inv
1079: from
1080: cst_rcv_acq_cost_details cracd,
1081: ap_invoice_distributions_all aida,
1082: ap_invoices_all aia
1083: where
1084: aida.invoice_distribution_id = cracd.invoice_distribution_id
1085: and aia.invoice_id = aida.invoice_id

Line 1870: ap_invoice_distributions_all aida ,

1866: cst_rcv_acq_costs crac,
1867: xla_distribution_links xdl,
1868: xla_ae_lines xal,
1869: xla_ae_headers xae,
1870: ap_invoice_distributions_all aida ,
1871: ap_invoices_all aia
1872: WHERE
1873: cracd.line_type NOT IN ('ITEM','ACCRUAL','IPV','ERV','NONREC_TAX') AND
1874: crac.rcv_transaction_id = l_par_rcv_txn AND

Line 1898: SELECT '1' FROM ap_invoice_distributions_all aida2

1894: 'IPV','EXCHANGE_RATE_VARIANCE' ,'NONRECOVERABLE TAX')
1895: AND aia.invoice_id = aida.invoice_id
1896: AND aia.org_id = aida.org_id
1897: AND NOT EXISTS (
1898: SELECT '1' FROM ap_invoice_distributions_all aida2
1899: WHERE aida2.related_id = aida.invoice_distribution_id
1900: AND aida2.line_type_lookup_code = 'IPV');
1901:
1902:

Line 1913: ap_invoice_distributions_all aida,

1909: aida.dist_code_combination_id "CODE_COMBINATION_ID"
1910: FROM
1911: cst_rcv_acq_cost_details cracd,
1912: cst_rcv_acq_costs crac,
1913: ap_invoice_distributions_all aida,
1914: ap_invoices_all aia
1915: WHERE
1916: cracd.line_type NOT IN ('ITEM','ACCRUAL','IPV','ERV','NONREC_TAX') AND
1917: crac.rcv_transaction_id = l_par_rcv_txn AND

Line 1926: SELECT '1' FROM ap_invoice_distributions_all aida2

1922: cracd.invoice_distribution_id = aida.invoice_distribution_id AND
1923: aia.invoice_id = aida.invoice_id AND
1924: aia.org_id = aida.org_id AND
1925: NOT EXISTS (
1926: SELECT '1' FROM ap_invoice_distributions_all aida2
1927: WHERE aida2.related_id = aida.invoice_distribution_id
1928: AND aida2.line_type_lookup_code = 'IPV'
1929: );
1930:

Line 2052: ap_invoice_distributions_all aida,

2048: cst_rcv_acq_costs crac,
2049: xla_distribution_links xdl,
2050: xla_ae_lines xal,
2051: xla_ae_headers xae,
2052: ap_invoice_distributions_all aida,
2053: ap_invoices_all aia
2054: WHERE
2055: crac.rcv_transaction_id = l_par_rcv_txn AND
2056: crac.cost_type_id =i_ae_txn_rec.cost_type_id AND

Line 2094: ap_invoice_distributions_all aida,

2090: aida.related_id "INVOICE_DISTRIBUTION_ID"
2091: FROM
2092: cst_rcv_acq_cost_details cracd,
2093: cst_rcv_acq_costs crac,
2094: ap_invoice_distributions_all aida,
2095: ap_invoices_all aia
2096: WHERE
2097: crac.rcv_transaction_id = l_par_rcv_txn AND
2098: crac.cost_type_id = i_ae_txn_rec.cost_type_id AND

Line 2166: AP_INVOICE_DISTRIBUTIONS_ALL AIDA,

2162: NVL(AIDA.BASE_AMOUNT/NVL(AP_INV.EXCHANGE_RATE,1), 0)
2163: INTO
2164: l_correct_ipv_amount
2165: FROM
2166: AP_INVOICE_DISTRIBUTIONS_ALL AIDA,
2167: AP_INVOICES_ALL AP_INV
2168: WHERE
2169: AIDA.CORRECTED_INVOICE_DIST_ID = c_ipv_rec.INVOICE_DISTRIBUTION_ID
2170: AND AIDA.LINE_TYPE_LOOKUP_CODE = 'IPV'

Line 2261: ap_invoice_distributions_all aida

2257: xla_ae_lines xal,
2258: xla_ae_headers xae,
2259: cst_rcv_acq_cost_details cracd,
2260: cst_rcv_acq_costs crac,
2261: ap_invoice_distributions_all aida
2262: where crac.rcv_transaction_id =l_par_rcv_txn
2263: AND crac.cost_type_id=i_ae_txn_rec.cost_type_id
2264: AND crac.cost_group_id=i_ae_txn_rec.cost_group_id
2265: AND cracd.header_id = crac.header_id

Line 2293: ap_invoice_distributions_all aida

2289: aida.dist_code_combination_id "CODE_COMBINATION_ID"
2290: FROM
2291: cst_rcv_acq_cost_details cracd,
2292: cst_rcv_acq_costs crac,
2293: ap_invoice_distributions_all aida
2294: WHERE
2295: crac.rcv_transaction_id = l_par_rcv_txn AND
2296: crac.cost_type_id = i_ae_txn_rec.cost_type_id AND
2297: crac.cost_group_id = i_ae_txn_rec.cost_group_id AND