DBA Data[Home] [Help]

APPS.CST_ITEM_COST_IMPORT_INTERFACE dependencies on CST_RESOURCE_OVERHEADS

Line 745: AND EXISTS (select 1 from CST_RESOURCE_OVERHEADS cro

741: AND cicdi2.cost_type_id = cicdi1.cost_type_id
742: AND cicdi2.cost_element_id in (3,4)
743: AND cicdi2.error_flag is null
744: AND cicdi2.group_id = SEQ_NEXTVAL
745: AND EXISTS (select 1 from CST_RESOURCE_OVERHEADS cro
746: WHERE cro.cost_type_id = cicdi1.cost_type_id
747: AND cro.organization_id = cicdi1.organization_id
748: AND cro.overhead_id = cicdi1.resource_id
749: AND cro.resource_id = cicdi2.resource_id))

Line 791: AND EXISTS ( select 1 from CST_RESOURCE_OVERHEADS cro

787: AND cicdi2.cost_type_id = cicdi1.cost_type_id
788: AND cicdi2.error_flag is null
789: AND cicdi2.group_id = SEQ_NEXTVAL
790: AND cicdi2.cost_element_id IN (3,4)
791: AND EXISTS ( select 1 from CST_RESOURCE_OVERHEADS cro
792: WHERE cro.organization_id = cicdi2.organization_id
793: AND cro.cost_type_id = cicdi2.cost_type_id
794: AND cro.overhead_id = cicdi1.resource_id
795: AND cro.resource_id = cicdi2.resource_id))