APPS.PO_UDA_AUTOCREATE_PKG dependencies on EGO_ATTR_GROUPS_V

Line 206: FROM po_uda_ag_template_usages tu, ego_attr_groups_v ag

202: l_progress := '010';
203:
204: SELECT DISTINCT ag.attr_group_name
205: BULK COLLECT INTO x_attr_group_tbl
206: FROM po_uda_ag_template_usages tu, ego_attr_groups_v ag
207: WHERE ag.attr_group_id = tu.attribute_group_id
208: AND tu.template_id = p_uda_template_id
209: AND tu.attribute_category NOT IN ('PRICING','DOCUMENT_NUMBERING'); --12611018 Document numbering added
210:

Line 1120: FROM EGO_ATTR_GROUPS_V

1116: l_progress := '010';
1117:
1118: SELECT attr_group_id
1119: INTO l_attr_group_id
1120: FROM EGO_ATTR_GROUPS_V
1121: WHERE ATTR_GROUP_TYPE = p_ag_type
1122: AND ATTR_GROUP_NAME = p_attr_grp;
1123:
1124: IF g_debug_stmt THEN

Line 1899: ,ego_attr_groups_v ag

1895: l_progress := '060';
1896: SELECT ag.attr_group_name
1897: BULK COLLECT INTO l_attr_group_tbl
1898: FROM pon_bid_item_prices_ext_b bid
1899: ,ego_attr_groups_v ag
1900: ,po_uda_ag_template_usages tu
1901: WHERE bid.bid_number = l_src_rec.bid_number
1902: AND bid.line_number = l_src_rec.bid_line_number
1903: AND bid.attr_group_id = ag.attr_group_id

Line 1948: ,ego_attr_groups_v ag

1944: l_progress := '100';
1945: SELECT ag.attr_group_name
1946: BULK COLLECT INTO l_attr_group_tbl
1947: FROM po_req_lines_ext_b req
1948: ,ego_attr_groups_v ag
1949: ,po_uda_ag_template_usages tu
1950: WHERE req.requisition_line_id = l_src_rec.requisition_line_id
1951: AND req.attr_group_id = ag.attr_group_id
1952: AND ag.attr_group_id = tu.attribute_group_id

Line 2952: FROM EGO_ATTR_GROUPS_V

2948:
2949: l_progress := '080';
2950: SELECT ATTR_GROUP_NAME
2951: INTO l_attr_group_name
2952: FROM EGO_ATTR_GROUPS_V
2953: WHERE ATTR_GROUP_TYPE = l_entity_code
2954: AND attr_group_id = p_attr_group_id_tbl(i);
2955:
2956: IF g_debug_stmt THEN