DBA Data[Home] [Help]

APPS.PO_UDA_TEMPLATES_UTIL dependencies on EGO_FND_DESC_FLEXS_EXT

Line 1159: FROM EGO_OBJECT_EXT_TABLES_B eb, fnd_objects fo, EGO_FND_DESC_FLEXS_EXT et, po_uda_ag_templates pt

1155: c_document_exists ref_cursor;
1156:
1157: CURSOR c_prod_table(p_template_id NUMBER) IS
1158: SELECT fo.DATABASE_OBJECT_NAME
1159: FROM EGO_OBJECT_EXT_TABLES_B eb, fnd_objects fo, EGO_FND_DESC_FLEXS_EXT et, po_uda_ag_templates pt
1160: WHERE eb.OBJECT_ID = fo.object_id
1161: AND eb.EXT_TABLE_NAME = et.APPLICATION_TL_TABLE_NAME
1162: AND et.DESCRIPTIVE_FLEXFIELD_NAME = pt.entity_code
1163: AND pt.template_id = p_template_id;

Line 3607: FROM po_uda_ag_templates pt, EGO_FND_DESC_FLEXS_EXT et

3603: j NUMBER ;
3604:
3605: CURSOR c_table_name(p_template_id NUMBER) IS
3606: SELECT pt.entity_code, et.APPLICATION_VL_NAME, et.APPLICATION_TL_TABLE_NAME
3607: FROM po_uda_ag_templates pt, EGO_FND_DESC_FLEXS_EXT et
3608: WHERE pt.template_id = p_template_id
3609: AND et.DESCRIPTIVE_FLEXFIELD_NAME = pt.entity_code;
3610:
3611: CURSOR c_attr_group_ids(p_template_id NUMBER) IS

Line 3783: FROM EGO_FND_DESC_FLEXS_EXT et

3779: j NUMBER ;
3780:
3781: CURSOR c_table_name(p_entity_code VARCHAR2) IS
3782: SELECT et.APPLICATION_VL_NAME, et.APPLICATION_TL_TABLE_NAME
3783: FROM EGO_FND_DESC_FLEXS_EXT et
3784: WHERE et.DESCRIPTIVE_FLEXFIELD_NAME = p_entity_code;
3785:
3786: CURSOR c_attr_group_ids(p_entity_code VARCHAR2) IS
3787: SELECT DISTINCT(u.attribute_group_id)