APPS.INV_LABEL_PVT5 dependencies on INV_PROJECT

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

908: , nvl(p_cost_group_id, wlc.cost_group_id) cost_group_id
909: , ccg.cost_group cost_group
910: , milkfv.subinventory_code subinventory_code
911: , milkfv.inventory_location_id locator_id
912: , INV_PROJECT.GET_LOCSEGS(milkfv.inventory_location_id,milkfv.organization_id) locator
913: , sum(nvl(l_secondary_quantity,wlc.secondary_quantity)) secondary_quantity -- invconv fabdi
914: , wlc.secondary_uom_code secondary_uom -- invconv fabdi
915: FROM wms_lpn_contents wlc
916: , wms_license_plate_numbers plpn

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

967: , nvl(p_cost_group_id, wlc.cost_group_id)
968: , ccg.cost_group
969: , milkfv.subinventory_code
970: , milkfv.inventory_location_id
971: , INV_PROJECT.GET_LOCSEGS(milkfv.inventory_location_id,milkfv.organization_id)
972: , wlc.secondary_uom_code;
973:
974: --Bug 4891916 -Added the cursor to fetch from mcce
975: CURSOR mcce_lpn_cur IS

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

1026: , wlc.cost_group_id cost_group_id
1027: , ccg.cost_group cost_group
1028: , milkfv.subinventory_code subinventory_code
1029: , milkfv.inventory_location_id locator_id
1030: , INV_PROJECT.GET_LOCSEGS(milkfv.inventory_location_id,milkfv.organization_id) locator
1031: , sum(nvl(l_secondary_quantity,wlc.secondary_quantity)) secondary_quantity -- invconv fabdi
1032: , wlc.secondary_uom_code secondary_uom -- invconv fabdi
1033: FROM wms_lpn_contents wlc
1034: , wms_license_plate_numbers plpn

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

1074: , wlc.cost_group_id
1075: , ccg.cost_group
1076: , milkfv.subinventory_code
1077: , milkfv.inventory_location_id
1078: , INV_PROJECT.GET_LOCSEGS(milkfv.inventory_location_id,milkfv.organization_id)
1079: , wlc.secondary_uom_code
1080:
1081: UNION ALL
1082:

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

1093: , mmtt.cost_group_id cost_group_id
1094: , ccg.cost_group cost_group
1095: , milkfv.subinventory_code subinventory_code
1096: , milkfv.inventory_location_id locator_id
1097: , INV_PROJECT.GET_LOCSEGS(milkfv.inventory_location_id,milkfv.organization_id) locator
1098: , l_secondary_quantity secondary_quantity -- invconv fabdi
1099: , l_secondary_uom secondary_uom -- invconv fabdi
1100:
1101: FROM wms_packaging_hist wpc

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

1141: , mmtt.cost_group_id
1142: , ccg.cost_group
1143: , milkfv.subinventory_code
1144: , milkfv.inventory_location_id
1145: , INV_PROJECT.GET_LOCSEGS(milkfv.inventory_location_id,milkfv.organization_id);
1146:
1147:
1148: /*
1149: * The following cursor has been added for bug # 4998201.