[Home] [Help]
252:
253: Cursor get_wip_info is
254: Select wip_entity_id
255: , entity_type
256: From wip_entities
257: Where organization_id = g_organization_id
258: and wip_entity_name= p_wip_entity_name
259: ;
260:
373: then
374: l_main_query := ' Select gen_object_id object_id'
375: ||' , 5 object_type'
376: ||' , null lot_number'
377: ||' From wip_entities'
378: ||' Where primary_item_id = '||g_inventory_item_id
379: ||' and organization_id = '||g_organization_id
380: ||' and wip_entity_name = '||''''||p_wip_entity_name||''''
381: ;
401: then
402: l_main_query := ' Select we.gen_object_id object_id'
403: ||' , 5 object_type'
404: ||' , mln.lot_number lot_number'
405: ||' From wip_entities we'
406: ||' , mtl_lot_numbers mln'
407: ||' Where we.primary_item_id = '||g_inventory_item_id
408: ||' and we.organization_id = '||g_organization_id
409: ||' and we.organization_id = mln.organization_id'
418: l_main_query := ' Select we.gen_object_id object_id'
419: ||' , 5 object_type'
420: ||' , lot_number lot_number'
421: ||' From mtl_serial_numbers msn '
422: ||' , wip_entities we '
423: ||' Where msn.serial_number = '||''''|| p_serial_number||''''
424: ||' and we.wip_entity_name = '||''''||p_wip_entity_name||''''
425: --||' and we.wip_entity_id = msn.wip_entity_id '
426: ||' and we.primary_item_id = msn.inventory_item_id '
432: l_main_query := ' Select we.gen_object_id object_id'
433: ||' , 5 object_type'
434: ||' , lot_number lot_number'
435: ||' From mtl_serial_numbers msn '
436: ||' , wip_entities we '
437: ||' Where msn.serial_number = '||''''|| p_serial_number||''''
438: ||' and we.wip_entity_name = '||''''||p_wip_entity_name||''''
439: ||' and msn.lot_number = '||''''||p_lot_number||''''
440: ||' and we.primary_item_id = msn.inventory_item_id '
652: , entity_type
653: , organization_id
654: , wip_entity_id
655: , primary_item_id
656: FROM wip_entities
657: WHERE gen_object_id = l_object_id
658: ;
659: Cursor get_gme_security Is
660: Select 1
785: , l_wip_entity_type
786: , l_current_org_id
787: , l_wip_entity_id
788: , l_inventory_item_id
789: FROM wip_entities
790: WHERE wip_entity_id = l_object_id;
791: */
792: l_work_order_header_rec.object_id := l_object_id;
793: l_work_order_header_rec.work_order_number := l_wip_entity_name;
1104: and gen_object_id = p_serial_attributes_rec.object_id;
1105:
1106: cursor get_job_info IS
1107: select we.wip_entity_name
1108: from wip_entities we
1109: where we.wip_entity_id = p_serial_attributes_rec.wip_entity_id
1110: ;
1111:
1112: Cursor get_intraoperation_step IS
2415: AND parent_object_id = l_object_id
2416: ;
2417: Cursor get_gme_security IS
2418: Select 1
2419: From wip_entities wip
2420: , gme_batch_header_vw gme
2421: Where wip.gen_object_id = p_object_id
2422: and wip.entity_type in (9, 10)
2423: and wip.wip_entity_id = gme.batch_id
2554: WHERE parent_object_id = l_object_id
2555: ;
2556: Cursor get_gme_security IS
2557: Select 1
2558: From wip_entities wip
2559: , gme_batch_header_vw gme
2560: Where wip.gen_object_id = p_object_id
2561: and wip.entity_type in (9, 10)
2562: and wip.wip_entity_id = gme.batch_id
2730: WHERE object_id = l_parent_object_id
2731: ;
2732: Cursor get_gme_security IS
2733: Select 1
2734: From wip_entities wip
2735: , gme_batch_header_vw gme
2736: Where wip.gen_object_id = l_parent_object_id
2737: and wip.entity_type in (9, 10)
2738: and wip.wip_entity_id = gme.batch_id
2853: l_parent_query rc;
2854:
2855: Cursor get_gme_security IS
2856: Select 1
2857: From wip_entities wip
2858: , gme_batch_header_vw gme
2859: Where wip.gen_object_id = p_object_id
2860: and wip.entity_type in (9, 10)
2861: and wip.wip_entity_id = gme.batch_id