DBA Data[Home] [Help]

APPS.CSTPCINT dependencies on BOM_RESOURCES

Line 132: FROM BOM_RESOURCES BR

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: ),

Line 139: FROM BOM_RESOURCES BR

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: ),