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 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 309: FROM mtl_onhand_quantities_detail moqddst

305: )
306: MINUS
307: (
308: SELECT DISTINCT moqddst.status_id
309: FROM mtl_onhand_quantities_detail moqddst
310: WHERE moqddst.organization_id = l_xfer_org_id
311: AND moqddst.lpn_id IN
312: (
313: SELECT lpn_id

Line 354: FROM mtl_onhand_quantities_detail moqd,

350: INTO l_allow_transaction
351: FROM dual
352: WHERE EXISTS
353: (SELECT 1
354: FROM mtl_onhand_quantities_detail moqd,
355: mtl_status_transaction_control mtc
356: WHERE moqd.organization_id = p_organization_id
357: AND moqd.inventory_item_id = p_inventory_item_id
358: AND moqd.subinventory_code = p_sub_code

Line 387: FROM mtl_onhand_quantities_detail moqd,

383: INTO l_allow_transaction
384: FROM dual
385: WHERE EXISTS
386: (SELECT 1
387: FROM mtl_onhand_quantities_detail moqd,
388: mtl_status_transaction_control mtc
389: WHERE moqd.organization_id = l_xfer_org_id
390: AND moqd.inventory_item_id = p_inventory_item_id
391: AND NVL(moqd.lot_number,'@@@') = NVL(p_lot_number,'@@@')

Line 415: FROM mtl_onhand_quantities_detail moqd,

411: INTO l_allow_transaction
412: FROM dual
413: WHERE EXISTS
414: (SELECT 1
415: FROM mtl_onhand_quantities_detail moqd,
416: mtl_status_transaction_control mtc
417: WHERE moqd.organization_id = l_xfer_org_id
418: AND moqd.inventory_item_id = p_inventory_item_id
419: AND moqd.subinventory_code = l_xfer_sub_code

Line 475: FROM mtl_onhand_quantities_detail moqd,

471: INTO l_allow_transaction
472: FROM dual
473: WHERE EXISTS
474: (SELECT 1
475: FROM mtl_onhand_quantities_detail moqd,
476: mtl_status_transaction_control mtc
477: WHERE moqd.organization_id = p_organization_id
478: AND moqd.subinventory_code = p_sub_code
479: AND moqd.locator_id = p_locator_id

Line 539: FROM mtl_onhand_quantities_detail moqd,

535: INTO l_allow_transaction
536: FROM dual
537: WHERE EXISTS
538: (SELECT 1
539: FROM mtl_onhand_quantities_detail moqd,
540: mtl_status_transaction_control mtc
541: WHERE moqd.organization_id = l_xfer_org_id
542: AND moqd.lpn_id = p_xfer_lpn_id
543: AND moqd.status_id = mtc.status_id

Line 1028: from mtl_onhand_quantities_detail

1024: end if;
1025:
1026: select nvl(status_id, -1)
1027: into g_isa_sub_status_id
1028: from mtl_onhand_quantities_detail
1029: where inventory_item_id = p_inventory_item_id
1030: and organization_id = p_organization_id
1031: and subinventory_code = p_sub_code
1032: and lot_number is null

Line 1080: from mtl_onhand_quantities_detail moqd

1076: */
1077: begin
1078: select 1
1079: into l_count
1080: from mtl_onhand_quantities_detail moqd
1081: where moqd.inventory_item_id = p_inventory_item_id
1082: and moqd.organization_id = p_organization_id
1083: and moqd.subinventory_code = p_sub_code
1084: and INV_MATERIAL_STATUS_GRP.is_trx_allowed_wrap(

Line 1150: from mtl_onhand_quantities_detail

1146:
1147: begin
1148: select count(distinct status_id)
1149: into count_status_id
1150: from mtl_onhand_quantities_detail
1151: where organization_id = p_organization_id
1152: and subinventory_code = p_sub_code
1153: and lot_number is null
1154: and locator_id is null

Line 1160: from mtl_onhand_quantities_detail

1156:
1157: if ( count_status_id = 1) then
1158: select status_id
1159: into g_isa_sub_status_id
1160: from mtl_onhand_quantities_detail
1161: where organization_id = p_organization_id
1162: and subinventory_code = p_sub_code
1163: and lot_number is null
1164: and locator_id is null

Line 1244: from mtl_onhand_quantities_detail

1240: end if;
1241:
1242: select nvl(status_id, -1)
1243: into g_isa_loc_status_id
1244: from mtl_onhand_quantities_detail
1245: where inventory_item_id = p_inventory_item_id
1246: and organization_id = p_organization_id
1247: and lot_number is null
1248: and locator_id = p_locator_id

Line 1282: from mtl_onhand_quantities_detail moqd

1278: */
1279: begin
1280: select 1
1281: into l_count
1282: from mtl_onhand_quantities_detail moqd
1283: where moqd.inventory_item_id = p_inventory_item_id
1284: and moqd.organization_id = p_organization_id
1285: and moqd.locator_id = p_locator_id
1286: and INV_MATERIAL_STATUS_GRP.is_trx_allowed_wrap(

Line 1370: from mtl_onhand_quantities_detail

1366:
1367: begin
1368: select count(distinct status_id)
1369: into count_status_id
1370: from mtl_onhand_quantities_detail
1371: where organization_id = p_organization_id
1372: and lot_number is null
1373: and locator_id = p_locator_id
1374: and nvl(lpn_id, -9999) = nvl(p_lpn_id, -9999);

Line 1379: from mtl_onhand_quantities_detail

1375:
1376: if ( count_status_id = 1) then
1377: select status_id
1378: into g_isa_loc_status_id
1379: from mtl_onhand_quantities_detail
1380: where organization_id = p_organization_id
1381: and locator_id = p_locator_id
1382: and lot_number is null
1383: and nvl(lpn_id, -9999) = nvl(p_lpn_id, -9999)

Line 1479: from mtl_onhand_quantities_detail

1475: END IF;
1476:
1477: select nvl(status_id, -1)
1478: into g_isa_lot_number_status_id
1479: from mtl_onhand_quantities_detail
1480: where inventory_item_id = p_inventory_item_id
1481: and organization_id = p_organization_id
1482: and subinventory_code = p_sub_code
1483: and nvl(locator_id, -9999) = nvl(l_locator_id, -9999)

Line 1842: FROM MTL_ONHAND_QUANTITIES_DETAIL

1838: else
1839: IF p_lpn_id is null then /*LPN Status Project */
1840: SELECT nvl(status_id, -1)
1841: INTO l_default_status_id
1842: FROM MTL_ONHAND_QUANTITIES_DETAIL
1843: WHERE inventory_item_id = p_inventory_item_id
1844: AND organization_id = p_organization_id
1845: AND subinventory_code = p_sub_code
1846: AND nvl( locator_id, -9999) =nvl( p_loc_id, -9999)

Line 1853: FROM MTL_ONHAND_QUANTITIES_DETAIL

1849: AND rownum = 1;
1850: ELSE
1851: SELECT nvl(status_id, -1)
1852: INTO l_default_status_id
1853: FROM MTL_ONHAND_QUANTITIES_DETAIL
1854: WHERE inventory_item_id = p_inventory_item_id
1855: AND organization_id = p_organization_id
1856: AND nvl(lot_number, '@@@@') = nvl(p_lot_number, '@@@@')
1857: AND lpn_id = p_lpn_id /*LPN Status Project */

Line 2267: FROM mtl_onhand_quantities_detail

2263: END IF;
2264: BEGIN
2265: SELECT NVL( status_id ,-1 )
2266: INTO l_onhand_status_id
2267: FROM mtl_onhand_quantities_detail
2268: WHERE inventory_item_id = l_inventory_item_id
2269: AND organization_id = l_organization_id
2270: AND subinventory_code = l_subinventory_code
2271: AND NVL(locator_id, -9999) = NVL(l_locator_id,-9999)

Line 3001: FROM mtl_onhand_quantities_detail moqd, wms_lpn_contents wlc

2997: IS
2998:
2999: CURSOR c_wlc_status IS
3000: SELECT moqd.inventory_item_id inventory_item_id,moqd.lot_number lot_number,moqd.status_id status_id
3001: FROM mtl_onhand_quantities_detail moqd, wms_lpn_contents wlc
3002: WHERE moqd.organization_id = p_org_id
3003: AND moqd.inventory_item_id = nvl(p_item_id,moqd.inventory_item_id)
3004: AND moqd.subinventory_code = p_subinv_code
3005: AND moqd.locator_id = p_locator_id

Line 3059: FROM mtl_onhand_quantities_detail

3055: Loose -> LPN (Like packing Trx)
3056: */
3057: BEGIN
3058: SELECT nvl(status_id,-9999) INTO l_source_status_id
3059: FROM mtl_onhand_quantities_detail
3060: WHERE organization_id = p_org_id
3061: AND inventory_item_id = p_item_id
3062: AND (lot_number = p_lot_number
3063: OR (lot_number is null and p_lot_number is NULL))

Line 3098: FROM mtl_onhand_quantities_detail

3094: BEGIN
3095: SELECT 'Y' INTO l_comingle
3096: FROM DUAL WHERE EXISTS
3097: (SELECT 1
3098: FROM mtl_onhand_quantities_detail
3099: WHERE organization_id = p_xfr_org_id
3100: AND inventory_item_id = p_item_id
3101: AND (lot_number = p_lot_number
3102: OR (lot_number is null and p_lot_number is null))

Line 3140: FROM mtl_onhand_quantities_detail

3136:
3137: SELECT 'Y' INTO l_comingle
3138: FROM DUAL WHERE EXISTS
3139: (SELECT 1
3140: FROM mtl_onhand_quantities_detail
3141: WHERE organization_id = p_xfr_org_id
3142: AND inventory_item_id =l_wlc_rec.inventory_item_id
3143: AND Nvl(lot_number,'@@@@') = Nvl(l_wlc_rec.lot_number,'@@@@')
3144: AND subinventory_code = p_tosubinv_code

Line 3554: FROM mtl_onhand_quantities_detail moqd,

3550: INTO l_allow_transaction
3551: FROM dual
3552: WHERE EXISTS
3553: (SELECT 1
3554: FROM mtl_onhand_quantities_detail moqd,
3555: mtl_status_transaction_control mtc
3556: WHERE moqd.organization_id = p_xfer_org_id
3557: AND moqd.inventory_item_id = l_mmtt_cur.inventory_item_id
3558: AND NVL(moqd.lot_number,'@@@') = NVL(l_mtlt_cur.lot_number,'@@@')