APPS.INV_GENEALOGY_REPORT_GEN dependencies on WIP_ENTITIES

Line 260: From wip_entities

256:
257: Cursor get_wip_info is
258: Select wip_entity_id
259: , entity_type
260: From wip_entities
261: Where organization_id = g_organization_id
262: and wip_entity_name= p_wip_entity_name
263: ;
264:

Line 381: ||' From wip_entities'

377: then
378: l_main_query := ' Select gen_object_id object_id'
379: ||' , 5 object_type'
380: ||' , null lot_number'
381: ||' From wip_entities'
382: ||' Where primary_item_id = '||g_inventory_item_id
383: ||' and organization_id = '||g_organization_id
384: ||' and wip_entity_name = '||''''||p_wip_entity_name||''''
385: ;

Line 409: ||' From wip_entities we'

405: then
406: l_main_query := ' Select we.gen_object_id object_id'
407: ||' , 5 object_type'
408: ||' , mln.lot_number lot_number'
409: ||' From wip_entities we'
410: ||' , mtl_lot_numbers mln'
411: ||' Where we.primary_item_id = '||g_inventory_item_id
412: ||' and we.organization_id = '||g_organization_id
413: ||' and we.organization_id = mln.organization_id'

Line 426: ||' , wip_entities we '

422: l_main_query := ' Select we.gen_object_id object_id'
423: ||' , 5 object_type'
424: ||' , lot_number lot_number'
425: ||' From mtl_serial_numbers msn '
426: ||' , wip_entities we '
427: ||' Where msn.serial_number = '||''''|| p_serial_number||''''
428: ||' and we.wip_entity_name = '||''''||p_wip_entity_name||''''
429: --||' and we.wip_entity_id = msn.wip_entity_id '
430: ||' and we.primary_item_id = msn.inventory_item_id '

Line 440: ||' , wip_entities we '

436: l_main_query := ' Select we.gen_object_id object_id'
437: ||' , 5 object_type'
438: ||' , lot_number lot_number'
439: ||' From mtl_serial_numbers msn '
440: ||' , wip_entities we '
441: ||' Where msn.serial_number = '||''''|| p_serial_number||''''
442: ||' and we.wip_entity_name = '||''''||p_wip_entity_name||''''
443: ||' and msn.lot_number = '||''''||p_lot_number||''''
444: ||' and we.primary_item_id = msn.inventory_item_id '

Line 660: FROM wip_entities

656: , entity_type
657: , organization_id
658: , wip_entity_id
659: , primary_item_id
660: FROM wip_entities
661: WHERE gen_object_id = l_object_id
662: ;
663: Cursor get_gme_security Is
664: Select 1

Line 793: FROM wip_entities

789: , l_wip_entity_type
790: , l_current_org_id
791: , l_wip_entity_id
792: , l_inventory_item_id
793: FROM wip_entities
794: WHERE wip_entity_id = l_object_id;
795: */
796: l_work_order_header_rec.object_id := l_object_id;
797: l_work_order_header_rec.work_order_number := l_wip_entity_name;

Line 1112: from wip_entities we

1108: and gen_object_id = p_serial_attributes_rec.object_id;
1109:
1110: cursor get_job_info IS
1111: select we.wip_entity_name
1112: from wip_entities we
1113: where we.wip_entity_id = p_serial_attributes_rec.wip_entity_id
1114: ;
1115:
1116: Cursor get_intraoperation_step IS

Line 3062: From wip_entities wip

3058: x_return_status VARCHAR2(5);
3059:
3060: Cursor get_gme_security Is
3061: Select 1
3062: From wip_entities wip
3063: , gme_batch_header_vw gme
3064: Where wip.gen_object_id = p_object_id
3065: and wip.entity_type in (9, 10)
3066: and wip.wip_entity_id = gme.batch_id;