DBA Data[Home] [Help]

APPS.BOM_MIXED_MODEL_MAP_PVT dependencies on BOM_OPERATION_RESOURCES

Line 212: FROM bom_operation_resources bopr,

208: resource_table IN OUT NOCOPY resource_id_type ) IS
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

Line 229: FROM bom_operation_resources bopr,

225: AND bosv.line_op_code = p_op_code;
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

Line 1492: from bom_operation_resources bor,

1488: nvl(l_hour_conv, 1) *
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,