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_SUPPLY

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 1160: FROM rcv_supply rs,

1156: rs.unit_of_measure,
1157: rs.secondary_unit_of_measure --OPM Convergence
1158: ,
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

Line 1400: FROM rcv_supply rs,

1396: rs.unit_of_measure,
1397: rs.secondary_unit_of_measure,
1398: COUNT (rs.rcv_transaction_id)
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

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 5298: FROM rcv_supply rsup

5294: , l_oe_order_line_id
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

Line 6122: FROM rcv_supply rs

6118: -- bug 8405606 removed the condition for rt.inspection_status_code = 'NOT INSPECTED'
6119:
6120: CURSOR c_po_source_lines IS
6121: SELECT rs.rcv_transaction_id
6122: FROM rcv_supply rs
6123: , rcv_transactions rt
6124: WHERE rs.item_id = p_item_id
6125: AND rs.po_header_id = p_po_header_id
6126: AND nvl(rs.po_release_id,-1) = nvl(p_po_release_id,nvl(rs.po_release_id,-1))

Line 6138: FROM rcv_supply rs

6134:
6135: -- use this for receipts also --
6136: CURSOR c_intship_source_lines IS
6137: SELECT rs.rcv_transaction_id
6138: FROM rcv_supply rs
6139: , rcv_transactions rt
6140: WHERE rs.item_id = p_item_id
6141: AND rs.shipment_header_id = p_shipment_header_id
6142: AND rs.rcv_transaction_id = rt.transaction_id

Line 6149: FROM rcv_supply rs

6145: AND rt.routing_header_id = 2; /* Inspection routing */
6146:
6147: CURSOR c_rma_source_lines IS
6148: SELECT rs.rcv_transaction_id
6149: FROM rcv_supply rs
6150: , rcv_transactions rt
6151: WHERE rs.item_id = p_item_id
6152: AND rs.oe_order_header_id = p_oe_order_header_id
6153: AND rs.rcv_transaction_id = rt.transaction_id

Line 6782: FROM rcv_supply rs

6778: IF (p_source_type = 'PO') THEN
6779: BEGIN
6780: SELECT 1
6781: INTO l_count
6782: FROM rcv_supply rs
6783: , rcv_transactions rt
6784: WHERE rs.item_id = p_item_id
6785: AND rs.item_revision IS NULL
6786: AND rs.po_header_id = p_source_id

Line 6800: FROM rcv_supply rs

6796: ELSE IF (p_source_type IN ('INTSHIP', 'RECEIPT')) THEN
6797: BEGIN
6798: SELECT 1
6799: INTO l_count
6800: FROM rcv_supply rs
6801: , rcv_transactions rt
6802: WHERE rs.item_id = p_item_id
6803: AND rs.item_revision IS NULL
6804: AND rs.shipment_header_id = p_source_id

Line 6818: FROM rcv_supply rs

6814: ELSE IF (p_source_type = 'RMA') THEN
6815: BEGIN
6816: SELECT 1
6817: INTO l_count
6818: FROM rcv_supply rs
6819: , rcv_transactions rt
6820: WHERE rs.item_id = p_item_id
6821: AND rs.item_revision IS NULL
6822: AND rs.oe_order_header_id = p_source_id