APPS.CST_EAMCOST_PUB dependencies on RCV_TRANSACTIONS_INTERFACE

Line 5696: FROM rcv_transactions_interface

5692: to_organization_id
5693: INTO l_wip_entity_id,
5694: l_item_id,
5695: l_org_id
5696: FROM rcv_transactions_interface
5697: WHERE interface_transaction_id = l_interface_txn_id;
5698:
5699: if (l_debug = 'Y') then
5700: fnd_file.put_line(fnd_file.log,'WE: ' || to_char(l_wip_entity_id));

Line 5971: rcv_transactions_interface rti,

5967: l_curr_rate,
5968: l_curr_code,
5969: l_po_order_type_lookup_code
5970: from po_distributions_all pod,
5971: rcv_transactions_interface rti,
5972: po_lines_all pol
5973: where rti.interface_transaction_id = l_interface_txn_id
5974: and pod.po_distribution_id = rti.po_distribution_id
5975: and pol.po_header_id=pod.po_header_id

Line 6205: from rcv_transactions_interface rti,

6201: l_directItem_rec.transaction_type,
6202: l_directItem_rec.transaction_uom,
6203: l_directItem_rec.usage_rate_or_amount,
6204: l_directItem_rec.wip_entity_id
6205: from rcv_transactions_interface rti,
6206: po_distributions_all pod,
6207: mtl_units_of_measure muom,
6208: mtl_units_of_measure puom
6209: where rti.interface_transaction_id = l_interface_txn_id

Line 6224: from rcv_transactions_interface

6220:
6221: -- Obtain PO transaction type
6222: select transaction_type
6223: into l_po_txn_type
6224: from rcv_transactions_interface
6225: where interface_transaction_id = l_interface_txn_id;
6226:
6227: if (l_debug = 'Y') then
6228: fnd_file.put_line(fnd_file.log,'PO txn type is ' || l_po_txn_type);