DBA Data[Home] [Help]

APPS.WIP_PROD_INDICATORS dependencies on BOM_RESOURCES

Line 1277: bom_resources br,

1273: sum(inv_convert.inv_um_convert(0,NULL,wt.primary_quantity,
1274: wt.primary_uom,g_uom_code,
1275: NULL,NULL)) applied_units_utz
1276: FROM
1277: bom_resources br,
1278: bom_departments bd,
1279: bom_department_resources bdr,
1280: wip_transactions wt,
1281: mtl_units_of_measure muom

Line 1990: bom_resources br,

1986: wit.creation_date,
1987: wit.created_by,
1988: wit.program_application_id
1989: from wip_indicators_temp wit,
1990: bom_resources br,
1991: bom_departments bd,
1992: bom_department_resources bdr,
1993: wip_operation_resources wor,
1994: mtl_units_of_measure muom

Line 2188: bom_resources br,

2184: SYSDATE,
2185: g_userid,
2186: g_applicationid
2187: from
2188: bom_resources br,
2189: bom_departments bd,
2190: bom_department_resources bdr,
2191: wip_transactions wt,
2192: mtl_units_of_measure muom

Line 2695: bom_resources br,

2691: wit.creation_date,
2692: wit.created_by,
2693: wit.program_application_id
2694: from wip_indicators_temp wit,
2695: bom_resources br,
2696: wip_operation_resources wor
2697: where wor.wip_entity_id = wit.wip_entity_id
2698: and wor.operation_seq_num = wit.operation_seq_num
2699: and wit.indicator_type = WIP_YIELD

Line 3407: bom_resources br,

3403: GROUP BY organization_id,
3404: department_id,
3405: resource_id,
3406: transaction_date) wit,
3407: bom_resources br,
3408: bom_departments bd,
3409: wip_bis_mnra_temp mnra,
3410: mtl_units_of_measure muom
3411: where mnra.shift_date BETWEEN trunc(g_date_from)

Line 3539: bom_resources br,

3535: -1, ( 86400 - mnra.from_time ) + mnra.to_time,
3536: 1, ( mnra.to_time - mnra.from_time ) , 0 ))/3600)*mnra.capacity_units)) available_hours,
3537: trunc(mnra.shift_date) shift_date
3538: FROM
3539: bom_resources br,
3540: bom_departments bd,
3541: mrp_net_resource_avail mnra,
3542: mtl_units_of_measure muom
3543: where

Line 4462: bom_resources br,

4458: SYSDATE,
4459: g_userid,
4460: g_applicationid
4461: from
4462: bom_resources br,
4463: bom_departments bd,
4464: mrp_net_resource_avail mnra,
4465: mtl_units_of_measure muom
4466: where

Line 4945: bom_resources br,

4941: SYSDATE,
4942: g_userid,
4943: g_applicationid
4944: from
4945: bom_resources br,
4946: bom_departments bd,
4947: mrp_net_resource_avail mnra,
4948: mtl_units_of_measure muom
4949: where

Line 5122: bom_resources br,

5118: SYSDATE,
5119: g_userid,
5120: g_applicationid
5121: from
5122: bom_resources br,
5123: bom_departments bd,
5124: mrp_net_resource_avail mnra,
5125: mtl_units_of_measure muom
5126: where