DBA Data[Home] [Help]

APPS.CSTPSMUT dependencies on BOM_RESOURCES

Line 3157: bom_resources BR

3153: x_tl_res_cost,
3154: x_tl_osp_cost
3155: FROM cst_resource_costs CRC,
3156: wip_operation_resources WOR,
3157: bom_resources BR
3158: WHERE
3159: CRC.COST_TYPE_ID(+) = 1
3160: AND CRC.RESOURCE_ID(+) = WOR.RESOURCE_ID
3161: AND WOR.OPERATION_SEQ_NUM <= l_operation_seq_num

Line 3203: bom_resources BR,

3199: wip_operations WO,
3200: wip_operation_resources WOR,
3201: cst_resource_overheads CRO,
3202: cst_department_overheads CDO,
3203: bom_resources BR,
3204: cst_resource_costs CRC
3205: WHERE
3206: WO.wip_entity_id = p_entity_id
3207: AND WOR.resource_id = BR.resource_id

Line 3479: FROM bom_resources br,

3475: decode (br.functional_currency_flag,
3476: 1, 1,
3477: nvl(crc.resource_rate,0)))
3478: ,0))/l_min_acct_unit) * l_min_acct_unit
3479: FROM bom_resources br,
3480: cst_resource_costs crc
3481: WHERE
3482: br.resource_id = wor.resource_id
3483: AND br.organization_id = l_org_id