DBA Data[Home] [Help]

APPS.EAM_PROCESS_WO_PVT dependencies on BOM_RESOURCES

Line 8411: bom_resources br

8407: decode(bsor.SCHEDULE_FLAG,2,null,bsor.resource_seq_num) ,
8408: bsor.SUBSTITUTE_GROUP_NUM
8409: from bom_standard_operations bso,
8410: bom_std_op_resources bsor,
8411: bom_resources br
8412: where bso.standard_operation_id = bsor.standard_operation_id
8413: and br.resource_id = bsor.resource_id
8414: and bso.standard_operation_id = l_eam_op_tbl(J).standard_operation_id
8415: and bso.organization_id = l_eam_op_tbl(J).organization_id;

Line 8529: bom_resources br

8525: decode(wor.SCHEDULED_FLAG,2,null,wor.resource_seq_num) ,
8526: wor.SUBSTITUTE_GROUP_NUM
8527: from wip_operations wo,
8528: wip_OPERATION_resources wor,
8529: bom_resources br
8530: where wo.OPERATION_SEQ_NUM = wor.OPERATION_SEQ_NUM
8531: and br.resource_id = wor.resource_id
8532: AND wo.wip_entity_id = wor.wip_entity_id
8533: and wo.OPERATION_SEQ_NUM = l_eam_op_tbl(J).OPERATION_SEQ_NUM