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.

[Home] [Help]

APPS.INV_MATERIAL_STATUS_GRP dependencies on MTL_ONHAND_QUANTITIES_DETAIL

Line 121: AND EXISTS(select 1 from mtl_onhand_quantities_detail moqd

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: (
125: SELECT lpn_id

Line 193: FROM mtl_onhand_quantities_detail moqddst

189: SELECT 'Y'
190: INTO l_allow_status FROM DUAL
191: where l_return_status_id IN
192: (SELECT moqddst.status_id
193: FROM mtl_onhand_quantities_detail moqddst
194: WHERE moqddst.organization_id = p_organization_id
195: AND moqddst.lpn_id IN
196: (
197: SELECT lpn_id

Line 226: FROM mtl_onhand_quantities_detail moqdsrc

222: --Added for Bug 7007389
223: BEGIN
224: SELECT moqdsrc.status_id
225: INTO temp_status_id
226: FROM mtl_onhand_quantities_detail moqdsrc
227: WHERE moqdsrc.organization_id = p_organization_id
228: AND moqdsrc.inventory_item_id = p_inventory_item_id
229: AND moqdsrc.subinventory_code = p_sub_code
230: AND moqdsrc.locator_id = p_locator_id

Line 253: FROM mtl_onhand_quantities_detail moqdsrc

249: IF temp_status_id is NOT NULL THEN
250: inv_trx_util_pub.TRACE('mixed status: inside if .. 10.4','Material Status', 9);
251: SELECT 'Y'
252: INTO l_allow_status
253: FROM mtl_onhand_quantities_detail moqdsrc
254: WHERE moqdsrc.organization_id = p_organization_id
255: AND moqdsrc.inventory_item_id = p_inventory_item_id
256: AND moqdsrc.subinventory_code = p_sub_code
257: AND moqdsrc.locator_id = p_locator_id

Line 264: FROM mtl_onhand_quantities_detail moqddst

260: AND ROWNUM = 1
261: AND moqdsrc.status_id IN
262: (
263: SELECT moqddst.status_id
264: FROM mtl_onhand_quantities_detail moqddst
265: WHERE moqddst.organization_id = l_xfer_org_id
266: AND moqddst.lpn_id IN
267: (
268: SELECT lpn_id

Line 294: FROM mtl_onhand_quantities_detail moqdsrc

290: INTO l_allow_status
291: FROM dual
292: WHERE EXISTS (
293: (SELECT DISTINCT moqdsrc.status_id
294: FROM mtl_onhand_quantities_detail moqdsrc
295: WHERE moqdsrc.organization_id = p_organization_id
296: AND moqdsrc.subinventory_code = p_sub_code
297: AND moqdsrc.locator_id = p_locator_id
298: -- AND NVL(moqdsrc.lot_number,'@@@') = NVL(p_lot_number,'@@@')

Line 316: FROM mtl_onhand_quantities_detail moqddst

312: )
313: MINUS
314: (
315: SELECT DISTINCT moqddst.status_id
316: FROM mtl_onhand_quantities_detail moqddst
317: WHERE moqddst.organization_id = l_xfer_org_id
318: AND moqddst.lpn_id IN
319: (
320: SELECT lpn_id

Line 368: FROM mtl_onhand_quantities_detail moqd,

364: INTO l_allow_transaction
365: FROM dual
366: WHERE EXISTS
367: (SELECT 1
368: FROM mtl_onhand_quantities_detail moqd,
369: mtl_status_transaction_control mtc
370: WHERE moqd.organization_id = p_organization_id
371: AND moqd.inventory_item_id = p_inventory_item_id
372: AND moqd.subinventory_code = p_sub_code

Line 401: FROM mtl_onhand_quantities_detail moqd,

397: INTO l_allow_transaction
398: FROM dual
399: WHERE EXISTS
400: (SELECT 1
401: FROM mtl_onhand_quantities_detail moqd,
402: mtl_status_transaction_control mtc
403: WHERE moqd.organization_id = l_xfer_org_id
404: AND moqd.inventory_item_id = p_inventory_item_id
405: AND NVL(moqd.lot_number,'@@@') = NVL(p_lot_number,'@@@')

Line 429: FROM mtl_onhand_quantities_detail moqd,

425: INTO l_allow_transaction
426: FROM dual
427: WHERE EXISTS
428: (SELECT 1
429: FROM mtl_onhand_quantities_detail moqd,
430: mtl_status_transaction_control mtc
431: WHERE moqd.organization_id = l_xfer_org_id
432: AND moqd.inventory_item_id = p_inventory_item_id
433: AND moqd.subinventory_code = l_xfer_sub_code

Line 489: FROM mtl_onhand_quantities_detail moqd,

485: INTO l_allow_transaction
486: FROM dual
487: WHERE EXISTS
488: (SELECT 1
489: FROM mtl_onhand_quantities_detail moqd,
490: mtl_status_transaction_control mtc
491: WHERE moqd.organization_id = p_organization_id
492: AND moqd.subinventory_code = p_sub_code
493: AND moqd.locator_id = p_locator_id

Line 553: FROM mtl_onhand_quantities_detail moqd,

549: INTO l_allow_transaction
550: FROM dual
551: WHERE EXISTS
552: (SELECT 1
553: FROM mtl_onhand_quantities_detail moqd,
554: mtl_status_transaction_control mtc
555: WHERE moqd.organization_id = l_xfer_org_id
556: AND moqd.lpn_id = p_xfer_lpn_id
557: AND moqd.status_id = mtc.status_id

Line 1090: from mtl_onhand_quantities_detail

1086:
1087:
1088: select nvl(status_id, -1)
1089: into g_isa_sub_status_id
1090: from mtl_onhand_quantities_detail
1091: where inventory_item_id = p_inventory_item_id
1092: and organization_id = p_organization_id
1093: and subinventory_code = p_sub_code
1094: and lot_number is null

Line 1142: from mtl_onhand_quantities_detail moqd

1138: */
1139: begin
1140: select 1, moqd.status_id -- Bug 13984662 added to fetch status_id
1141: into l_count, l_moqd_status_id
1142: from mtl_onhand_quantities_detail moqd
1143: where moqd.inventory_item_id = p_inventory_item_id
1144: and moqd.organization_id = p_organization_id
1145: and moqd.subinventory_code = p_sub_code
1146: and INV_MATERIAL_STATUS_GRP.is_trx_allowed_wrap(

Line 1217: from mtl_onhand_quantities_detail

1213:
1214: begin
1215: select count(distinct status_id)
1216: into count_status_id
1217: from mtl_onhand_quantities_detail
1218: where organization_id = p_organization_id
1219: and subinventory_code = p_sub_code;
1220: --Bug 7126137
1221: --and lot_number is null

Line 1228: from mtl_onhand_quantities_detail

1224:
1225: if ( count_status_id = 1) then
1226: select status_id
1227: into g_isa_sub_status_id
1228: from mtl_onhand_quantities_detail
1229: where organization_id = p_organization_id
1230: and subinventory_code = p_sub_code
1231: --Bug 7126137
1232: --and lot_number is null

Line 1420: from mtl_onhand_quantities_detail

1416: -- END IF;
1417:
1418: select nvl(status_id, -1)
1419: into g_isa_loc_status_id
1420: from mtl_onhand_quantities_detail
1421: where inventory_item_id = p_inventory_item_id
1422: and organization_id = p_organization_id
1423: and lot_number is null
1424: and locator_id = p_locator_id

Line 1458: from mtl_onhand_quantities_detail moqd

1454: */
1455: begin
1456: select 1
1457: into l_count
1458: from mtl_onhand_quantities_detail moqd
1459: where moqd.inventory_item_id = p_inventory_item_id
1460: and moqd.organization_id = p_organization_id
1461: and moqd.locator_id = p_locator_id
1462: and INV_MATERIAL_STATUS_GRP.is_trx_allowed_wrap(

Line 1546: from mtl_onhand_quantities_detail

1542:
1543: begin
1544: select count(distinct status_id)
1545: into count_status_id
1546: from mtl_onhand_quantities_detail
1547: where organization_id = p_organization_id
1548: --and lot_number is null -- Bug 7126137
1549: and locator_id = p_locator_id;
1550: --and nvl(lpn_id, -9999) = nvl(p_lpn_id, -9999); -- Bug 7126137

Line 1555: from mtl_onhand_quantities_detail

1551:
1552: if ( count_status_id = 1) then
1553: select status_id
1554: into g_isa_loc_status_id
1555: from mtl_onhand_quantities_detail
1556: where organization_id = p_organization_id
1557: and locator_id = p_locator_id
1558: --Bug 7126137
1559: --and lot_number is null

Line 1749: from mtl_onhand_quantities_detail

1745: -- END IF;
1746:
1747: select nvl(status_id, -1)
1748: into g_isa_lot_number_status_id
1749: from mtl_onhand_quantities_detail
1750: where inventory_item_id = p_inventory_item_id
1751: and organization_id = p_organization_id
1752: and subinventory_code = p_sub_code
1753: and nvl(locator_id, -9999) = nvl(l_locator_id, -9999)

Line 2238: FROM MTL_ONHAND_QUANTITIES_DETAIL

2234: else
2235: IF p_lpn_id is null then /*LPN Status Project */
2236: SELECT nvl(status_id, -1)
2237: INTO l_default_status_id
2238: FROM MTL_ONHAND_QUANTITIES_DETAIL
2239: WHERE inventory_item_id = p_inventory_item_id
2240: AND organization_id = p_organization_id
2241: AND subinventory_code = p_sub_code
2242: AND nvl( locator_id, -9999) =nvl( p_loc_id, -9999)

Line 2249: FROM MTL_ONHAND_QUANTITIES_DETAIL

2245: AND rownum = 1;
2246: ELSE
2247: SELECT nvl(status_id, -1)
2248: INTO l_default_status_id
2249: FROM MTL_ONHAND_QUANTITIES_DETAIL
2250: WHERE inventory_item_id = p_inventory_item_id
2251: AND organization_id = p_organization_id
2252: AND nvl(lot_number, '@@@@') = nvl(p_lot_number, '@@@@')
2253: AND lpn_id = p_lpn_id /*LPN Status Project */

Line 2773: FROM mtl_onhand_quantities_detail

2769: END IF;
2770: BEGIN
2771: SELECT NVL( status_id ,0 )
2772: INTO l_onhand_status_id
2773: FROM mtl_onhand_quantities_detail
2774: WHERE inventory_item_id = l_inventory_item_id
2775: AND organization_id = l_organization_id
2776: AND subinventory_code = l_subinventory_code
2777: AND NVL(locator_id, -9999) = NVL(l_locator_id,-9999)

Line 3532: FROM mtl_onhand_quantities_detail moqd, wms_lpn_contents wlc

3528: IS
3529:
3530: CURSOR c_wlc_status IS
3531: SELECT moqd.inventory_item_id inventory_item_id,moqd.lot_number lot_number,moqd.status_id status_id
3532: FROM mtl_onhand_quantities_detail moqd, wms_lpn_contents wlc
3533: WHERE moqd.organization_id = p_org_id
3534: AND moqd.inventory_item_id = nvl(p_item_id,moqd.inventory_item_id)
3535: AND moqd.subinventory_code = p_subinv_code
3536: AND moqd.locator_id = p_locator_id

Line 3590: FROM mtl_onhand_quantities_detail

3586: Loose -> LPN (Like packing Trx)
3587: */
3588: BEGIN
3589: SELECT nvl(status_id,-9999) INTO l_source_status_id
3590: FROM mtl_onhand_quantities_detail
3591: WHERE organization_id = p_org_id
3592: AND inventory_item_id = p_item_id
3593: AND (lot_number = p_lot_number
3594: OR (lot_number is null and p_lot_number is NULL))

Line 3629: FROM mtl_onhand_quantities_detail

3625: BEGIN
3626: SELECT 'Y' INTO l_comingle
3627: FROM DUAL WHERE EXISTS
3628: (SELECT 1
3629: FROM mtl_onhand_quantities_detail
3630: WHERE organization_id = p_xfr_org_id
3631: AND inventory_item_id = p_item_id
3632: AND (lot_number = p_lot_number
3633: OR (lot_number is null and p_lot_number is null))

Line 3671: FROM mtl_onhand_quantities_detail

3667:
3668: SELECT 'Y' INTO l_comingle
3669: FROM DUAL WHERE EXISTS
3670: (SELECT 1
3671: FROM mtl_onhand_quantities_detail
3672: WHERE organization_id = p_xfr_org_id
3673: AND inventory_item_id =l_wlc_rec.inventory_item_id
3674: AND Nvl(lot_number,'@@@@') = Nvl(l_wlc_rec.lot_number,'@@@@')
3675: AND subinventory_code = p_tosubinv_code

Line 4090: FROM mtl_onhand_quantities_detail moqd,

4086: INTO l_allow_transaction
4087: FROM dual
4088: WHERE EXISTS
4089: (SELECT 1
4090: FROM mtl_onhand_quantities_detail moqd,
4091: mtl_status_transaction_control mtc
4092: WHERE moqd.organization_id = p_xfer_org_id
4093: AND moqd.inventory_item_id = l_mmtt_cur.inventory_item_id
4094: AND NVL(moqd.lot_number,'@@@') = NVL(l_mtlt_cur.lot_number,'@@@')