APPS.BOM_MIXED_MODEL_MAP_PVT dependencies on BOM_RESOURCES

Line 24: TYPE resource_id_type is TABLE of bom_resources.resource_id%TYPE

20: G_DAYS CONSTANT NUMBER := 1;
21: G_WEEKS CONSTANT NUMBER := 2;
22: G_PERIODS CONSTANT NUMBER := 3;
23: --below is new code
24: TYPE resource_id_type is TABLE of bom_resources.resource_id%TYPE
25: INDEX BY BINARY_INTEGER;
26: TYPE dept_id_type is TABLE of bom_department_resources.department_id%TYPE
27: INDEX BY BINARY_INTEGER;
28: --above is new code

Line 213: bom_resources br,

209:
210: CURSOR GetLineOpResourceId IS
211: SELECT bopr.resource_id id , bosv.department_id dept_id
212: FROM bom_operation_resources bopr,
213: bom_resources br,
214: bom_operation_sequences_v bosv,
215: bom_operational_routings bor
216: WHERE bopr.operation_sequence_id= bosv.operation_sequence_id
217: AND bopr.resource_id = br.resource_id

Line 230: bom_resources br,

226:
227: CURSOR GetProcessResourceId IS
228: SELECT bopr.resource_id id , bosv.department_id dept_id
229: FROM bom_operation_resources bopr,
230: bom_resources br,
231: bom_operation_sequences_v bosv,
232: bom_operational_routings bor
233: WHERE bopr.operation_sequence_id= bosv.operation_sequence_id
234: AND bopr.resource_id = br.resource_id

Line 1493: bom_resources br,

1489: nvl(bos1.net_planning_percent, 100) / 100 /
1490: decode(bos1.reverse_cumulative_yield, '', 1,
1491: '0', 1, bos1.reverse_cumulative_yield)) resource_needed
1492: from bom_operation_resources bor,
1493: bom_resources br,
1494: bom_operational_routings brtg,
1495: bom_operation_sequences bos1,
1496: bom_operation_sequences bos2,
1497: mtl_uom_conversions con

Line 1746: bom_resources br

1742: p_org_id,
1743: l_res_detail_table(l_index).resource_needed
1744: from cst_activities ca,
1745: bom_standard_operations bso,
1746: bom_resources br
1747: where ca.activity_id = l_res_detail_table(l_index).activity_id
1748: and bso.standard_operation_id = l_res_detail_table(l_index).standard_operation_id
1749: and br.resource_id = l_res_detail_table(l_index).resource_id;
1750: else

Line 1775: bom_resources br

1771: br.resource_type,
1772: p_org_id,
1773: l_res_detail_table(l_index).resource_needed
1774: from bom_standard_operations bso,
1775: bom_resources br
1776: where bso.standard_operation_id = l_res_detail_table(l_index).standard_operation_id
1777: and br.resource_id = l_res_detail_table(l_index).resource_id;
1778: end if;
1779: EXIT WHEN l_index = l_res_detail_table.LAST;