APPS.INV_LABEL_PVT5 dependencies on INV_PROJECT

Line 1057: , INV_PROJECT.GET_LOCSEGS(milkfv.inventory_location_id,milkfv.organization_id) locator

1053: , nvl(p_cost_group_id, wlc.cost_group_id) cost_group_id
1054: , ccg.cost_group cost_group
1055: , milkfv.subinventory_code subinventory_code
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

Line 1116: , INV_PROJECT.GET_LOCSEGS(milkfv.inventory_location_id,milkfv.organization_id)

1112: , nvl(p_cost_group_id, wlc.cost_group_id)
1113: , ccg.cost_group
1114: , milkfv.subinventory_code
1115: , milkfv.inventory_location_id
1116: , INV_PROJECT.GET_LOCSEGS(milkfv.inventory_location_id,milkfv.organization_id)
1117: , wlc.secondary_uom_code;
1118:
1119: --Bug 4891916 -Added the cursor to fetch from mcce
1120: CURSOR mcce_lpn_cur IS

Line 1176: , INV_PROJECT.GET_LOCSEGS(milkfv.inventory_location_id,milkfv.organization_id) locator

1172: , wlc.cost_group_id cost_group_id
1173: , ccg.cost_group cost_group
1174: , milkfv.subinventory_code subinventory_code
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

Line 1226: , INV_PROJECT.GET_LOCSEGS(milkfv.inventory_location_id,milkfv.organization_id)

1222: , wlc.cost_group_id
1223: , ccg.cost_group
1224: , milkfv.subinventory_code
1225: , milkfv.inventory_location_id
1226: , INV_PROJECT.GET_LOCSEGS(milkfv.inventory_location_id,milkfv.organization_id)
1227: , wlc.secondary_uom_code
1228:
1229: UNION ALL
1230:

Line 1245: , INV_PROJECT.GET_LOCSEGS(milkfv.inventory_location_id,milkfv.organization_id) locator

1241: , mmtt.cost_group_id cost_group_id
1242: , ccg.cost_group cost_group
1243: , milkfv.subinventory_code subinventory_code
1244: , milkfv.inventory_location_id locator_id
1245: , INV_PROJECT.GET_LOCSEGS(milkfv.inventory_location_id,milkfv.organization_id) locator
1246: , l_secondary_quantity secondary_quantity -- invconv fabdi
1247: , l_secondary_uom secondary_uom -- invconv fabdi
1248:
1249: FROM wms_packaging_hist wpc

Line 1293: , INV_PROJECT.GET_LOCSEGS(milkfv.inventory_location_id,milkfv.organization_id);

1289: , mmtt.cost_group_id
1290: , ccg.cost_group
1291: , milkfv.subinventory_code
1292: , milkfv.inventory_location_id
1293: , INV_PROJECT.GET_LOCSEGS(milkfv.inventory_location_id,milkfv.organization_id);
1294:
1295:
1296: /*
1297: * The following cursor has been added for bug # 4998201.