DBA Data[Home] [Help]

APPS.WIP_OPERATIONS_PKG dependencies on BOM_RESOURCES

Line 282: bom_resources br,

278: bsor.substitute_group_num, -- Added : -- bug 7371859
279: bsor.resource_seq_num, -- Added : -- bug 7371859(Schedule Seq Num= Resource Seq Num)
280: 0 -- Added : -- bug 7371859
281: from wip_operations wo,
282: bom_resources br,
283: bom_std_op_resources bsor
284: where bsor.standard_operation_id = p_operation_id
285: and br.resource_id = bsor.resource_id
286: and nvl(br.disable_date, SYSDATE + 1) > SYSDATE

Line 444: FROM BOM_RESOURCES BR,

440: BSSOR.schedule_seq_num ,
441: BSSOR.substitute_group_num,
442: BSSOR.replacement_group_num,
443: NULL --setup_id
444: FROM BOM_RESOURCES BR,
445: BOM_STD_SUB_OP_RESOURCES BSSOR
446: WHERE bssor.standard_operation_id=p_operation_id
447: AND BSSOR.RESOURCE_ID = BR.RESOURCE_ID;
448: