2585: SELECT distinct pudat.attribute_group_id
2586: BULK COLLECT INTO x_attr_group_id_tbl
2587: FROM po_headers_draft_all poh,
2588: po_uda_ag_template_usages pudat,
2589: EGO_ACTION_DISPLAYS_B ead,
2590: EGO_ACTIONS_B ea
2591: WHERE ea.action_id = ead.action_id
2592: AND ea.attr_group_id = pudat.attribute_group_id
2593: AND ea.classification_code = To_Char(pudat.template_id )
2601: SELECT distinct pudat.attribute_group_id
2602: BULK COLLECT INTO x_attr_group_id_tbl
2603: FROM po_headers_draft_all poh,
2604: po_uda_ag_template_usages pudat,
2605: EGO_ACTION_DISPLAYS_B ead,
2606: EGO_ACTIONS_B ea
2607: WHERE ea.action_id = ead.action_id
2608: AND ea.attr_group_id = pudat.attribute_group_id
2609: AND ea.classification_code = To_Char(pudat.template_id )
2620: SELECT distinct pudat.attribute_group_id
2621: BULK COLLECT INTO x_attr_group_id_tbl
2622: FROM po_headers_draft_all poh,
2623: po_uda_ag_template_usages pudat,
2624: EGO_ACTION_DISPLAYS_B ead,
2625: EGO_ACTIONS_B ea
2626: WHERE ea.action_id = ead.action_id
2627: AND ea.attr_group_id = pudat.attribute_group_id
2628: AND ea.classification_code = To_Char(pudat.template_id )
2640: SELECT distinct pudat.attribute_group_id
2641: BULK COLLECT INTO x_attr_group_id_tbl
2642: FROM po_headers_all poh,
2643: po_uda_ag_template_usages pudat,
2644: EGO_ACTION_DISPLAYS_B ead,
2645: EGO_ACTIONS_B ea
2646: WHERE ea.action_id = ead.action_id
2647: AND ea.attr_group_id = pudat.attribute_group_id
2648: AND ea.classification_code = To_Char(pudat.template_id )
2656: SELECT distinct pudat.attribute_group_id
2657: BULK COLLECT INTO x_attr_group_id_tbl
2658: FROM po_headers_all poh,
2659: po_uda_ag_template_usages pudat,
2660: EGO_ACTION_DISPLAYS_B ead,
2661: EGO_ACTIONS_B ea
2662: WHERE ea.action_id = ead.action_id
2663: AND ea.attr_group_id = pudat.attribute_group_id
2664: AND ea.classification_code = To_Char(pudat.template_id )
2675: SELECT distinct pudat.attribute_group_id
2676: BULK COLLECT INTO x_attr_group_id_tbl
2677: FROM po_headers_all poh,
2678: po_uda_ag_template_usages pudat,
2679: EGO_ACTION_DISPLAYS_B ead,
2680: EGO_ACTIONS_B ea
2681: WHERE ea.action_id = ead.action_id
2682: AND ea.attr_group_id = pudat.attribute_group_id
2683: AND ea.classification_code = To_Char(pudat.template_id )