APPS.INV_LABEL_PVT5 dependencies on CST_COST_GROUPS

Line 917: , cst_cost_groups ccg

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
917: , cst_cost_groups ccg
918: , mtl_item_locations milkfv
919: WHERE plpn.lpn_id in (select lpn_id from wms_license_plate_numbers
920: where 1=1
921: -- Bug 4137707

Line 1035: , cst_cost_groups ccg

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
1035: , cst_cost_groups ccg
1036: , mtl_item_locations milkfv
1037: WHERE plpn.lpn_id in (select lpn_id from wms_license_plate_numbers
1038: where 1=1
1039: start with lpn_id in (select nvl(p_lpn_id, -99) from dual

Line 1104: , cst_cost_groups ccg

1100:
1101: FROM wms_packaging_hist wpc
1102: , mtl_material_transactions_temp mmtt
1103: , mtl_system_items msi
1104: , cst_cost_groups ccg
1105: , mtl_item_locations milkfv
1106: -- Bug 4137707, Do not need to include this where clause,
1107: -- This will be controlled when opening this cursor
1108: -- WHERE cartonization_flag = 1 --Cartonization Flow

Line 1162: , cst_cost_groups ccg

1158: , p_lot_number VARCHAR) IS
1159: SELECT msn.cost_group_id
1160: , ccg.cost_group
1161: FROM mtl_serial_numbers msn
1162: , cst_cost_groups ccg
1163: WHERE msn.lpn_id = p_lpn_id
1164: AND msn.inventory_item_id = p_inventory_item_id
1165: AND msn.lot_number = p_lot_number
1166: AND msn.cost_group_id = ccg.cost_group_id;