APPS.CSTPAPPR dependencies on CST_RCV_ACQ_COST_DETAILS

Line 1080: cst_rcv_acq_cost_details cracd,

1076: sum(decode(cracd.price, null, cracd.amount/NVL(aia.exchange_rate,1), cracd.price*cracd.quantity))
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

Line 1105: cst_rcv_acq_cost_details cracd,

1101: ,cracd.price*cracd.quantity))
1102: into
1103: l_acq_cost_ent_po
1104: from
1105: cst_rcv_acq_cost_details cracd,
1106: po_line_locations_all poll,
1107: rcv_transactions rt
1108: where
1109: poll.line_location_id = cracd.po_line_location_id

Line 1865: cst_rcv_acq_cost_details cracd,

1861: aia.exchange_date "EXCHANGE_DATE",
1862: aia.exchange_rate_type "EXCHANGE_RATE_TYPE",
1863: xal.code_combination_id "CODE_COMBINATION_ID"
1864: FROM
1865: cst_rcv_acq_cost_details cracd,
1866: cst_rcv_acq_costs crac,
1867: xla_distribution_links xdl,
1868: xla_ae_lines xal,
1869: xla_ae_headers xae,

Line 1911: cst_rcv_acq_cost_details cracd,

1907: aia.exchange_date "EXCHANGE_DATE",
1908: aia.exchange_rate_type "EXCHANGE_RATE_TYPE",
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

Line 2047: cst_rcv_acq_cost_details cracd,

2043: aia.exchange_rate_type "EXCHANGE_RATE_TYPE",
2044: xal.code_combination_id "CODE_COMBINATION_ID",
2045: aida.related_id "INVOICE_DISTRIBUTION_ID"
2046: FROM
2047: cst_rcv_acq_cost_details cracd,
2048: cst_rcv_acq_costs crac,
2049: xla_distribution_links xdl,
2050: xla_ae_lines xal,
2051: xla_ae_headers xae,

Line 2092: cst_rcv_acq_cost_details cracd,

2088: -- Retroactive Pricing Enhancements
2089: -- Need Invoice Distribution to find correction invoices
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

Line 2259: cst_rcv_acq_cost_details cracd,

2255: from
2256: xla_distribution_links xdl,
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

Line 2291: cst_rcv_acq_cost_details cracd,

2287: SELECT
2288: aida.base_amount "EXCHANGE_RATE_VARIANCE",
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