APPS.WSM_MES_UTILITIES_PVT dependencies on WSM_LOT_BASED_JOBS

Line 277: from wsm_lot_based_jobs

273: /* internal_copy_type = 0 if succeeded, 3 if failed */
274: begin
275: select nvl(internal_copy_type,0)
276: into l_internal_copy_type
277: from wsm_lot_based_jobs
278: where wip_entity_id = p_wip_entity_id;
279:
280: exception
281: when no_data_found then

Line 503: FROM wsm_lot_based_jobs

499:
500: begin
501: SELECT current_rtg_op_seq_num
502: INTO l_routing_op_seq_num
503: FROM wsm_lot_based_jobs
504: WHERE wip_entity_id = p_wip_entity_id;
505: exception
506: when no_data_found then
507: l_routing_op_seq_num := null;

Line 768: wsm_lot_based_jobs WLBJ

764: from wip_discrete_jobs WDJ,
765: wip_entities WE,
766: wip_operations WO,
767: wip_operation_resources WOR,
768: wsm_lot_based_jobs WLBJ
769: where WE.entity_type in (5, 8)
770: and WDJ.wip_entity_id = we.wip_entity_id
771: and WDJ.organization_id = we.organization_id
772: and WDJ.status_type in (3, 6)

Line 812: wsm_lot_based_jobs WLBJ

808: wip_entities WE,
809: wip_operations WO,
810: wip_operation_resources WOR,
811: wip_op_resource_instances WORI,
812: wsm_lot_based_jobs WLBJ
813: where WE.entity_type in (5, 8)
814: and WDJ.wip_entity_id = we.wip_entity_id
815: and WDJ.organization_id = we.organization_id
816: and WDJ.status_type in (3, 6)

Line 897: from wsm_lot_based_jobs

893: select organization_id,
894: current_job_op_seq_num
895: into l_org_id,
896: l_job_op_seq_num
897: from wsm_lot_based_jobs
898: where wip_entity_id = p_wip_entity_id;
899:
900: IF (p_txn_type IN (16,32,64,128,2048,4096)) THEN
901: