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.WMS_LPN_LOVS dependencies on MTL_ITEM_LOCATIONS

Line 181: ' mtl_item_locations_kfv milk, ' ||

177: ' NVL(wlpn.content_volume, 0), ' ||
178: ' milk.concatenated_segments, ' ||
179: ' wlpn.lpn_context ' ||
180: 'FROM wms_license_plate_numbers wlpn, ' ||
181: ' mtl_item_locations_kfv milk, ' ||
182: ' wms_lpn_contents wlc ' ||
183: 'WHERE wlpn.organization_id = milk.organization_id (+) ' ||
184: ' AND wlpn.locator_id = milk.inventory_location_id(+) ' ||
185: ' AND wlc.parent_lpn_id (+) = wlpn.lpn_id ';

Line 234: ' mtl_item_locations milk, ' ||

230: ' INV_PROJECT.GET_TASK_ID, ' ||
231: ' INV_PROJECT.GET_TASK_NUMBER, ' ||
232: ' wlpn.lpn_context ' ||
233: 'FROM wms_license_plate_numbers wlpn, ' ||
234: ' mtl_item_locations milk, ' ||
235: ' wms_lpn_contents wlc ' ||
236: 'WHERE wlpn.organization_id = milk.organization_id (+) ' ||
237: ' AND wlpn.locator_id = milk.inventory_location_id(+) ' ||
238: ' AND wlc.parent_lpn_id (+) = wlpn.lpn_id ';

Line 285: mtl_item_locations_kfv milk,

281: NVL(wlpn.content_volume, 0),
282: milk.concatenated_segments,
283: wlpn.lpn_context
284: FROM wms_license_plate_numbers wlpn,
285: mtl_item_locations_kfv milk,
286: wms_lpn_contents wlc
287: WHERE wlpn.organization_id = To_number(p_organization_id)
288: AND wlpn.organization_id = milk.organization_id (+)
289: AND wlpn.locator_id = milk.inventory_location_id(+)

Line 330: mtl_item_locations_kfv milk,

326: NVL(wlpn.content_volume, 0),
327: milk.concatenated_segments,
328: wlpn.lpn_context
329: FROM wms_license_plate_numbers wlpn,
330: mtl_item_locations_kfv milk,
331: wms_lpn_contents wlc
332: WHERE wlpn.organization_id = milk.organization_id (+)
333: AND wlpn.locator_id = milk.inventory_location_id(+)
334: AND wlc.parent_lpn_id (+) = wlpn.lpn_id

Line 433: mtl_item_locations_kfv milk,

429: NVL(wlpn.content_volume, 0),
430: milk.concatenated_segments,
431: wlpn.lpn_context
432: FROM wms_license_plate_numbers wlpn,
433: mtl_item_locations_kfv milk,
434: wms_lpn_contents wlc
435: WHERE wlpn.organization_id = milk.organization_id (+)
436: AND wlpn.locator_id = milk.inventory_location_id(+)
437: AND wlc.parent_lpn_id (+) = wlpn.lpn_id

Line 450: FROM mtl_item_locations mil

446: -- PJM changes: Bug 2774506/2905646 : Added project_id and task_id to show LPN's belonging to PJM locators.
447: AND ( wlpn.locator_id IS NULL OR
448: wlpn.locator_id IN
449: (SELECT DISTINCT mil.inventory_location_id
450: FROM mtl_item_locations mil
451: WHERE NVL(mil.project_id, -1) = NVL(p_project_id, -1)
452: AND NVL(mil.task_id, -1) = NVL(p_task_id, -1))
453: )
454: ORDER BY wlpn.license_plate_number;

Line 497: mtl_item_locations_kfv milk,

493: NVL(wlpn.content_volume, 0),
494: milk.concatenated_segments,
495: wlpn.lpn_context
496: FROM wms_license_plate_numbers wlpn,
497: mtl_item_locations_kfv milk,
498: wms_lpn_contents wlc
499: WHERE wlpn.organization_id = milk.organization_id (+)
500: AND wlpn.locator_id = milk.inventory_location_id(+)
501: AND wlc.parent_lpn_id (+) = wlpn.lpn_id

Line 510: FROM mtl_item_locations mil

506: AND wlc.inventory_item_id = p_inventory_item_id
507: AND ( wlpn.locator_id IS NULL OR
508: wlpn.locator_id IN
509: (SELECT DISTINCT mil.inventory_location_id
510: FROM mtl_item_locations mil
511: WHERE NVL(mil.project_id, -1) = NVL(p_project_id, -1)
512: AND NVL(mil.task_id, -1) = NVL(p_task_id, -1))
513: )
514: ORDER BY wlpn.license_plate_number;

Line 558: mtl_item_locations_kfv milk,

554: NVL(wlpn.content_volume, 0),
555: milk.concatenated_segments,
556: wlpn.lpn_context
557: FROM wms_license_plate_numbers wlpn,
558: mtl_item_locations_kfv milk,
559: wms_lpn_contents wlc
560: WHERE wlpn.organization_id = milk.organization_id (+)
561: AND wlpn.locator_id = milk.inventory_location_id(+)
562: AND wlc.parent_lpn_id (+) = wlpn.lpn_id

Line 572: FROM mtl_item_locations mil

568: AND wlpn.subinventory_code = p_subinventory_code
569: AND ( wlpn.locator_id IS NULL OR
570: wlpn.locator_id IN
571: (SELECT DISTINCT mil.inventory_location_id
572: FROM mtl_item_locations mil
573: WHERE NVL(mil.project_id, -1) = NVL(p_project_id, -1)
574: AND NVL(mil.task_id, -1) = NVL(p_task_id, -1))
575: )
576: ORDER BY wlpn.license_plate_number;

Line 724: , mtl_item_locations_kfv milk

720: , NVL(wlpn.content_volume, 0)
721: , milk.concatenated_segments
722: , wlpn.lpn_context
723: FROM wms_license_plate_numbers wlpn
724: , mtl_item_locations_kfv milk
725: WHERE wlpn.organization_id = milk.organization_id (+)
726: AND wlpn.locator_id = milk.inventory_location_id (+)
727: AND wlpn.outermost_lpn_id = wlpn.lpn_id
728: AND wlpn.lpn_context = 11

Line 774: ' mtl_item_locations_kfv milk, ' ||

770: ' NVL(wlpn.content_volume, 0), ' ||
771: ' milk.concatenated_segments, ' ||
772: ' wlpn.lpn_context ' ||
773: 'FROM wms_license_plate_numbers wlpn, ' ||
774: ' mtl_item_locations_kfv milk, ' ||
775: ' wms_lpn_contents wlc, ' ||
776: ' mtl_serial_numbers msn, ' ||
777: ' mtl_serial_numbers_temp msnt ' ||
778: 'WHERE wlpn.organization_id = milk.organization_id (+) ' ||

Line 832: mtl_item_locations_kfv milk,

828: NVL(wlpn.content_volume, 0),
829: milk.concatenated_segments,
830: wlpn.lpn_context
831: FROM wms_license_plate_numbers wlpn,
832: mtl_item_locations_kfv milk,
833: wms_lpn_contents wlc,
834: mtl_serial_numbers msn,
835: mtl_serial_numbers_temp msnt
836: WHERE wlpn.organization_id = milk.organization_id (+)

Line 869: mtl_item_locations_kfv milk,

865: NVL(wlpn.content_volume, 0),
866: milk.concatenated_segments,
867: wlpn.lpn_context
868: FROM wms_license_plate_numbers wlpn,
869: mtl_item_locations_kfv milk,
870: wms_lpn_contents wlc,
871: mtl_serial_numbers msn,
872: mtl_serial_numbers_temp msnt,
873: mtl_transaction_lots_temp mtlt,

Line 935: mtl_item_locations_kfv milk,

931: NVL(wlpn.content_volume, 0),
932: milk.concatenated_segments,
933: wlpn.lpn_context
934: FROM wms_license_plate_numbers wlpn,
935: mtl_item_locations_kfv milk,
936: wms_lpn_contents wlc,
937: mtl_serial_numbers msn,
938: mtl_serial_numbers_temp msnt
939: WHERE wlpn.organization_id = milk.organization_id (+)

Line 969: mtl_item_locations_kfv milk,

965: NVL(wlpn.content_volume, 0),
966: milk.concatenated_segments,
967: wlpn.lpn_context
968: FROM wms_license_plate_numbers wlpn,
969: mtl_item_locations_kfv milk,
970: wms_lpn_contents wlc,
971: mtl_serial_numbers msn,
972: mtl_serial_numbers_temp msnt,
973: mtl_transaction_lots_temp mtlt,

Line 1032: mtl_item_locations_kfv milk,

1028: NVL(wlpn.content_volume, 0),
1029: milk.concatenated_segments,
1030: wlpn.lpn_context
1031: FROM wms_license_plate_numbers wlpn,
1032: mtl_item_locations_kfv milk,
1033: wms_lpn_contents wlc,
1034: mtl_serial_numbers msn,
1035: mtl_serial_numbers_temp msnt
1036: WHERE wlpn.organization_id = milk.organization_id (+)

Line 1067: mtl_item_locations_kfv milk,

1063: NVL(wlpn.content_volume, 0),
1064: milk.concatenated_segments,
1065: wlpn.lpn_context
1066: FROM wms_license_plate_numbers wlpn,
1067: mtl_item_locations_kfv milk,
1068: wms_lpn_contents wlc,
1069: mtl_serial_numbers msn,
1070: mtl_serial_numbers_temp msnt,
1071: mtl_transaction_lots_temp mtlt,

Line 1139: FROM mtl_item_locations mil

1135: -- PJM Changes
1136: AND ( locator_id IS NULL OR
1137: locator_id IN
1138: (SELECT DISTINCT mil.inventory_location_id
1139: FROM mtl_item_locations mil
1140: WHERE NVL(mil.project_id, -1) = NVL(p_project_id, -1)
1141: AND NVL(mil.task_id, -1) = NVL(p_task_id, -1))
1142: )
1143: AND license_plate_number LIKE (p_lpn)

Line 1183: FROM mtl_item_locations mil

1179: -- PJM Changes
1180: AND ( mpit.locator_id IS NULL OR
1181: mpit.locator_id IN
1182: (SELECT DISTINCT mil.inventory_location_id
1183: FROM mtl_item_locations mil
1184: WHERE NVL(mil.project_id, -1) = NVL(p_project_id, -1)
1185: AND NVL(mil.task_id, -1) = NVL(p_task_id, -1))
1186: )
1187: AND NVL(mpit.void_flag, 2) = 2

Line 1245: FROM mtl_item_locations mil

1241: -- PJM Changes
1242: AND ( locator_id IS NULL OR
1243: locator_id IN
1244: (SELECT DISTINCT mil.inventory_location_id
1245: FROM mtl_item_locations mil
1246: WHERE NVL(mil.project_id, -1) = NVL(p_project_id, -1)
1247: AND NVL(mil.task_id, -1) = NVL(p_task_id, -1))
1248: )
1249: AND license_plate_number LIKE (p_lpn)

Line 1292: FROM mtl_item_locations mil

1288: -- PJM Changes
1289: AND ( mpit.locator_id IS NULL OR
1290: mpit.locator_id IN
1291: (SELECT DISTINCT mil.inventory_location_id
1292: FROM mtl_item_locations mil
1293: WHERE NVL(mil.project_id, -1) = NVL(p_project_id, -1)
1294: AND NVL(mil.task_id, -1) = NVL(p_task_id, -1))
1295: )
1296: AND mpit.adjustment_id IN

Line 1371: --,mtl_item_locations mil

1367: NVL(wlpn.gross_weight, 0),
1368: wlpn.content_volume_uom_code,
1369: NVL(wlpn.content_volume, 0)
1370: FROM wms_license_plate_numbers wlpn
1371: --,mtl_item_locations mil
1372: WHERE wlpn.organization_id = p_org_id
1373: AND wlpn.license_plate_number LIKE (p_lpn)
1374: AND (wlpn.lpn_context = 5
1375: OR (wlpn.lpn_context = 1

Line 1639: mtl_item_locations mil

1635: content_volume_uom_code,
1636: NVL(wlpn.content_volume, 0),
1637: wlpn.lpn_context --Added for bug#4202068.
1638: FROM wms_license_plate_numbers wlpn,
1639: mtl_item_locations mil
1640: WHERE wlpn.organization_id = p_org_id
1641: AND NOT wlpn.lpn_id = NVL(TO_NUMBER(p_not_lpn_id), -999)
1642: AND NVL(wlpn.parent_lpn_id, 0) = NVL(TO_NUMBER(p_parent_lpn_id),
1643: NVL(wlpn.parent_lpn_id, 0))

Line 1704: mtl_item_locations mil

1700: content_volume_uom_code,
1701: NVL(wlpn.content_volume, 0),
1702: wlpn.lpn_context --Added for bug#4202068.
1703: FROM wms_license_plate_numbers wlpn,
1704: mtl_item_locations mil
1705: WHERE wlpn.organization_id = p_org_id
1706: AND NOT wlpn.lpn_id = NVL(TO_NUMBER(p_not_lpn_id), -999)
1707: AND NVL(wlpn.parent_lpn_id, 0) = NVL(TO_NUMBER(p_parent_lpn_id),
1708: NVL(wlpn.parent_lpn_id, 0))

Line 2098: mtl_item_locations mil

2094: wlpn.content_volume_uom_code,
2095: NVL(wlpn.content_volume, 0),
2096: wlpn.lpn_context --Added for bug#4202068.
2097: FROM wms_license_plate_numbers wlpn,
2098: mtl_item_locations mil
2099: WHERE wlpn.organization_id = p_org_id
2100: AND NOT wlpn.lpn_id = NVL(TO_NUMBER(p_not_lpn_id), -999)
2101: AND NVL(wlpn.parent_lpn_id, 0) = NVL(TO_NUMBER(p_parent_lpn_id),
2102: NVL(wlpn.parent_lpn_id, 0))

Line 2155: mtl_item_locations mil

2151: wlpn.content_volume_uom_code,
2152: NVL(wlpn.content_volume, 0),
2153: wlpn.lpn_context --Added for bug#4202068.
2154: FROM wms_license_plate_numbers wlpn,
2155: mtl_item_locations mil
2156: WHERE wlpn.organization_id = p_org_id
2157: AND NOT wlpn.lpn_id = NVL(TO_NUMBER(p_not_lpn_id), -999)
2158: AND NVL(wlpn.parent_lpn_id, 0) = NVL(TO_NUMBER(p_parent_lpn_id),
2159: NVL(wlpn.parent_lpn_id, 0))

Line 3081: * Use the table mtl_item_locations instead of mtl_item_locations_kfv.

3077: END GET_VENDOR_LPN;
3078:
3079: /* PJM Integration: Added to get the concatenated segments of physical locator,
3080: * project id, project number, task id and task number.
3081: * Use the table mtl_item_locations instead of mtl_item_locations_kfv.
3082: */
3083: PROCEDURE GET_ITEM_LPN_LOV
3084: (x_lpn_lov OUT NOCOPY t_genref,
3085: p_organization_id IN NUMBER,

Line 3119: mtl_item_locations mil

3115: INV_PROJECT.GET_TASK_ID,
3116: INV_PROJECT.GET_TASK_NUMBER
3117: FROM wms_license_plate_numbers wlpn,
3118: wms_lpn_contents wlc,
3119: mtl_item_locations mil
3120: WHERE (mil.inventory_location_id = wlpn.locator_id
3121: AND wlpn.locator_id IS NOT NULL)
3122: AND ( (wlc.revision = p_revision
3123: AND p_revision IS NOT NULL)

Line 3142: * Use the table mtl_item_locations instead of mtl_item_locations_kfv.

3138: -- Procedure for the result lot of Lot split/merge/translate.
3139: -- For the result lot, do not need to check for inventory item id.
3140: /* PJM Integration: Added to get the concatenated segments of physical locator,
3141: * project id, project number, task id and task number.
3142: * Use the table mtl_item_locations instead of mtl_item_locations_kfv.
3143: */
3144: PROCEDURE GET_LOT_LPN_LOV
3145: (x_lpn_lov OUT NOCOPY t_genref,
3146: p_organization_id IN NUMBER,

Line 3174: mtl_item_locations mil

3170: INV_PROJECT.GET_PROJECT_NUMBER,
3171: INV_PROJECT.GET_TASK_ID,
3172: INV_PROJECT.GET_TASK_NUMBER
3173: FROM wms_license_plate_numbers wlpn,
3174: mtl_item_locations mil
3175: WHERE mil.inventory_location_id(+) = wlpn.locator_id --OUTER JOIN is added for bug 3876495
3176: AND wlpn.license_plate_number LIKE (p_lpn)
3177: AND wlpn.organization_id = p_organization_id
3178: AND wlpn.lpn_context IN (1,5) --LPN_CONTEXT 5 is Added for bug3876495.

Line 3245: from mtl_item_locations mil

3241: WHERE wlpn.license_plate_number LIKE (p_lpn)
3242: AND wlpn.organization_id = p_org_id
3243: and exists
3244: ( select inventory_location_id
3245: from mtl_item_locations mil
3246: where organization_id = p_org_id
3247: and nvl(wlpn.subinventory_code,'@@@') = nvl(mil.subinventory_code,'@@@')
3248: and mil.project_id = p_project_id
3249: and wlpn.locator_id = mil.inventory_location_id

Line 3351: from mtl_item_locations mil

3347: and organization_id = p_org_id
3348: AND lpn_context = 1
3349: and exists
3350: ( select inventory_location_id
3351: from mtl_item_locations mil
3352: where organization_id = p_org_id
3353: and nvl(wlpn.subinventory_code,'@@@') = nvl(mil.subinventory_code,'@@@')
3354: and mil.project_id is null
3355: and wlpn.locator_id = mil.inventory_location_id

Line 3461: from mtl_item_locations

3457: AND (NVL(locator_id, -99999) = NVL(p_locator_id, -99999) OR
3458: (l_container_discrepancy_option = 1
3459: AND locator_id in (
3460: select inventory_location_id
3461: from mtl_item_locations
3462: where nvl(segment19,-9999) = nvl(p_project_id,-9999)
3463: and nvl(segment20,-9999) = nvl(p_task_id,-9999)
3464: )
3465: )

Line 3509: from mtl_item_locations

3505: AND (NVL(mcce.locator_id, -99999) = NVL(p_locator_id, -99999) OR
3506: (l_container_discrepancy_option = 1
3507: AND mcce.locator_id in (
3508: select inventory_location_id
3509: from mtl_item_locations
3510: where nvl(segment19,-9999) = nvl(p_project_id,-9999)
3511: and nvl(segment20,-9999) = nvl(p_task_id,-9999)
3512: )
3513: )

Line 3575: from mtl_item_locations

3571: AND (NVL(locator_id, -99999) = NVL(p_locator_id, -99999) OR
3572: (l_container_discrepancy_option = 1
3573: AND locator_id in (
3574: select inventory_location_id
3575: from mtl_item_locations
3576: where nvl(segment19,-9999) = nvl(p_project_id,-9999)
3577: and nvl(segment20,-9999) = nvl(p_task_id,-9999)
3578: )
3579: )

Line 3624: from mtl_item_locations

3620: AND (NVL(mcce.locator_id, -99999) = NVL(p_locator_id, -99999) OR
3621: (l_container_discrepancy_option = 1
3622: AND mcce.locator_id in (
3623: select inventory_location_id
3624: from mtl_item_locations
3625: where nvl(segment19,-9999) = nvl(p_project_id,-9999)
3626: and nvl(segment20,-9999) = nvl(p_task_id,-9999)
3627: )
3628: )

Line 3638: * Use the table mtl_item_locations instead of mtl_item_locations_kfv.

3634:
3635: END GET_CYC_LPN_LOV;
3636:
3637: /* PJM-WMS Integration:Return only the LPNs residing in physical locators.
3638: * Use the table mtl_item_locations instead of mtl_item_locations_kfv.
3639: * Use the function INV_PROJECT.get_locsegs() to retrieve the
3640: * concatenated segments.
3641: */
3642: PROCEDURE GET_CGUPDATE_LPN

Line 3657: FROM mtl_item_locations mil,-- -PJM-WMS Integration

3653: wlpn.subinventory_code,
3654: wlpn.locator_id,
3655: -- PJM-WMS Integration
3656: INV_PROJECT.GET_LOCSEGS(mil.inventory_location_id,p_org_id)
3657: FROM mtl_item_locations mil,-- -PJM-WMS Integration
3658: wms_license_plate_numbers wlpn
3659: WHERE mil.inventory_location_id = wlpn.locator_id
3660: AND mil.organization_id = wlpn.organization_id
3661: AND mil.segment19 is null

Line 3837: mtl_item_locations_kfv milk

3833: milk.concatenated_segments
3834: INTO l_flag2,
3835: x_concat_segments
3836: FROM wms_license_plate_numbers w,
3837: mtl_item_locations_kfv milk
3838: WHERE w.license_plate_number = p_lpn
3839: AND w.locator_id = milk.inventory_location_id
3840: AND w.organization_id = milk.organization_id;
3841:

Line 4302: mtl_item_locations_kfv milk

4298: NVL(outer.gross_weight, 0),
4299: outer.content_volume_uom_code,
4300: NVL(outer.content_volume, 0)
4301: from wms_license_plate_numbers outer, wms_license_plate_numbers inner,
4302: mtl_item_locations_kfv milk
4303: where inner.outermost_lpn_id <> inner.lpn_id
4304: AND inner.outermost_lpn_id = outer.lpn_id
4305: AND outer.locator_id = milk.inventory_location_id(+)
4306: and outer.lpn_context in (1, 11)

Line 4546: mtl_item_locations_kfv milk,

4542: NVL (wlpn.content_volume, 0),
4543: milk.concatenated_segments,
4544: wlpn.lpn_context
4545: FROM wms_license_plate_numbers wlpn,
4546: mtl_item_locations_kfv milk,
4547: wms_putaway_group_tasks_gtmp wpgt
4548: WHERE wlpn.organization_id = TO_NUMBER (p_organization_id)
4549: AND wlpn.organization_id = milk.organization_id(+)
4550: AND wlpn.locator_id = milk.inventory_location_id(+)