APPS.INV_LABEL_PVT5 dependencies on CST_COST_GROUPS

Line 1062: , cst_cost_groups ccg

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
1062: , cst_cost_groups ccg
1063: , mtl_item_locations milkfv
1064: WHERE plpn.lpn_id in (select /*+ cardinality(1) */ lpn_id from wms_license_plate_numbers
1065: where 1=1
1066: -- Bug 4137707

Line 1181: , cst_cost_groups ccg

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
1181: , cst_cost_groups ccg
1182: , mtl_item_locations milkfv
1183: WHERE plpn.lpn_id in (
1184: select /*+ cardinality(1) */ id from
1185: ((select lpn_id id from wms_license_plate_numbers

Line 1252: , cst_cost_groups ccg

1248:
1249: FROM wms_packaging_hist wpc
1250: , mtl_material_transactions_temp mmtt
1251: , mtl_system_items msi
1252: , cst_cost_groups ccg
1253: , mtl_item_locations milkfv
1254: -- Bug 4137707, Do not need to include this where clause,
1255: -- This will be controlled when opening this cursor
1256: -- WHERE cartonization_flag = 1 --Cartonization Flow

Line 1310: , cst_cost_groups ccg

1306: , p_lot_number VARCHAR) IS
1307: SELECT msn.cost_group_id
1308: , ccg.cost_group
1309: FROM mtl_serial_numbers msn
1310: , cst_cost_groups ccg
1311: WHERE msn.lpn_id = p_lpn_id
1312: AND msn.inventory_item_id = p_inventory_item_id
1313: AND msn.lot_number = p_lot_number
1314: AND msn.cost_group_id = ccg.cost_group_id;