414: grp_id
415: FROM CST_ITEM_COSTS CIC,
416: MTL_ITEM_FLEXFIELDS MIF,
417: CST_COST_TYPES CCT,
418: MTL_PARAMETERS MP
419: WHERE CIC.ORGANIZATION_ID = from_org_id
420: AND CIC.COST_TYPE_ID = from_cst_type_id
421: AND MP.ORGANIZATION_ID = to_org_id
422: AND NVL( CCT.ORGANIZATION_ID, to_org_id) = to_org_id
571: grp_id
572: FROM CST_ITEM_COSTS CIC,
573: MTL_ITEM_FLEXFIELDS MIF,
574: CST_COST_TYPES CCT,
575: MTL_PARAMETERS MP
576: WHERE CIC.ORGANIZATION_ID = from_org_id
577: AND CIC.COST_TYPE_ID = from_cst_type_id
578: AND CIC.INVENTORY_ITEM_ID = spec_item_id
579: AND MIF.ITEM_ID = CIC.INVENTORY_ITEM_ID
719: grp_id
720: FROM CST_ITEM_COSTS CIC,
721: MTL_ITEM_FLEXFIELDS MIF,
722: CST_COST_TYPES CCT,
723: MTL_PARAMETERS MP
724: WHERE CIC.ORGANIZATION_ID = from_org_id
725: AND CIC.COST_TYPE_ID = from_cst_type_id
726: AND MP.ORGANIZATION_ID = to_org_id
727: AND NVL( CCT.ORGANIZATION_ID, to_org_id) = to_org_id