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_MATERIAL_STATUS_GRP dependencies on WMS_LICENSE_PLATE_NUMBERS

Line 92: FROM wms_license_plate_numbers plpn

88: SELECT *
89: FROM wms_lpn_contents wlc
90: WHERE wlc.parent_lpn_id IN
91: (SELECT lpn_id
92: FROM wms_license_plate_numbers plpn
93: start with lpn_id = p_fromlpn_id
94: connect by parent_lpn_id = prior lpn_id
95: );
96:

Line 120: from wms_license_plate_numbers where lpn_id = p_xfer_lpn_id

116: l_xfer_org_id := p_xfer_org_id;
117:
118: SELECT lpn_context
119: into l_xferlpn_context
120: from wms_license_plate_numbers where lpn_id = p_xfer_lpn_id
121: AND EXISTS(select 1 from mtl_onhand_quantities_detail moqd
122: where moqd.organization_id = p_xfer_org_id
123: AND moqd.lpn_id IN
124: (

Line 126: FROM wms_license_plate_numbers

122: where moqd.organization_id = p_xfer_org_id
123: AND moqd.lpn_id IN
124: (
125: SELECT lpn_id
126: FROM wms_license_plate_numbers
127: WHERE outermost_lpn_id =
128: (SELECT outermost_lpn_id
129: FROM wms_license_plate_numbers
130: WHERE lpn_id = p_xfer_lpn_id

Line 129: FROM wms_license_plate_numbers

125: SELECT lpn_id
126: FROM wms_license_plate_numbers
127: WHERE outermost_lpn_id =
128: (SELECT outermost_lpn_id
129: FROM wms_license_plate_numbers
130: WHERE lpn_id = p_xfer_lpn_id
131: )
132: ));
133: inv_trx_util_pub.TRACE('mixed status: .. 1.1.1 - l_xferlpn_context'||l_xferlpn_context,'Material Status', 9);

Line 147: from wms_license_plate_numbers where lpn_id = p_xfer_lpn_id;

143: IF (l_xfer_locator_id is NULL or l_xfer_locator_id <= 0) AND l_xferlpn_context <> 5 THEN
144: BEGIN
145: SELECT subinventory_code,locator_id,organization_id
146: into l_xfer_sub_code,l_xfer_locator_id,l_xfer_org_id
147: from wms_license_plate_numbers where lpn_id = p_xfer_lpn_id;
148: EXCEPTION
149: WHEN NO_DATA_FOUND THEN
150: l_xferlpn_context := 5;
151: inv_trx_util_pub.TRACE('mixed status: .. 2.1','Material Status', 9);

Line 162: from wms_license_plate_numbers

158: --for bug 6918618
159: IF p_fromlpn_id is NOT NULL and p_inventory_item_id IS NOT NULL AND (p_trx_type_id = 42 OR p_trx_type_id = 41) AND l_allow_mixed_status = 2 THEN --7173146
160: BEGIN
161: select lpn_context into l_lpn_context
162: from wms_license_plate_numbers
163: where lpn_id = p_fromlpn_id;
164:
165: inv_trx_util_pub.TRACE('l_lpn_context::'||l_lpn_context,'Material Status', 9);
166: EXCEPTION

Line 198: FROM wms_license_plate_numbers

194: WHERE moqddst.organization_id = p_organization_id
195: AND moqddst.lpn_id IN
196: (
197: SELECT lpn_id
198: FROM wms_license_plate_numbers
199: WHERE outermost_lpn_id =
200: (SELECT outermost_lpn_id
201: FROM wms_license_plate_numbers
202: WHERE lpn_id = p_fromlpn_id

Line 201: FROM wms_license_plate_numbers

197: SELECT lpn_id
198: FROM wms_license_plate_numbers
199: WHERE outermost_lpn_id =
200: (SELECT outermost_lpn_id
201: FROM wms_license_plate_numbers
202: WHERE lpn_id = p_fromlpn_id
203: )
204: ));
205: inv_trx_util_pub.TRACE('l_allow_status::::'||l_allow_status,'Material Status', 9);

Line 269: FROM wms_license_plate_numbers

265: WHERE moqddst.organization_id = l_xfer_org_id
266: AND moqddst.lpn_id IN
267: (
268: SELECT lpn_id
269: FROM wms_license_plate_numbers
270: WHERE outermost_lpn_id =
271: (SELECT outermost_lpn_id
272: FROM wms_license_plate_numbers
273: WHERE lpn_id = p_xfer_lpn_id

Line 272: FROM wms_license_plate_numbers

268: SELECT lpn_id
269: FROM wms_license_plate_numbers
270: WHERE outermost_lpn_id =
271: (SELECT outermost_lpn_id
272: FROM wms_license_plate_numbers
273: WHERE lpn_id = p_xfer_lpn_id
274: )
275: )
276: );

Line 301: FROM wms_license_plate_numbers plpn

297: AND moqdsrc.locator_id = p_locator_id
298: -- AND NVL(moqdsrc.lot_number,'@@@') = NVL(p_lot_number,'@@@')
299: AND moqdsrc.lpn_id IN
300: (SELECT lpn_id
301: FROM wms_license_plate_numbers plpn
302: START WITH lpn_id = p_fromlpn_id CONNECT BY parent_lpn_id = prior lpn_id
303: AND plpn.organization_id = p_organization_id
304: )
305: UNION --bug 10427776

Line 321: FROM wms_license_plate_numbers

317: WHERE moqddst.organization_id = l_xfer_org_id
318: AND moqddst.lpn_id IN
319: (
320: SELECT lpn_id
321: FROM wms_license_plate_numbers
322: WHERE outermost_lpn_id =
323: (SELECT outermost_lpn_id
324: FROM wms_license_plate_numbers
325: WHERE lpn_id = p_xfer_lpn_id

Line 324: FROM wms_license_plate_numbers

320: SELECT lpn_id
321: FROM wms_license_plate_numbers
322: WHERE outermost_lpn_id =
323: (SELECT outermost_lpn_id
324: FROM wms_license_plate_numbers
325: WHERE lpn_id = p_xfer_lpn_id
326: )
327: )
328: UNION --bug 10427776

Line 497: FROM wms_license_plate_numbers plpn

493: AND moqd.locator_id = p_locator_id
494: -- AND NVL(moqd.lot_number,'@@@') = NVL(p_lot_number,'@@@')
495: AND moqd.lpn_id IN
496: (SELECT lpn_id
497: FROM wms_license_plate_numbers plpn
498: START WITH lpn_id = p_fromlpn_id CONNECT BY parent_lpn_id = prior lpn_id
499: AND plpn.organization_id = p_organization_id
500: )
501: AND moqd.status_id = mtc.status_id

Line 527: FROM wms_license_plate_numbers START

523: mtl_serial_numbers msn,
524: mtl_status_transaction_control mtc
525: WHERE wlc.parent_lpn_id IN
526: (SELECT lpn_id
527: FROM wms_license_plate_numbers START
528: WITH lpn_id = p_fromlpn_id CONNECT BY parent_lpn_id = PRIOR lpn_id
529: AND organization_id = p_organization_id
530: )
531: AND wlc.serial_summary_entry = 1

Line 3259: FROM wms_license_plate_numbers plpn

3255: SELECT *
3256: FROM wms_lpn_contents wlc
3257: WHERE wlc.parent_lpn_id IN
3258: (SELECT lpn_id
3259: FROM wms_license_plate_numbers plpn
3260: start with lpn_id = p_lpn_id
3261: connect by parent_lpn_id = prior lpn_id
3262: )
3263: ORDER BY wlc.serial_summary_entry DESC ;

Line 3307: FROM wms_license_plate_numbers wlpn

3303:
3304: BEGIN
3305: SELECT wlpn.organization_id , wlpn.subinventory_code , wlpn.locator_id , wlpn.lpn_context into
3306: l_lpn_org_id , l_lpn_sub ,l_lpn_loc ,l_lpn_context
3307: FROM wms_license_plate_numbers wlpn
3308: where lpn_id = p_lpn_id;
3309: EXCEPTION
3310: WHEN NO_DATA_FOUND THEN
3311: if(g_debug = 1)THEN

Line 3748: FROM wms_license_plate_numbers plpn

3744: SELECT *
3745: FROM mtl_txn_request_lines mtrl
3746: WHERE mtrl.lpn_id IN
3747: (SELECT lpn_id
3748: FROM wms_license_plate_numbers plpn
3749: start with lpn_id = p_fromlpn_id
3750: connect by parent_lpn_id = prior lpn_id
3751: )
3752: AND Nvl(l_cur_inventory_item_id,inventory_item_id)=inventory_item_id

Line 3767: FROM wms_license_plate_numbers plpn

3763: WHERE wlc.parent_lpn_id IN
3764: (SELECT
3765: /*+ unnest cardinality(plpn, 1) */
3766: lpn_id
3767: FROM wms_license_plate_numbers plpn
3768: START WITH lpn_id = p_fromlpn_id
3769: CONNECT BY parent_lpn_id = PRIOR lpn_id
3770: )
3771: AND NVL (l_cur_inventory_item_id, inventory_item_id) = inventory_item_id

Line 3840: FROM wms_license_plate_numbers wlpn

3836: BEGIN
3837:
3838: SELECT wlpn.organization_id , wlpn.subinventory_code , wlpn.locator_id , wlpn.lpn_context into
3839: l_lpn_org_id , l_lpn_sub ,l_lpn_loc ,l_lpn_context
3840: FROM wms_license_plate_numbers wlpn
3841: where lpn_id = p_fromlpn_id;
3842: EXCEPTION
3843: WHEN NO_DATA_FOUND THEN
3844: IF(g_debug = 1)THEN