APPS.EAM_CONSTRUCTION_EST_PVT dependencies on BOM_RESOURCES

Line 118: FROM CST_RESOURCE_COSTS CRC, BOM_RESOURCES BR

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

Line 813: BOM_RESOURCES BR

809: DECODE(BSOR.SCHEDULE_FLAG,2,NULL,BSOR.RESOURCE_SEQ_NUM) ,
810: BSOR.SUBSTITUTE_GROUP_NUM
811: FROM BOM_STANDARD_OPERATIONS BSO,
812: BOM_STD_OP_RESOURCES BSOR,
813: BOM_RESOURCES BR
814: WHERE BSO.STANDARD_OPERATION_ID = BSOR.STANDARD_OPERATION_ID
815: AND BR.RESOURCE_ID = BSOR.RESOURCE_ID
816: AND BSO.STANDARD_OPERATION_ID = p_std_op_id
817: AND BSO.ORGANIZATION_ID = p_org_id;