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: )

Line 314: FROM wms_license_plate_numbers

310: WHERE moqddst.organization_id = l_xfer_org_id
311: AND moqddst.lpn_id IN
312: (
313: SELECT lpn_id
314: FROM wms_license_plate_numbers
315: WHERE outermost_lpn_id =
316: (SELECT outermost_lpn_id
317: FROM wms_license_plate_numbers
318: WHERE lpn_id = p_xfer_lpn_id

Line 317: FROM wms_license_plate_numbers

313: SELECT lpn_id
314: FROM wms_license_plate_numbers
315: WHERE outermost_lpn_id =
316: (SELECT outermost_lpn_id
317: FROM wms_license_plate_numbers
318: WHERE lpn_id = p_xfer_lpn_id
319: )
320: )
321: ));

Line 483: FROM wms_license_plate_numbers plpn

479: AND moqd.locator_id = p_locator_id
480: -- AND NVL(moqd.lot_number,'@@@') = NVL(p_lot_number,'@@@')
481: AND moqd.lpn_id IN
482: (SELECT lpn_id
483: FROM wms_license_plate_numbers plpn
484: START WITH lpn_id = p_fromlpn_id CONNECT BY parent_lpn_id = prior lpn_id
485: AND plpn.organization_id = p_organization_id
486: )
487: AND moqd.status_id = mtc.status_id

Line 513: FROM wms_license_plate_numbers START

509: mtl_serial_numbers msn,
510: mtl_status_transaction_control mtc
511: WHERE wlc.parent_lpn_id IN
512: (SELECT lpn_id
513: FROM wms_license_plate_numbers START
514: WITH lpn_id = p_fromlpn_id CONNECT BY parent_lpn_id = PRIOR lpn_id
515: AND organization_id = p_organization_id
516: )
517: AND wlc.serial_summary_entry = 1

Line 2728: FROM wms_license_plate_numbers plpn

2724: SELECT *
2725: FROM wms_lpn_contents wlc
2726: WHERE wlc.parent_lpn_id IN
2727: (SELECT lpn_id
2728: FROM wms_license_plate_numbers plpn
2729: start with lpn_id = p_lpn_id
2730: connect by parent_lpn_id = prior lpn_id
2731: )
2732: ORDER BY wlc.serial_summary_entry DESC ;

Line 2776: FROM wms_license_plate_numbers wlpn

2772:
2773: BEGIN
2774: SELECT wlpn.organization_id , wlpn.subinventory_code , wlpn.locator_id , wlpn.lpn_context into
2775: l_lpn_org_id , l_lpn_sub ,l_lpn_loc ,l_lpn_context
2776: FROM wms_license_plate_numbers wlpn
2777: where lpn_id = p_lpn_id;
2778: EXCEPTION
2779: WHEN NO_DATA_FOUND THEN
2780: if(g_debug = 1)THEN

Line 3217: FROM wms_license_plate_numbers plpn

3213: SELECT *
3214: FROM mtl_txn_request_lines mtrl
3215: WHERE mtrl.lpn_id IN
3216: (SELECT lpn_id
3217: FROM wms_license_plate_numbers plpn
3218: start with lpn_id = p_fromlpn_id
3219: connect by parent_lpn_id = prior lpn_id
3220: )
3221: AND Nvl(l_cur_inventory_item_id,inventory_item_id)=inventory_item_id

Line 3232: FROM wms_license_plate_numbers plpn

3228: SELECT *
3229: FROM wms_lpn_contents wlc
3230: WHERE wlc.parent_lpn_id IN
3231: (SELECT lpn_id
3232: FROM wms_license_plate_numbers plpn
3233: start with lpn_id = p_fromlpn_id
3234: connect by parent_lpn_id = prior lpn_id
3235: )
3236: AND Nvl(l_cur_inventory_item_id,inventory_item_id)=inventory_item_id

Line 3304: FROM wms_license_plate_numbers wlpn

3300: BEGIN
3301:
3302: SELECT wlpn.organization_id , wlpn.subinventory_code , wlpn.locator_id , wlpn.lpn_context into
3303: l_lpn_org_id , l_lpn_sub ,l_lpn_loc ,l_lpn_context
3304: FROM wms_license_plate_numbers wlpn
3305: where lpn_id = p_fromlpn_id;
3306: EXCEPTION
3307: WHEN NO_DATA_FOUND THEN
3308: IF(g_debug = 1)THEN