DBA Data[Home] [Help]

APPS.PO_AUTOCREATE_MAINPROC_PVT dependencies on EGO_ATTR_GROUPS_V

Line 2726: ego_attr_groups_v ag ,

2722:
2723: SELECT DISTINCT ag.attr_group_name BULK COLLECT
2724: INTO l_attr_group_tbl
2725: FROM po_lines_all_ext_b ple ,
2726: ego_attr_groups_v ag ,
2727: po_uda_ag_template_usages tu
2728: WHERE ple.po_line_id = p_po_line_id_tbl(i)
2729: AND ple.attr_group_id = ag.attr_group_id
2730: AND ag.attr_group_id = tu.attribute_group_id

Line 2850: ego_attr_groups_v ag ,

2846:
2847: SELECT DISTINCT ag.attr_group_name BULK COLLECT
2848: INTO x_attr_group_tbl
2849: FROM po_lines_all_ext_b ple ,
2850: ego_attr_groups_v ag ,
2851: po_uda_ag_template_usages tu
2852: WHERE ple.po_line_id = p_po_line_id_tbl(i)
2853: AND ple.attr_group_id = ag.attr_group_id
2854: AND ag.attr_group_id = tu.attribute_group_id

Line 2901: ego_attr_groups_v ag ,

2897:
2898: SELECT DISTINCT ag.attr_group_name BULK COLLECT
2899: INTO x_attr_group_tbl
2900: FROM po_line_locations_all_ext_b plle ,
2901: ego_attr_groups_v ag ,
2902: po_uda_ag_template_usages tu
2903: WHERE plle.line_location_id = p_line_location_id_tbl(i)
2904: AND plle.attr_group_id = ag.attr_group_id
2905: AND ag.attr_group_id = tu.attribute_group_id