DBA Data[Home] [Help]

APPS.WIP_OPERATIONS_PKG dependencies on BOM_RESOURCES

Line 284: bom_resources br,

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

Line 446: FROM BOM_RESOURCES BR,

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