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

11708: )
11709: , NULL) inspection_status
11710: , rt.project_id project_id
11711: , rt.task_id task_id
11712: FROM rcv_supply rs
11713: , rcv_lots_supply rls
11714: , rcv_transactions rt
11715: WHERE rs.lpn_id = v_lpn_id
11716: AND rs.rcv_transaction_id = rls.transaction_id (+)

Line 11754: FROM rcv_supply rs

11750: )
11751: , NULL) inspection_status
11752: , rt.project_id project_id
11753: , rt.task_id task_id
11754: FROM rcv_supply rs
11755: , rcv_serials_supply rss
11756: , rcv_transactions rt
11757: WHERE rs.lpn_id = v_lpn_id
11758: AND rs.rcv_transaction_id = rss.transaction_id

Line 12740: from rcv_supply rs

12736: BEGIN
12737:
12738: select lpn_id
12739: into x_lpn_id
12740: from rcv_supply rs
12741: where rs.supply_source_id = p_txn_id
12742: and ( (p_lpn_id is not null and rs.lpn_id = p_lpn_id) or (p_lpn_id is null) )
12743: and rownum = 1 ;
12744:

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

13897: l_parent_parent_txn_id NUMBER;
13898: l_parent_parent_parent_txn_id NUMBER;
13899: l_parent_parent_txn_type VARCHAR2(30);
13900:
13901: l_rs_ptid_ptid_lpn_id NUMBER; -- Variable to hold the lpn_id from rcv_supply for parent_parent_txn_id
13902: l_rs_ptid_ptid_exists Boolean; -- Variable to indicate whether their Exists a supply for the Parent_parent_txn_Id
13903:
13904: l_rs_ptid_ptid_ptid_lpn_id NUMBER; -- Variable to hold the lpn_id from rcv_supply for parent_parent_txn_id
13905: l_rs_ptid_ptid_ptid_exists Boolean; -- Variable to indicate whether their

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

13900:
13901: l_rs_ptid_ptid_lpn_id NUMBER; -- Variable to hold the lpn_id from rcv_supply for parent_parent_txn_id
13902: l_rs_ptid_ptid_exists Boolean; -- Variable to indicate whether their Exists a supply for the Parent_parent_txn_Id
13903:
13904: l_rs_ptid_ptid_ptid_lpn_id NUMBER; -- Variable to hold the lpn_id from rcv_supply for parent_parent_txn_id
13905: l_rs_ptid_ptid_ptid_exists Boolean; -- Variable to indicate whether their
13906: -- Exists a supply for the Parent parent txn Id and the Tranfer LPN
13907:
13908: l_rs_ptid_lpn_id NUMBER; -- Variable to hold the lpn_id from rcv_supply for parent_txn_id

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

13904: l_rs_ptid_ptid_ptid_lpn_id NUMBER; -- Variable to hold the lpn_id from rcv_supply for parent_parent_txn_id
13905: l_rs_ptid_ptid_ptid_exists Boolean; -- Variable to indicate whether their
13906: -- Exists a supply for the Parent parent txn Id and the Tranfer LPN
13907:
13908: l_rs_ptid_lpn_id NUMBER; -- Variable to hold the lpn_id from rcv_supply for parent_txn_id
13909: l_rs_ptid_exists Boolean; -- Variable to indicate whether their Exists a supply for the parent txn Id
13910:
13911:
13912: l_cur_from_parent_lpn_id NUMBER;

Line 15424: -- START CHECKING IN RCV_SUPPLY

15420: RAISE FND_API.G_EXC_ERROR;
15421: End if;
15422: l_progress := 'WMSINB-19142';
15423: --
15424: -- START CHECKING IN RCV_SUPPLY
15425: -- IF RS.PTID.TLPN NOT EXISTS THEN FAIL TXN
15426:
15427: if ( (l_rs_ptid_Exists <> TRUE) or ( nvl(l_lpn_rec.transfer_lpn_id,0) <>
15428: nvl(l_rs_ptid_lpn_id,-9999)) ) then