APPS.PO_MULTI_MOD_PVT dependencies on EGO_ATTR_GROUPS_V

Line 88: ego_attr_groups_v v_ag

84: OR (change_type = 'VENDOR_REMIT_ADDRESS'
85: AND (org_id,old_remit_to_addr) NOT IN
86: (SELECT DISTINCT rmt_ofc.n_ext_attr3 org_id, rmt_ofc.n_ext_attr2 remit_to_office
87: FROM po_headers_all_ext_b rmt_ofc,
88: ego_attr_groups_v v_ag
89: WHERE v_ag.attr_group_type = 'PO_HEADER_EXT_ATTRS'
90: AND v_ag.attr_group_name = 'SUPPLIER_DTLS'
91: AND v_ag.attr_group_id = rmt_ofc.attr_group_id
92: AND rmt_ofc.draft_id = -1

Line 484: ego_attr_groups_v ags

480: SELECT distinct ags.ATTR_GROUP_NAME
481: INTO l_doc_num_ag_name
482: FROM po_headers_all_ext_b phaeb,
483: po_uda_ag_template_usages usages,
484: ego_attr_groups_v ags
485: WHERE phaeb.po_header_id = p_po_header_id
486: AND phaeb.draft_id = -1
487: AND phaeb.attr_group_id = ags.attr_group_id
488: AND phaeb.attr_group_id = usages.attribute_group_id

Line 807: FROM ego_attr_groups_v

803:
804: -- Get the attribute Group Id against addresses Attr Grp
805: SELECT attr_group_id
806: INTO l_addr_attr_group_id
807: FROM ego_attr_groups_v
808: WHERE attr_group_type = l_addr_attr_grp_type
809: AND attr_group_name = l_addr_attr_grp_name;
810:
811: d_position := 20;

Line 1808: FROM ego_attr_groups_v

1804:
1805: -- Get the attribute Group Id against Supplier Attr Grp
1806: SELECT attr_group_id
1807: INTO l_sup_attr_group_id
1808: FROM ego_attr_groups_v
1809: WHERE attr_group_type = l_entity_code
1810: AND attr_group_name = l_supplier_attr_grp;
1811:
1812: d_position := 10;

Line 2731: FROM ego_attr_groups_v

2727: l_entity_pk4 := PO_TBL_VARCHAR240(null);
2728:
2729: SELECT attr_group_id
2730: INTO l_addr_attr_group_id
2731: FROM ego_attr_groups_v
2732: WHERE attr_group_type = 'PO_HEADER_EXT_ATTRS'
2733: AND attr_group_name = 'addresses';
2734:
2735: SELECT ext.c_ext_attr39,