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_INTEGRATION_PVT dependencies on RCV_SUPPLY

Line 11235: FROM rcv_supply rs

11231: )
11232: , NULL) inspection_status
11233: , rt.project_id project_id
11234: , rt.task_id task_id
11235: FROM rcv_supply rs
11236: , rcv_lots_supply rls
11237: , rcv_transactions rt
11238: WHERE rs.lpn_id = v_lpn_id
11239: AND rs.rcv_transaction_id = rls.transaction_id (+)

Line 11277: FROM rcv_supply rs

11273: )
11274: , NULL) inspection_status
11275: , rt.project_id project_id
11276: , rt.task_id task_id
11277: FROM rcv_supply rs
11278: , rcv_serials_supply rss
11279: , rcv_transactions rt
11280: WHERE rs.lpn_id = v_lpn_id
11281: AND rs.rcv_transaction_id = rss.transaction_id

Line 12166: from rcv_supply rs

12162: BEGIN
12163:
12164: select lpn_id
12165: into x_lpn_id
12166: from rcv_supply rs
12167: where rs.supply_source_id = p_txn_id
12168: and ( (p_lpn_id is not null and rs.lpn_id = p_lpn_id) or (p_lpn_id is null) )
12169: and rownum = 1 ;
12170:

Line 13317: l_rs_ptid_ptid_lpn_id NUMBER; -- Variable to hold the lpn_id from rcv_supply for parent_parent_txn_id

13313: l_parent_parent_txn_id NUMBER;
13314: l_parent_parent_parent_txn_id NUMBER;
13315: l_parent_parent_txn_type VARCHAR2(30);
13316:
13317: l_rs_ptid_ptid_lpn_id NUMBER; -- Variable to hold the lpn_id from rcv_supply for parent_parent_txn_id
13318: l_rs_ptid_ptid_exists Boolean; -- Variable to indicate whether their Exists a supply for the Parent_parent_txn_Id
13319:
13320: l_rs_ptid_ptid_ptid_lpn_id NUMBER; -- Variable to hold the lpn_id from rcv_supply for parent_parent_txn_id
13321: l_rs_ptid_ptid_ptid_exists Boolean; -- Variable to indicate whether their

Line 13320: l_rs_ptid_ptid_ptid_lpn_id NUMBER; -- Variable to hold the lpn_id from rcv_supply for parent_parent_txn_id

13316:
13317: l_rs_ptid_ptid_lpn_id NUMBER; -- Variable to hold the lpn_id from rcv_supply for parent_parent_txn_id
13318: l_rs_ptid_ptid_exists Boolean; -- Variable to indicate whether their Exists a supply for the Parent_parent_txn_Id
13319:
13320: l_rs_ptid_ptid_ptid_lpn_id NUMBER; -- Variable to hold the lpn_id from rcv_supply for parent_parent_txn_id
13321: l_rs_ptid_ptid_ptid_exists Boolean; -- Variable to indicate whether their
13322: -- Exists a supply for the Parent parent txn Id and the Tranfer LPN
13323:
13324: l_rs_ptid_lpn_id NUMBER; -- Variable to hold the lpn_id from rcv_supply for parent_txn_id

Line 13324: l_rs_ptid_lpn_id NUMBER; -- Variable to hold the lpn_id from rcv_supply for parent_txn_id

13320: l_rs_ptid_ptid_ptid_lpn_id NUMBER; -- Variable to hold the lpn_id from rcv_supply for parent_parent_txn_id
13321: l_rs_ptid_ptid_ptid_exists Boolean; -- Variable to indicate whether their
13322: -- Exists a supply for the Parent parent txn Id and the Tranfer LPN
13323:
13324: l_rs_ptid_lpn_id NUMBER; -- Variable to hold the lpn_id from rcv_supply for parent_txn_id
13325: l_rs_ptid_exists Boolean; -- Variable to indicate whether their Exists a supply for the parent txn Id
13326:
13327:
13328: l_cur_from_parent_lpn_id NUMBER;

Line 14721: -- START CHECKING IN RCV_SUPPLY

14717: RAISE FND_API.G_EXC_ERROR;
14718: End if;
14719: l_progress := 'WMSINB-19142';
14720: --
14721: -- START CHECKING IN RCV_SUPPLY
14722: -- IF RS.PTID.TLPN NOT EXISTS THEN FAIL TXN
14723:
14724: if ( (l_rs_ptid_Exists <> TRUE) or ( nvl(l_lpn_rec.transfer_lpn_id,0) <>
14725: nvl(l_rs_ptid_lpn_id,-9999)) ) then