APPS.CST_PERIODIC_ABSORPTION_PROC dependencies on CST_COST_GROUPS

Line 1038: FROM cst_cost_groups

1034: END IF;
1035:
1036: SELECT NVL(organization_id,-1)
1037: INTO l_master_org_id
1038: FROM cst_cost_groups
1039: WHERE cost_group_id = p_cost_group_id;
1040:
1041: -- Validate that all the orgs under this cost group
1042: -- have the same master.

Line 1355: FROM cst_cost_groups ccg

1351: END IF;
1352:
1353: SELECT count(1)
1354: INTO l_count
1355: FROM cst_cost_groups ccg
1356: WHERE ccg.legal_entity = p_legal_entity
1357: AND ccg.cost_group_id = p_cost_group_id
1358: AND trunc(nvl(ccg.disable_date, SYSDATE+1)) > trunc(SYSDATE)
1359: AND EXISTS (

Line 2789: FROM mtl_material_transactions mmt, cst_cost_groups ccg, cst_cost_group_assignments ccga

2785: FROM
2786: (
2787: SELECT /*+ leading (MMT) INDEX (MMT MTL_MATERIAL_TRANSACTIONS_N5)*/
2788: mmt.inventory_item_id inventory_item_id
2789: FROM mtl_material_transactions mmt, cst_cost_groups ccg, cst_cost_group_assignments ccga
2790: WHERE mmt.transaction_date between p_period_start_date AND p_period_end_date
2791: AND mmt.organization_id = nvl(mmt.owning_organization_id, mmt.organization_id)
2792: AND nvl(mmt.owning_tp_type,2) = 2
2793: AND ccg.legal_entity = p_legal_entity_id

Line 2802: FROM mtl_material_transactions mmt, cst_pac_periods cpp, cst_cost_groups ccg

2798: WHERE cpllc.inventory_item_id = mmt.inventory_item_id
2799: AND cpllc.pac_period_id = p_period_id)
2800: UNION ALL
2801: SELECT mmt.inventory_item_id inventory_item_id
2802: FROM mtl_material_transactions mmt, cst_pac_periods cpp, cst_cost_groups ccg
2803: WHERE mmt.transaction_date between p_period_start_date AND p_period_end_date
2804: AND mmt.transaction_action_id = 24
2805: AND mmt.transaction_source_type_id = 14
2806: AND mmt.transaction_type_id = 26

Line 2821: FROM cst_cost_groups ccg,

2817: AND cpllc.pac_period_id = p_period_id)
2818: UNION ALL
2819: SELECT /*+ ORDERED INDEX (MMT MTL_MATERIAL_TRANSACTIONS_N5)*/
2820: mmt.inventory_item_id inventory_item_id
2821: FROM cst_cost_groups ccg,
2822: cst_cost_group_assignments ccga,
2823: mtl_interorg_parameters mip,
2824: mtl_material_transactions mmt
2825: WHERE mmt.transaction_date between p_period_start_date AND p_period_end_date

Line 5097: FROM cst_cost_groups ccg

5093: CURSOR cst_grp_csr_type IS
5094: SELECT
5095: ccg.cost_group_id cost_group_id
5096: , ccg.cost_group cost_group
5097: FROM cst_cost_groups ccg
5098: , cst_le_cost_types clct
5099: WHERE ccg.legal_entity = clct.legal_entity
5100: AND clct.legal_entity = p_legal_entity
5101: AND clct.cost_type_id = p_cost_type_id;