APPS.CST_EAMCOST_PUB dependencies on RCV_TRANSACTIONS

Line 5668: -- instead of interface_transaction_id. Get the interface_transaction_id from rcv_transactions.

5664: RAISE fnd_api.g_exc_error;
5665: END IF;
5666:
5667: -- Due to changes in Bug #1926731, p_interface_txn_id now contains the rcv_transaction_id
5668: -- instead of interface_transaction_id. Get the interface_transaction_id from rcv_transactions.
5669: l_stmt_num := 25;
5670:
5671: if(l_debug = 'Y') then
5672: fnd_file.put_line(fnd_file.log,'RCV transaction ID : '||p_interface_txn_id);

Line 5677: FROM rcv_transactions

5673: end if;
5674:
5675: SELECT interface_transaction_id
5676: INTO l_interface_txn_id
5677: FROM rcv_transactions
5678: WHERE transaction_id = p_interface_txn_id;
5679:
5680: IF (l_interface_txn_id IS NULL) THEN
5681: RAISE fnd_api.g_exc_error;

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 5918: -- instead of interface_transaction_id. Get the interface_transaction_id from rcv_transactions.

5914: l_stmt_num := 20;
5915: l_directItem_rec := p_directItem_rec;
5916:
5917: -- Due to changes in Bug #1926731, l_directItem_rec.rcv_transaction_id now contains the rcv_transaction_id
5918: -- instead of interface_transaction_id. Get the interface_transaction_id from rcv_transactions.
5919: l_stmt_num := 25;
5920:
5921: l_txn_id := l_directItem_rec.rcv_transaction_id;
5922: if(l_debug = 'Y') then

Line 5932: FROM rcv_transactions

5928: instead of the source_doc_quantity results in an incorrect actual_res_rate
5929: when it is converted to the primary_uom */
5930: SELECT interface_transaction_id, source_doc_quantity /*, primary_quantity*/
5931: INTO l_interface_txn_id, l_quantity /*, l_primary_quantity*/
5932: FROM rcv_transactions
5933: WHERE transaction_id = l_txn_id;
5934:
5935: IF (l_interface_txn_id IS NULL) THEN
5936: RAISE fnd_api.g_exc_error;

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 6057: from rcv_transactions rti,

6053: l_directItem_rec.transaction_uom,
6054: l_directItem_rec.wip_entity_id,
6055: l_item_id,
6056: l_source_doc_unit_of_measure
6057: from rcv_transactions rti,
6058: po_distributions_all pod,
6059: po_lines_all pol
6060: where rti.transaction_id = l_txn_id
6061: and rti.po_distribution_id = pod.po_distribution_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);

Line 8718: from rcv_transactions

8714:
8715: If (l_rcv_txn_id <> -1) then
8716: select po_release_id
8717: into l_po_release_id
8718: from rcv_transactions
8719: where transaction_id = l_rcv_txn_id;
8720: Else
8721: l_api_message := 'No rcv_transaction_id exist for transaction ID: ' || TO_CHAR(p_txn_id);
8722: l_api_message := l_api_message || ' wip_cost_txn_interface ';