DBA Data[Home] [Help]

APPS.WSM_LBJ_INTERFACE_PVT dependencies on BOM_STD_OP_RESOURCES

Line 16293: FROM bom_std_op_resources bsor

16289: select 1
16290: into l_temp
16291: from dual
16292: where exists ( SELECT 1
16293: FROM bom_std_op_resources bsor
16294: WHERE bsor.standard_operation_id = v_wljdi_std_op_id(l_d)
16295: AND bsor.autocharge_type = WIP_CONSTANTS.PO_MOVE)
16296: or exists ( SELECT 1
16297: FROM bom_std_sub_op_resources bsor

Line 16439: bom_std_op_resources bsor

16435: bsor.attribute15,
16436: null
16437: from wsm_copy_operations wco,
16438: bom_resources br,
16439: bom_std_op_resources bsor
16440: where bsor.standard_operation_id = v_wljdi_std_op_id(l_d)
16441: and br.resource_id = bsor.resource_id
16442: and nvl(br.disable_date, SYSDATE + 1) > SYSDATE
16443: and wco.organization_id = p_org_id

Line 16579: from bom_std_op_resources bsor1

16575: and wco.organization_id = p_org_id
16576: and wco.wip_entity_id = p_wip_entity_id
16577: and wco.operation_seq_num = v_wljdi_routing_op_seq_num(l_d)
16578: and exists (select 1
16579: from bom_std_op_resources bsor1
16580: where bsor1.standard_operation_id = bsor.standard_operation_id
16581: and bsor1.substitute_group_num = bsor.substitute_group_num )
16582: and wcor.wip_entity_id = wco.wip_entity_id
16583: and wcor.operation_seq_num = wco.operation_seq_num