128: ),
129: /* Bug 5443502: for resource_id and basis_resource_id, added join with cost_element_id */
130: RESOURCE_ID = (
131: SELECT BR.RESOURCE_ID
132: FROM BOM_RESOURCES BR
133: WHERE BR.RESOURCE_CODE = CICDI.RESOURCE_CODE
134: AND BR.ORGANIZATION_ID = CICDI.ORGANIZATION_ID
135: AND BR.COST_ELEMENT_ID = CICDI.COST_ELEMENT_ID
136: ),
135: AND BR.COST_ELEMENT_ID = CICDI.COST_ELEMENT_ID
136: ),
137: BASIS_RESOURCE_ID = (
138: SELECT BR.RESOURCE_ID
139: FROM BOM_RESOURCES BR
140: WHERE BR.RESOURCE_CODE = CICDI.BASIS_RESOURCE_CODE
141: AND BR.ORGANIZATION_ID = CICDI.ORGANIZATION_ID
142: AND BR.COST_ELEMENT_ID = CICDI.COST_ELEMENT_ID
143: ),