DBA Data[Home] [Help]

APPS.INV_GENEALOGY_REPORT_GEN dependencies on GME_BATCH_HEADER_VW

Line 661: From gme_batch_header_vw

657: WHERE gen_object_id = l_object_id
658: ;
659: Cursor get_gme_security Is
660: Select 1
661: From gme_batch_header_vw
662: Where batch_id = l_wip_entity_id;
663: Begin
664: -- Sort out object information
665: debug('writing report for object_type '||p_object_type||' object_id '||p_object_id

Line 2420: , gme_batch_header_vw gme

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
2424: ;

Line 2559: , gme_batch_header_vw gme

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
2563: ;

Line 2735: , gme_batch_header_vw gme

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
2739: ;

Line 2858: , gme_batch_header_vw gme

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
2862: ;