APPS.CST_EAMCOST_PUB dependencies on RCV_TRANSACTIONS_INTERFACE

Line 5992: FROM rcv_transactions_interface

5988: to_organization_id
5989: INTO l_wip_entity_id,
5990: l_item_id,
5991: l_org_id
5992: FROM rcv_transactions_interface
5993: WHERE interface_transaction_id = l_interface_txn_id;
5994:
5995: if (l_debug = 'Y') then
5996: fnd_file.put_line(fnd_file.log,'WE: ' || to_char(l_wip_entity_id));

Line 6276: rcv_transactions_interface rti,

6272: l_curr_rate,
6273: l_curr_code,
6274: l_po_order_type_lookup_code
6275: from po_distributions_all pod,
6276: rcv_transactions_interface rti,
6277: po_lines_all pol
6278: where rti.interface_transaction_id = l_interface_txn_id
6279: and pod.po_distribution_id = rti.po_distribution_id
6280: and pol.po_header_id=pod.po_header_id

Line 6559: from rcv_transactions_interface rti,

6555: l_directItem_rec.transaction_type,
6556: l_directItem_rec.transaction_uom,
6557: l_directItem_rec.usage_rate_or_amount,
6558: l_directItem_rec.wip_entity_id
6559: from rcv_transactions_interface rti,
6560: po_distributions_all pod,
6561: mtl_units_of_measure muom,
6562: mtl_units_of_measure puom
6563: where rti.interface_transaction_id = l_interface_txn_id

Line 6578: from rcv_transactions_interface

6574:
6575: -- Obtain PO transaction type
6576: select transaction_type
6577: into l_po_txn_type
6578: from rcv_transactions_interface
6579: where interface_transaction_id = l_interface_txn_id;
6580:
6581: if (l_debug = 'Y') then
6582: fnd_file.put_line(fnd_file.log,'PO txn type is ' || l_po_txn_type);