DBA Data[Home] [Help]

APPS.CSTPPPOI dependencies on CST_COST_GROUP_ASSIGNMENTS

Line 108: cst_cost_group_assignments ccga

104: ccg.legal_entity
105: INTO x_cost_group_id,
106: x_legal_entity
107: FROM cst_cost_groups ccg,
108: cst_cost_group_assignments ccga
109: WHERE ccg.cost_group_id = ccga.cost_group_id
110: AND ccg.cost_group_type = 2
111: AND ccg.cost_group = ( SELECT cpici.cost_group
112: FROM cst_pc_item_cost_interface cpici

Line 267: cst_cost_group_assignments ccga

263:
264: SELECT DISTINCT msi.inventory_item_id
265: INTO x_item_id
266: FROM mtl_system_items msi,
267: cst_cost_group_assignments ccga
268: WHERE msi.organization_id = ccga.organization_id
269: AND ccga.cost_group_id = x_cost_group_id
270: AND msi.inventory_item_id = ( SELECT cpici.inventory_item_id
271: FROM cst_pc_item_cost_interface cpici

Line 459: cst_cost_group_assignments ccga

455: WHERE cpici.interface_header_id = x_interface_header_id )
456: AND clct.legal_entity =
457: (SELECT DISTINCT ccg.legal_entity
458: FROM cst_cost_groups ccg,
459: cst_cost_group_assignments ccga
460: WHERE ccg.cost_group_id = ccga.cost_group_id
461: AND ccg.cost_group_type = 2
462: AND ccg.cost_group =
463: (SELECT cpici.cost_group