eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CST_EAMCOST_PUB dependencies on RCV_TRANSACTIONS

Line 50: , rcv_transactions rt

46: SELECT msi.outside_operation_uom_type
47: , rt.primary_quantity
48: , rt.transaction_type
49: FROM mtl_system_items msi
50: , rcv_transactions rt
51: , po_lines_all pl
52: WHERE rt.transaction_id = p_rcv_trx_id
53: AND rt.po_line_id = pl.po_line_id
54: AND msi.inventory_item_id = pl.item_id

Line 66: FROM rcv_transactions rt

62: , wor.basis_type
63: , wor.autocharge_type
64: , wor.uom_code
65: , wor.standard_rate_flag
66: FROM rcv_transactions rt
67: , wip_operation_resources wor
68: WHERE rt.transaction_id = p_rcv_trx_id
69: AND wor.wip_entity_id = rt.wip_entity_id
70: AND wor.organization_id = rt.organization_id

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

5960: RAISE fnd_api.g_exc_error;
5961: END IF;
5962:
5963: -- Due to changes in Bug #1926731, p_interface_txn_id now contains the rcv_transaction_id
5964: -- instead of interface_transaction_id. Get the interface_transaction_id from rcv_transactions.
5965: l_stmt_num := 25;
5966:
5967: if(l_debug = 'Y') then
5968: fnd_file.put_line(fnd_file.log,'RCV transaction ID : '||p_interface_txn_id);

Line 5973: FROM rcv_transactions

5969: end if;
5970:
5971: SELECT interface_transaction_id
5972: INTO l_interface_txn_id
5973: FROM rcv_transactions
5974: WHERE transaction_id = p_interface_txn_id;
5975:
5976: IF (l_interface_txn_id IS NULL) THEN
5977: RAISE fnd_api.g_exc_error;

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

6219: l_stmt_num := 20;
6220: l_directItem_rec := p_directItem_rec;
6221:
6222: -- Due to changes in Bug #1926731, l_directItem_rec.rcv_transaction_id now contains the rcv_transaction_id
6223: -- instead of interface_transaction_id. Get the interface_transaction_id from rcv_transactions.
6224: l_stmt_num := 25;
6225:
6226: l_txn_id := l_directItem_rec.rcv_transaction_id;
6227: if(l_debug = 'Y') then

Line 6237: FROM rcv_transactions

6233: instead of the source_doc_quantity results in an incorrect actual_res_rate
6234: when it is converted to the primary_uom */
6235: SELECT interface_transaction_id, source_doc_quantity /*, primary_quantity*/
6236: INTO l_interface_txn_id, l_quantity /*, l_primary_quantity*/
6237: FROM rcv_transactions
6238: WHERE transaction_id = l_txn_id;
6239:
6240: IF (l_interface_txn_id IS NULL) THEN
6241: RAISE fnd_api.g_exc_error;

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

6370: l_directItem_rec.transaction_uom,
6371: l_directItem_rec.wip_entity_id,
6372: l_item_id,
6373: l_source_doc_unit_of_measure
6374: from rcv_transactions rti,
6375: po_distributions_all pod,
6376: po_lines_all pol
6377: where rti.transaction_id = l_txn_id
6378: and rti.po_distribution_id = pod.po_distribution_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);

Line 7534: rcv_transactions rt,

7530: DECODE(p_acct_line_type,15,encumbrance_type_id,NULL) --Bug 9356654 WIP Encumbrance enhancement Change 3
7531: FROM wip_cost_txn_interface wcti,
7532: po_distributions_all pod,
7533: po_headers_all poh,
7534: rcv_transactions rt,
7535: fnd_currencies fc
7536: WHERE wcti.transaction_id = p_txn_id
7537: AND poh.po_header_id = wcti.po_header_id
7538: AND poh.po_header_id = pod.po_header_id

Line 9321: from rcv_transactions

9317:
9318: If (l_rcv_txn_id <> -1) then
9319: select po_release_id
9320: into l_po_release_id
9321: from rcv_transactions
9322: where transaction_id = l_rcv_txn_id;
9323: Else
9324: l_api_message := 'No rcv_transaction_id exist for transaction ID: ' || TO_CHAR(p_txn_id);
9325: l_api_message := l_api_message || ' wip_cost_txn_interface ';

Line 11127: rcv_transactions RT

11123: FROM po_headers_all POH,
11124: po_line_locations_all POLL,
11125: po_lines_all POL,
11126: po_distributions_all POD,
11127: rcv_transactions RT
11128: WHERE RT.transaction_id = p_receiving_transaction_id
11129: AND POH.po_header_id = RT.po_header_id
11130: AND POLL.line_location_id = RT.po_line_location_id
11131: AND POL.po_line_id = RT.po_line_id