DBA Data[Home] [Help]

APPS.MTL_INV_UTIL_GRP dependencies on WMS_LPN_CONTENTS

Line 1274: FROM WMS_LPN_CONTENTS

1270: IF (p_serial_number IS NULL) THEN
1271: BEGIN
1272: SELECT nvl(sum(quantity),0) --BUG3026540
1273: INTO x_lpn_systemqty
1274: FROM WMS_LPN_CONTENTS
1275: WHERE parent_lpn_id = p_lpn_id
1276: AND organization_id = p_organization_id
1277: AND inventory_item_id = p_inventory_item_id
1278: AND NVL(lot_number, '@') = NVL(p_lot_number, '@')

Line 1455: FROM wms_lpn_contents

1451: SELECT NVL (SUM (primary_quantity), 0)
1452: , NVL (SUM (secondary_quantity), 0)
1453: INTO x_lpn_systemqty
1454: , x_lpn_sec_systemqty
1455: FROM wms_lpn_contents
1456: WHERE parent_lpn_id = p_lpn_id
1457: AND organization_id = p_organization_id
1458: AND inventory_item_id = p_inventory_item_id
1459: AND NVL (lot_number, '@') = NVL (p_lot_number, '@')