APPS.CSTPAPPR dependencies on CST_RCV_ACQ_COSTS

Line 1018: cst_rcv_acq_costs crac

1014: count(rcv_transaction_id) -- change for the bug 4968702
1015: INTO
1016: l_acq_exists
1017: FROM
1018: cst_rcv_acq_costs crac
1019: WHERE
1020: crac.rcv_transaction_id = l_par_rcv_txn AND
1021: crac.cost_type_id = i_ae_txn_rec.cost_type_id AND
1022: crac.cost_group_id = i_ae_txn_rec.cost_group_id;

Line 1037: from cst_rcv_acq_costs crac

1033: INTO
1034: l_nqr,
1035: l_costed_quantity,
1036: l_acq_cost
1037: from cst_rcv_acq_costs crac
1038: where crac.rcv_transaction_id = l_par_rcv_txn AND
1039: crac.cost_type_id = i_ae_txn_rec.cost_type_id AND
1040: crac.cost_group_id = i_ae_txn_rec.cost_group_id;
1041:

Line 1075: from cst_rcv_acq_costs crac

1071: aida.invoice_distribution_id = cracd.invoice_distribution_id
1072: and aia.invoice_id = aida.invoice_id
1073: and aia.org_id = aida.org_id
1074: and cracd.header_id = (select header_id
1075: from cst_rcv_acq_costs crac
1076: where rcv_transaction_id = l_par_rcv_txn
1077: AND
1078: crac.cost_type_id = i_ae_txn_rec.cost_type_id AND
1079: crac.cost_group_id = i_ae_txn_rec.cost_group_id)

Line 1097: from cst_rcv_acq_costs crac

1093: rcv_transactions rt
1094: where
1095: poll.line_location_id = cracd.po_line_location_id
1096: and cracd.header_id = (select header_id
1097: from cst_rcv_acq_costs crac
1098: where rcv_transaction_id = rt.transaction_id
1099: AND
1100: crac.cost_type_id = i_ae_txn_rec.cost_type_id AND
1101: crac.cost_group_id = i_ae_txn_rec.cost_group_id)

Line 1442: FROM cst_rcv_acq_costs_adj craca

1438: l_dr_flag := not l_dr_flag;
1439: l_stmt_num := 1020;
1440: SELECT nvl(max(craca.period_id),-1)
1441: INTO l_lcm_adj_period
1442: FROM cst_rcv_acq_costs_adj craca
1443: WHERE craca.rcv_transaction_id = l_par_rcv_txn
1444: AND craca.cost_type_id = i_ae_txn_rec.cost_type_id
1445: AND craca.cost_group_id = i_ae_txn_rec.cost_group_id;
1446:

Line 1451: FROM cst_rcv_acq_costs_adj craca

1447: IF (l_lcm_adj_period <> -1) THEN
1448: l_stmt_num := 1030;
1449: SELECT craca.acquisition_cost
1450: INTO l_acq_cost
1451: FROM cst_rcv_acq_costs_adj craca
1452: WHERE craca.rcv_transaction_id = l_par_rcv_txn
1453: AND craca.cost_type_id = i_ae_txn_rec.cost_type_id
1454: AND craca.cost_group_id = i_ae_txn_rec.cost_group_id
1455: AND craca.period_id = l_lcm_adj_period;

Line 1824: cst_rcv_acq_costs crac,

1820: aia.exchange_rate_type "EXCHANGE_RATE_TYPE",
1821: aida.dist_code_combination_id "CODE_COMBINATION_ID"
1822: FROM
1823: cst_rcv_acq_cost_details cracd,
1824: cst_rcv_acq_costs crac,
1825: ap_invoice_distributions_all aida,
1826: ap_invoices_all aia
1827: WHERE
1828: cracd.line_type NOT IN ('ITEM','ACCRUAL','IPV','ERV','NONREC_TAX') AND

Line 1923: cst_rcv_acq_costs crac,

1919: -- Need Invoice Distribution to find correction invoices
1920: aida.related_id "INVOICE_DISTRIBUTION_ID"
1921: FROM
1922: cst_rcv_acq_cost_details cracd,
1923: cst_rcv_acq_costs crac,
1924: ap_invoice_distributions_all aida,
1925: ap_invoices_all aia
1926: WHERE
1927: crac.rcv_transaction_id = l_par_rcv_txn AND

Line 2047: cst_rcv_acq_costs crac,

2043: aida.amount "EXCHANGE_RATE_VARIANCE",
2044: aida.dist_code_combination_id "CODE_COMBINATION_ID"
2045: FROM
2046: cst_rcv_acq_cost_details cracd,
2047: cst_rcv_acq_costs crac,
2048: ap_invoice_distributions_all aida
2049: WHERE
2050: crac.rcv_transaction_id = l_par_rcv_txn AND
2051: crac.cost_type_id = i_ae_txn_rec.cost_type_id AND