APPS.CST_MGD_LIFO_COST_PROCESSOR dependencies on CST_COST_GROUPS

Line 945: cst_cost_groups cg

941: , kfv.concatenated_segments
942: , msi.primary_uom_code
943: , (pic.item_cost * pic.total_layer_quantity)
944: FROM
945: cst_cost_groups cg
946: , cst_le_cost_types clt
947: , cst_pac_periods pp
948: , cst_pac_item_costs pic
949: , cst_pac_quantity_layers pql

Line 1004: cst_cost_groups cg

1000: , kfv.concatenated_segments
1001: , msi.primary_uom_code
1002: , (pic.market_value * pic.total_layer_quantity)
1003: FROM
1004: cst_cost_groups cg
1005: , cst_le_cost_types clt
1006: , cst_pac_periods pp
1007: , cst_pac_item_costs pic
1008: , cst_pac_quantity_layers pql

Line 1192: cst_cost_groups cg

1188: , kfv.concatenated_segments
1189: , msi.primary_uom_code
1190: , (pic.item_cost * pic.total_layer_quantity)
1191: FROM
1192: cst_cost_groups cg
1193: , cst_le_cost_types clt
1194: , cst_pac_periods pp
1195: , cst_pac_item_costs pic
1196: , cst_pac_quantity_layers pql

Line 1248: cst_cost_groups cg

1244: , kfv.concatenated_segments
1245: , msi.primary_uom_code
1246: , (pic.market_value * pic.total_layer_quantity)
1247: FROM
1248: cst_cost_groups cg
1249: , cst_le_cost_types clt
1250: , cst_pac_periods pp
1251: , cst_pac_item_costs pic
1252: , cst_pac_quantity_layers pql

Line 1318: cst_cost_groups cg

1314: , kfv.concatenated_segments
1315: , msi.primary_uom_code
1316: , (pic.item_cost * pic.total_layer_quantity)
1317: FROM
1318: cst_cost_groups cg
1319: , cst_le_cost_types clt
1320: , cst_pac_periods pp
1321: , cst_pac_item_costs pic
1322: , cst_pac_quantity_layers pql

Line 1379: cst_cost_groups cg

1375: , kfv.concatenated_segments
1376: , msi.primary_uom_code
1377: , (pic.market_value * pic.total_layer_quantity)
1378: FROM
1379: cst_cost_groups cg
1380: , cst_le_cost_types clt
1381: , cst_pac_periods pp
1382: , cst_pac_item_costs pic
1383: , cst_pac_quantity_layers pql

Line 1484: FROM cst_cost_groups

1480: -- First find the master organization
1481:
1482: SELECT organization_id
1483: INTO l_master_org
1484: FROM cst_cost_groups
1485: WHERE cost_group_id = p_cost_group_id;
1486:
1487: -- Calculate the min and max ranges
1488:

Line 1742: FROM cst_cost_groups ccg,

1738: cst_le_cost_types clct
1739: WHERE cct.cost_type_id = clct.cost_type_id
1740: AND clct.legal_entity =
1741: (SELECT DISTINCT ccg.legal_entity
1742: FROM cst_cost_groups ccg,
1743: cst_cost_group_assignments ccga
1744: WHERE ccg.cost_group_id = ccga.cost_group_id
1745: AND ccg.cost_group_type = 2
1746: AND ccg.cost_group IN

Line 1886: FROM cst_cost_groups ccg,

1882: cst_le_cost_types clct
1883: WHERE cct.cost_type_id = clct.cost_type_id
1884: AND clct.legal_entity =
1885: (SELECT DISTINCT ccg.legal_entity
1886: FROM cst_cost_groups ccg,
1887: cst_cost_group_assignments ccga
1888: WHERE ccg.cost_group_id = ccga.cost_group_id
1889: AND ccg.cost_group_type = 2
1890: AND ccg.cost_group IN

Line 2478: FROM CST_COST_GROUPS ccg,

2474: CURSOR master_org_cur(c_cost_group_id NUMBER) IS
2475: SELECT
2476: ccg.organization_id,
2477: HOU.name
2478: FROM CST_COST_GROUPS ccg,
2479: HR_ORGANIZATION_UNITS HOU,
2480: HR_ORGANIZATION_INFORMATION HOI
2481: WHERE HOU.ORGANIZATION_ID = HOI.ORGANIZATION_ID
2482: AND HOI.ORG_INFORMATION1 = 'INV'