DBA Data[Home] [Help]

APPS.INV_LABEL_PVT5 dependencies on WMS_LPN_CONTENTS

Line 1060: FROM wms_lpn_contents wlc

1056: , milkfv.inventory_location_id locator_id
1057: , INV_PROJECT.GET_LOCSEGS(milkfv.inventory_location_id,milkfv.organization_id) locator
1058: , sum(nvl(l_secondary_quantity,wlc.secondary_quantity)) secondary_quantity -- invconv fabdi
1059: , wlc.secondary_uom_code secondary_uom -- invconv fabdi
1060: FROM wms_lpn_contents wlc
1061: , wms_license_plate_numbers plpn
1062: , cst_cost_groups ccg
1063: , mtl_item_locations milkfv
1064: WHERE plpn.lpn_id in (select /*+ cardinality(1) */ lpn_id from wms_license_plate_numbers

Line 1179: FROM wms_lpn_contents wlc

1175: , milkfv.inventory_location_id locator_id
1176: , INV_PROJECT.GET_LOCSEGS(milkfv.inventory_location_id,milkfv.organization_id) locator
1177: , sum(nvl(l_secondary_quantity,wlc.secondary_quantity)) secondary_quantity -- invconv fabdi
1178: , wlc.secondary_uom_code secondary_uom -- invconv fabdi
1179: FROM wms_lpn_contents wlc
1180: , wms_license_plate_numbers plpn
1181: , cst_cost_groups ccg
1182: , mtl_item_locations milkfv
1183: WHERE plpn.lpn_id in (