[Home] [Help]
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 ';
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(+)
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
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
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
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
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
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 (+) ' ||
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 (+)
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,
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 (+)
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,
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 (+)
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,
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,
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,
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
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:
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)
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(+)
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
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