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_KFV

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 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 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 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 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 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 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 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 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(+)