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.INV_RCV_STD_INSPECT_APIS dependencies on RCV_SHIPMENT_HEADERS

Line 1136: FROM rcv_supply rs, rcv_transactions rt, rcv_shipment_headers rsh

1132: IS
1133: SELECT rs.rcv_transaction_id, rsh.receipt_source_code,
1134: rs.unit_of_measure,
1135: rs.secondary_unit_of_measure --OPM Convergence
1136: FROM rcv_supply rs, rcv_transactions rt, rcv_shipment_headers rsh
1137: WHERE rs.rcv_transaction_id = rt.transaction_id
1138: AND rsh.shipment_header_id = rs.shipment_header_id
1139: AND rs.supply_type_code = 'RECEIVING'
1140: AND rt.transaction_type <> 'UNORDERED'

Line 1163: rcv_shipment_headers rsh

1159: rls.quantity quantity
1160: FROM rcv_supply rs,
1161: rcv_lots_supply rls,
1162: rcv_transactions rt,
1163: rcv_shipment_headers rsh
1164: WHERE rs.rcv_transaction_id = rt.transaction_id
1165: AND rsh.shipment_header_id = rs.shipment_header_id
1166: AND rs.supply_type_code = 'RECEIVING'
1167: AND rt.transaction_type <> 'UNORDERED'

Line 1403: rcv_shipment_headers rsh

1399: BULK COLLECT INTO t_tmp_tbl
1400: FROM rcv_supply rs,
1401: rcv_serials_supply rss,
1402: rcv_transactions rt,
1403: rcv_shipment_headers rsh
1404: WHERE rs.rcv_transaction_id = rt.transaction_id
1405: and rs.rcv_transaction_id = nvl(l_mol_txn_src_id, rs.rcv_transaction_id)
1406: and decode(l_mol_ref_code,4,Decode(l_mol_ref, 'PO_LINE_LOCATION_ID',rs.po_line_location_id,'SHIPMENT_LINE_ID',rs.shipment_line_id), -- 13597819
1407: 6,rs.shipment_line_id, -- 13597819 For Intransit

Line 2245: FROM rcv_supply rs, rcv_transactions rt, rcv_shipment_headers rsh,rcv_shipment_lines rsl --BugFix:14554730

2241: SELECT rs.rcv_transaction_id
2242: , rsh.receipt_source_code
2243: , rs.unit_of_measure
2244: , rs.secondary_unit_of_measure --OPM Convergence
2245: FROM rcv_supply rs, rcv_transactions rt, rcv_shipment_headers rsh,rcv_shipment_lines rsl --BugFix:14554730
2246: WHERE rs.rcv_transaction_id = rt.transaction_id
2247: AND rsl.shipment_line_id = rs.shipment_line_id --BugFix:14554730
2248: AND rsh.shipment_header_id = rs.shipment_header_id
2249: AND ((rsl.shipment_line_id = k_reference_id AND k_reference='SHIPMENT_LINE_ID') --BugFix:14554730

Line 2272: FROM rcv_supply rs, rcv_lots_supply rls, rcv_transactions rt, rcv_shipment_headers rsh

2268: , rsh.receipt_source_code
2269: , rs.unit_of_measure
2270: , rs.secondary_unit_of_measure --OPM Convergence
2271: , Sum(rls.quantity) quantity --Bug 14117094
2272: FROM rcv_supply rs, rcv_lots_supply rls, rcv_transactions rt, rcv_shipment_headers rsh
2273: WHERE rs.rcv_transaction_id = rt.transaction_id
2274: AND rsh.shipment_header_id = rs.shipment_header_id
2275: AND rs.supply_type_code = 'RECEIVING'
2276: AND rt.transaction_type <> 'UNORDERED'

Line 2298: FROM rcv_supply rs, rcv_serials_supply rss, rcv_transactions rt, rcv_shipment_headers rsh

2294: SELECT rs.rcv_transaction_id
2295: , rsh.receipt_source_code
2296: , rs.unit_of_measure
2297: , rs.secondary_unit_of_measure --OPM Convergence
2298: FROM rcv_supply rs, rcv_serials_supply rss, rcv_transactions rt, rcv_shipment_headers rsh
2299: WHERE rs.rcv_transaction_id = rt.transaction_id
2300: -- added 12942776 start
2301: and rs.rcv_transaction_id = nvl(l_mol_txn_src_id, rs.rcv_transaction_id)
2302: AND DECODE(l_mol_ref_code,4, Decode(l_mol_ref, 'PO_LINE_LOCATION_ID' , rs.po_line_location_id,

Line 3489: from rcv_supply rs, rcv_transactions rt, rcv_shipment_headers rsh

3485: rs.rcv_transaction_id
3486: , rsh.receipt_source_code
3487: , rs.unit_of_measure
3488: , rs.secondary_unit_of_measure --OPM Convergence
3489: from rcv_supply rs, rcv_transactions rt, rcv_shipment_headers rsh
3490: where rs.po_header_id = k_po_header_id
3491: and rs.to_organization_id = k_organization_id
3492: and rs.item_id = k_inventory_item_id
3493: and (k_revision_control = 2

Line 3904: from rcv_supply rs, rcv_transactions rt, rcv_shipment_headers rsh

3900: rs.rcv_transaction_id
3901: , rsh.receipt_source_code
3902: , rs.unit_of_measure
3903: , rs.secondary_unit_of_measure --OPM Convergence
3904: from rcv_supply rs, rcv_transactions rt, rcv_shipment_headers rsh
3905: where rsh.receipt_source_code <> 'VENDOR'
3906: and rs.shipment_header_id = k_shipment_header_id
3907: and rs.to_organization_id = k_organization_id
3908: and rs.item_id = k_inventory_item_id

Line 4321: from rcv_supply rs, rcv_transactions rt, rcv_shipment_headers rsh

4317: rs.rcv_transaction_id
4318: , rsh.receipt_source_code
4319: , rs.unit_of_measure
4320: , rs.secondary_unit_of_measure --OPM Convergence
4321: from rcv_supply rs, rcv_transactions rt, rcv_shipment_headers rsh
4322: where rsh.receipt_source_code = 'CUSTOMER'
4323: and rs.oe_order_header_id = k_oe_order_header_id
4324: and rs.to_organization_id = k_organization_id
4325: and rs.item_id = k_inventory_item_id

Line 4735: from rcv_supply rs, rcv_transactions rt, rcv_shipment_headers rsh

4731: rs.rcv_transaction_id
4732: , rsh.receipt_source_code
4733: , rs.unit_of_measure
4734: , rs.secondary_unit_of_measure --OPM Convergence
4735: from rcv_supply rs, rcv_transactions rt, rcv_shipment_headers rsh
4736: where rsh.receipt_num = k_receipt_num
4737: and rs.to_organization_id = k_organization_id
4738: and rs.item_id = k_inventory_item_id
4739: and (k_revision_control = 2

Line 5299: ,rcv_shipment_headers rsh

5295: , l_customer_id
5296: , l_customer_site_id
5297: , l_customer_item_number
5298: FROM rcv_supply rsup
5299: ,rcv_shipment_headers rsh
5300: ,rcv_shipment_lines rsl
5301: ,rcv_transactions rt
5302: ,po_line_locations pll
5303: ,po_lines pol

Line 5326: FROM rcv_shipment_headers

5322: print_debug('IN INSERT_INSPECT_REC_RTF ',9);
5323: END IF;
5324: SELECT receipt_num
5325: INTO l_receipt_num
5326: FROM rcv_shipment_headers
5327: WHERE shipment_header_id = l_shipment_hdr_id
5328: AND ship_to_org_id = p_organization_id;
5329:
5330: inv_rcv_common_apis.g_rcv_global_var.receipt_num := l_receipt_num;

Line 6583: from mtl_txn_request_lines mtrl, rcv_transactions rt, rcv_shipment_headers rsh

6579: begin
6580: -- obtain receipt number
6581: select distinct rsh.receipt_num, '0'
6582: into x_receipt_number, x_receipt_return_status
6583: from mtl_txn_request_lines mtrl, rcv_transactions rt, rcv_shipment_headers rsh
6584: where reference = 'PO_LINE_LOCATION_ID'
6585: and mtrl.reference_id = rt.po_line_location_id
6586: and mtrl.quantity > nvl(mtrl.quantity_delivered, 0)
6587: and rt.shipment_header_id = rsh.shipment_header_id

Line 6665: from mtl_txn_request_lines mtrl, rcv_transactions rt, rcv_shipment_headers rsh

6661: begin
6662: --obtain the receipt number
6663: select distinct rsh.receipt_num, '0'
6664: into x_receipt_number, x_receipt_return_status
6665: from mtl_txn_request_lines mtrl, rcv_transactions rt, rcv_shipment_headers rsh
6666: where reference = 'ORDER_LINE_ID'
6667: and mtrl.reference_id = rt.oe_order_line_id
6668: and mtrl.quantity > nvl(mtrl.quantity_delivered, 0)
6669: and rt.shipment_header_id = rsh.shipment_header_id

Line 6723: from mtl_txn_request_lines mtrl, rcv_shipment_lines rsl, rcv_shipment_headers rsh

6719: x_msg_data := ' ';
6720:
6721: select distinct rsl.shipment_header_id, rsh.shipment_num, rsh.receipt_num
6722: into x_intshp_id, x_intshp_number, x_receipt_number
6723: from mtl_txn_request_lines mtrl, rcv_shipment_lines rsl, rcv_shipment_headers rsh
6724: where reference = 'SHIPMENT_LINE_ID'
6725: and mtrl.quantity > nvl(mtrl.quantity_delivered, 0)
6726: and mtrl.reference_id = rsl.shipment_line_id
6727: and rsl.shipment_header_id = rsh.shipment_header_id