DBA Data[Home] [Help]

APPS.PO_DATATEMPLATE_PKG dependencies on EGO_ATTRS_V

Line 835: from ego_attrs_v eav, ego_attr_groups_v eag

831: l_draftId number;
832: Begin
833:
834: Select eag.attr_group_id, eav.database_column INTO l_attr_grp_id, l_col_name
835: from ego_attrs_v eav, ego_attr_groups_v eag
836: where eav.attr_group_name = 'SHIP_INFO' and eav.attr_group_type = 'PO_SHIPMENTS_EXT_ATTRS'
837: AND eav.ATTR_NAME = 'FOB' and eag.attr_group_name = 'SHIP_INFO' and
838: eag.attr_group_type = 'PO_SHIPMENTS_EXT_ATTRS';
839:

Line 1140: ego_attrs_v val

1136: SELECT val.attr_name,
1137: val.database_column
1138: FROM po_uda_ag_template_usages t1,
1139: ego_attr_groups_v gr,
1140: ego_attrs_v val
1141: WHERE t1.template_id = p_template_id
1142: AND t1.attribute_category = 'CLOSEOUT'
1143: AND t1.attribute_group_id = gr.attr_group_id
1144: AND gr.attr_group_id = p_attr_group_id