APPS.OPI_DBI_RES_PKG dependencies on BOM_DEPARTMENT_RESOURCES

Line 610: bom_department_resources bdr,

606: 24* bdr.capacity_units/m2.conversion_rate * crc.resource_rate avail_val_b,
607: OPI_SOURCE source
608: FROM bom_resources br,
609: bom_departments bd,
610: bom_department_resources bdr,
611: bom_calendar_dates bcd,
612: mtl_parameters mp,
613: mtl_uom_conversions m,
614: mtl_uom_conversions m2,

Line 683: bom_department_resources bdr,

679: end ) avail_val_b,
680: OPI_SOURCE source
681: FROM bom_resources br,
682: bom_departments bd,
683: bom_department_resources bdr,
684: bom_resource_shifts brs,
685: bom_shift_dates bsd,
686: bom_shift_times bst,
687: mtl_parameters mp,

Line 804: bom_department_resources bdr

800: wip_entities we,
801: mtl_uom_conversions m,
802: mtl_uom_conversions m2,
803: opi_dbi_run_log_curr rlc,
804: bom_department_resources bdr
805: WHERE
806: -- 1->resource trx 3-> outside processing,
807: -- both involve resource, other types don't have resource_id
808: Rlc.etl_id = ACTUAL_RES_ETL

Line 921: bom_department_resources bdr,

917: 24* bdr.capacity_units/m2.conversion_rate * crc.resource_rate avail_val_b,
918: OPI_SOURCE source
919: FROM bom_resources br,
920: bom_departments bd,
921: bom_department_resources bdr,
922: bom_calendar_dates bcd,
923: mtl_parameters mp,
924: mtl_uom_conversions m,
925: mtl_uom_conversions m2,

Line 992: bom_department_resources bdr,

988: end ) avail_val_b,
989: OPI_SOURCE source
990: FROM bom_resources br,
991: bom_departments bd,
992: bom_department_resources bdr,
993: bom_resource_shifts brs,
994: bom_shift_dates bsd,
995: bom_shift_times bst,
996: mtl_parameters mp,

Line 1092: use_nl(we) index(we, WE_C1) index(bdr, BOM_DEPARTMENT_RESOURCES_U1)

1088: job_type,
1089: assembly_item_id)
1090: SELECT /*+ ordered use_nl(rlc wt) index(rlc, OPI_DBI_RUN_LOG_CURR_N1)
1091: index(wt, WIP_TRANSACTIONS_U1) index(wta, WIP_TRANSACTION_ACCOUNTS_N1)
1092: use_nl(we) index(we, WE_C1) index(bdr, BOM_DEPARTMENT_RESOURCES_U1)
1093: use_nl(bdr) use_nl(m) use_nl(m2) */
1094: wt.resource_id,
1095: nvl(bdr.share_from_dept_id, wt.department_id ),
1096: wt.organization_id,

Line 1113: bom_department_resources bdr,

1109: FROM wip_transactions wt,
1110: wip_transaction_accounts wta,
1111: wip_entities we,
1112: opi_dbi_run_log_curr rlc,
1113: bom_department_resources bdr,
1114: mtl_uom_conversions m,
1115: mtl_uom_conversions m2
1116: WHERE
1117: -- 1->resource trx 3-> outside processing,

Line 2815: bom_department_resources bdr

2811: mtl_parameters mp,
2812: mtl_uom_conversions m,
2813: mtl_uom_conversions m2,
2814: cst_resource_costs crc,
2815: bom_department_resources bdr
2816: WHERE job.job_type IN (1,2,5) -- Discrete and Repetitive also OSFM
2817: AND job.std_res_flag = 1
2818: AND job.source = 1
2819: AND wor.organization_id = job.organization_id

Line 3710: bom_department_resources bdr

3706: mtl_parameters mp,
3707: mtl_uom_conversions m,
3708: mtl_uom_conversions m2,
3709: cst_resource_costs crc,
3710: bom_department_resources bdr
3711: WHERE job.job_type IN (1,2,5) -- Discrete and Repetitive also OSFM
3712: AND job.std_res_flag = 1
3713: AND wor.organization_id = job.organization_id
3714: AND job.job_id = Nvl(wor.repetitive_schedule_id, wor.wip_entity_id)