APPS.CSTPPWRO dependencies on CST_COST_GROUP_ASSIGNMENTS

Line 977: cst_cost_group_assignments ccga

973: CURSOR c_wip_entities_mov IS
974: SELECT we.wip_entity_id entity_id,
975: we.entity_type entity_type
976: FROM wip_entities we,
977: cst_cost_group_assignments ccga
978: WHERE ccga.cost_group_id = p_cost_group_id
979: AND we.organization_id = ccga.organization_id
980: AND we.entity_type <> 4 -- NOT CFM
981: AND we.primary_item_id IS NOT NULL

Line 998: cst_cost_group_assignments ccga

994: SELECT we.wip_entity_id entity_id,
995: we.entity_type entity_type,
996: we.organization_id org_id
997: FROM wip_entities we,
998: cst_cost_group_assignments ccga
999: WHERE ccga.cost_group_id = p_cost_group_id
1000: AND we.organization_id = ccga.organization_id
1001: AND EXISTS
1002: ( SELECT 'X'

Line 1194: FROM cst_cost_group_assignments ccga

1190: AND (TRUNC(p_end_date) + 0.99999)
1191: AND wcti.transaction_type IN (1,2,3,6)
1192: AND EXISTS (
1193: SELECT 'X'
1194: FROM cst_cost_group_assignments ccga
1195: WHERE ccga.cost_group_id = p_cost_group_id
1196: AND ccga.organization_id = wcti.organization_id
1197: );
1198:

Line 1979: FROM cst_cost_group_assignments ccga,

1975: wmt.fm_intraoperation_step_type from_op_step,
1976: wmt.to_operation_seq_num to_op_seq,
1977: wmt.to_intraoperation_step_type to_op_step,
1978: wmt.primary_quantity pri_qty
1979: FROM cst_cost_group_assignments ccga,
1980: wip_move_transactions wmt
1981: WHERE wmt.transaction_date BETWEEN TRUNC(p_start_date)
1982: AND (TRUNC(p_end_date) + 0.99999)
1983: AND wmt.organization_id = ccga.organization_id