APPS.CSTPAPBR dependencies on CST_RCV_ACQ_COSTS

Line 799: cst_rcv_acq_costs crac

795: COUNT(rcv_transaction_id)
796: INTO
797: l_acq_exists
798: FROM
799: cst_rcv_acq_costs crac
800: WHERE
801: crac.rcv_transaction_id = l_par_rcv_txn AND
802: crac.cost_type_id = i_ae_txn_rec.cost_type_id AND
803: crac.cost_group_id = i_ae_txn_rec.cost_group_id;

Line 817: from cst_rcv_acq_costs crac

813: INTO
814: l_nqr,
815: l_costed_quantity,
816: l_acq_cost
817: from cst_rcv_acq_costs crac
818: where crac.rcv_transaction_id = l_par_rcv_txn AND
819: crac.cost_type_id = i_ae_txn_rec.cost_type_id AND
820: crac.cost_group_id = i_ae_txn_rec.cost_group_id;
821:

Line 845: FROM cst_rcv_acq_costs crac

841: cst_rcv_acq_cost_details cracd,
842: ap_invoice_distributions_all aida
843: WHERE aida.invoice_distribution_id = cracd.invoice_distribution_id
844: AND cracd.header_id = (SELECT header_id
845: FROM cst_rcv_acq_costs crac
846: WHERE rcv_transaction_id = l_par_rcv_txn
847: AND crac.cost_type_id = i_ae_txn_rec.cost_type_id
848: AND crac.cost_group_id = i_ae_txn_rec.cost_group_id)
849: AND cracd.source_type = 'INVOICE';*/

Line 864: from cst_rcv_acq_costs crac

860: aida.invoice_distribution_id = cracd.invoice_distribution_id
861: and aia.invoice_id = aida.invoice_id
862: and aia.org_id = aida.org_id
863: and cracd.header_id = (select header_id
864: from cst_rcv_acq_costs crac
865: where rcv_transaction_id = l_par_rcv_txn
866: AND
867: crac.cost_type_id = i_ae_txn_rec.cost_type_id AND
868: crac.cost_group_id = i_ae_txn_rec.cost_group_id)

Line 889: FROM cst_rcv_acq_costs crac

885: rcv_transactions rt
886: WHERE
887: poll.line_location_id = cracd.po_line_location_id
888: AND cracd.header_id = (SELECT header_id
889: FROM cst_rcv_acq_costs crac
890: WHERE rcv_transaction_id = rt.transaction_id
891: AND crac.cost_type_id = i_ae_txn_rec.cost_type_id
892: AND crac.cost_group_id = i_ae_txn_rec.cost_group_id)
893: AND rt.transaction_id = l_par_rcv_txn