DBA Data[Home] [Help]

APPS.WSM_LBJ_INTERFACE_PVT dependencies on BOM_STD_OP_RESOURCES

Line 15917: FROM bom_std_op_resources bsor

15913: select 1
15914: into l_temp
15915: from dual
15916: where exists ( SELECT 1
15917: FROM bom_std_op_resources bsor
15918: WHERE bsor.standard_operation_id = v_wljdi_std_op_id(l_d)
15919: AND bsor.autocharge_type = WIP_CONSTANTS.PO_MOVE)
15920: or exists ( SELECT 1
15921: FROM bom_std_sub_op_resources bsor

Line 16063: bom_std_op_resources bsor

16059: bsor.attribute15,
16060: null
16061: from wsm_copy_operations wco,
16062: bom_resources br,
16063: bom_std_op_resources bsor
16064: where bsor.standard_operation_id = v_wljdi_std_op_id(l_d)
16065: and br.resource_id = bsor.resource_id
16066: and nvl(br.disable_date, SYSDATE + 1) > SYSDATE
16067: and wco.organization_id = p_org_id

Line 16203: from bom_std_op_resources bsor1

16199: and wco.organization_id = p_org_id
16200: and wco.wip_entity_id = p_wip_entity_id
16201: and wco.operation_seq_num = v_wljdi_routing_op_seq_num(l_d)
16202: and exists (select 1
16203: from bom_std_op_resources bsor1
16204: where bsor1.standard_operation_id = bsor.standard_operation_id
16205: and bsor1.substitute_group_num = bsor.substitute_group_num )
16206: and wcor.wip_entity_id = wco.wip_entity_id
16207: and wcor.operation_seq_num = wco.operation_seq_num