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 2095: mtl_item_locations mil

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

Line 2152: mtl_item_locations mil

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

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

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

Line 3120: mtl_item_locations mil

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

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

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

Line 3175: mtl_item_locations mil

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

Line 3246: from mtl_item_locations mil

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

Line 3352: from mtl_item_locations mil

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

Line 3462: from mtl_item_locations

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

Line 3510: from mtl_item_locations

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

Line 3576: from mtl_item_locations

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

Line 3625: from mtl_item_locations

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

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

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

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

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

Line 3838: mtl_item_locations_kfv milk

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

Line 4304: mtl_item_locations_kfv milk

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

Line 4649: mtl_item_locations_kfv milk,

4645: NVL (wlpn.content_volume, 0),
4646: milk.concatenated_segments,
4647: wlpn.lpn_context
4648: FROM wms_license_plate_numbers wlpn,
4649: mtl_item_locations_kfv milk,
4650: wms_putaway_group_tasks_gtmp wpgt
4651: WHERE wlpn.organization_id = TO_NUMBER (p_organization_id)
4652: AND wlpn.organization_id = milk.organization_id(+)
4653: AND wlpn.locator_id = milk.inventory_location_id(+)

Line 4702: , mtl_item_locations_kfv milk

4698: , NVL(wlpn.content_volume, 0)
4699: , milk.concatenated_segments
4700: , wlpn.lpn_context
4701: FROM wms_license_plate_numbers wlpn
4702: , mtl_item_locations_kfv milk
4703: WHERE wlpn.organization_id = milk.organization_id (+)
4704: AND wlpn.locator_id = milk.inventory_location_id (+)
4705: AND wlpn.outermost_lpn_id = wlpn.lpn_id
4706: AND wlpn.lpn_context = 1

Line 4739: , mtl_item_locations_kfv milk

4735: , NVL(wlpn.content_volume, 0)
4736: , milk.concatenated_segments
4737: , wlpn.lpn_context
4738: FROM wms_license_plate_numbers wlpn
4739: , mtl_item_locations_kfv milk
4740: WHERE wlpn.organization_id = milk.organization_id (+)
4741: AND wlpn.locator_id = milk.inventory_location_id (+)
4742: AND wlpn.outermost_lpn_id = wlpn.lpn_id
4743: AND wlpn.lpn_context = 5