APPS.INV_LABEL_PVT4 dependencies on WMS_LPN_CONTENTS

Line 908: FROM wms_lpn_contents wlc

904: , milkfv.inventory_location_id locator_id
905: , INV_PROJECT.GET_LOCSEGS(milkfv.inventory_location_id, milkfv.organization_id) locator
906: , sum(nvl(l_secondary_transaction_qty,wlc.secondary_quantity)) secondary_quantity -- invconv fabdi
907: , wlc.secondary_uom_code secondary_uom -- invconv fabdi
908: FROM wms_lpn_contents wlc
909: , wms_license_plate_numbers plpn
910: , cst_cost_groups ccg
911: , mtl_item_locations milkfv
912: ,(SELECT distinct LPN_ID

Line 985: AND NOT EXISTS (SELECT 1 from wms_lpn_contents wlc where wlc.parent_lpn_id=p_lpn_id)

981: AND milkfv.subinventory_code(+) = nvl(l_subinventory_code, plpn.subinventory_code)
982: AND milkfv.inventory_location_id(+) = nvl(l_locator_id, plpn.locator_id)
983: AND ccg.cost_group_id (+) = nvl(p_cost_group_id, mmtt.cost_group_id)
984: AND mmtt.transaction_temp_id = p_transaction_id
985: AND NOT EXISTS (SELECT 1 from wms_lpn_contents wlc where wlc.parent_lpn_id=p_lpn_id)
986: AND ( mmtt.primary_quantity > 0 --9070667
987: OR
988: mmtt.transaction_action_id = 1 -- Bug#10013745 Added OR Condition, Since for issue Qty will be -ve
989: )

Line 2683: wms_lpn_contents

2679: INVENTORY_ITEM_ID,ORGANIZATION_ID
2680: INTO
2681: l_cur_item_id,p_organization_id
2682: FROM
2683: wms_lpn_contents
2684: WHERE
2685: parent_lpn_id=l_lpn_id;
2686:
2687: EXCEPTION

Line 2917: from wms_lpn_contents

2913: END ;
2914: END IF;
2915: ELSE -- for manual
2916: select count(1) into l_count
2917: from wms_lpn_contents
2918: where parent_lpn_id = l_lpn_id;
2919: if l_count = 0 then
2920: l_query_moqd := -1;--wlc is not there so not checkin for status for manual driven
2921: END IF;