APPS.EAM_CONSTRUCTION_EST_PVT dependencies on BOM_RESOURCES

Line 113: FROM CST_RESOURCE_COSTS CRC, BOM_RESOURCES BR

109: SELECT ROUND(DECODE(BR.FUNCTIONAL_CURRENCY_FLAG, 1, 1,
110: NVL(CRC.RESOURCE_RATE,0)) * 1 -- 1 TO REPRESENT UNIT RESOURCE QUANTITY
111: * DECODE(NULL, 1, NULL, 2, 1, 1) ,p_ext_precision)
112: INTO X_UNIT_RESOURCE_VALUE
113: FROM CST_RESOURCE_COSTS CRC, BOM_RESOURCES BR
114: WHERE CRC.RESOURCE_ID = p_resource_id
115: AND BR.RESOURCE_ID = CRC.RESOURCE_ID
116: AND BR.ORGANIZATION_ID = p_org_id
117: AND CRC.COST_TYPE_ID = p_cost_type_id;

Line 756: BOM_RESOURCES BR

752: DECODE(BSOR.SCHEDULE_FLAG,2,NULL,BSOR.RESOURCE_SEQ_NUM) ,
753: BSOR.SUBSTITUTE_GROUP_NUM
754: FROM BOM_STANDARD_OPERATIONS BSO,
755: BOM_STD_OP_RESOURCES BSOR,
756: BOM_RESOURCES BR
757: WHERE BSO.STANDARD_OPERATION_ID = BSOR.STANDARD_OPERATION_ID
758: AND BR.RESOURCE_ID = BSOR.RESOURCE_ID
759: AND BSO.STANDARD_OPERATION_ID = p_std_op_id
760: AND BSO.ORGANIZATION_ID = p_org_id;