DBA Data[Home] [Help]

APPS.PO_UDA_TEMPLATES_UTIL dependencies on EGO_OBJECT_EXT_TABLES_B

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 3629: FROM EGO_OBJECT_EXT_TABLES_B eb, fnd_objects fo

3625: AND efdcue.DESCRIPTIVE_FLEXFIELD_NAME = p_entity_code;
3626:
3627: CURSOR c_actual_table_name(l_prod_ext_tl_table VARCHAR2) IS
3628: SELECT fo.DATABASE_OBJECT_NAME, fo.PK1_COLUMN_NAME
3629: FROM EGO_OBJECT_EXT_TABLES_B eb, fnd_objects fo
3630: WHERE eb.OBJECT_ID = fo.object_id
3631: AND eb.EXT_TABLE_NAME = l_prod_ext_tl_table;
3632:
3633: BEGIN

Line 3802: FROM EGO_OBJECT_EXT_TABLES_B eb, fnd_objects fo

3798: AND efdcue.DESCRIPTIVE_FLEXFIELD_NAME <> 'PO_UDA_DUMMY_EXT_ATTRS';
3799:
3800: CURSOR c_actual_table_name(l_prod_ext_tl_table VARCHAR2) IS
3801: SELECT fo.DATABASE_OBJECT_NAME, fo.PK1_COLUMN_NAME
3802: FROM EGO_OBJECT_EXT_TABLES_B eb, fnd_objects fo
3803: WHERE eb.OBJECT_ID = fo.object_id
3804: AND eb.EXT_TABLE_NAME = l_prod_ext_tl_table;
3805:
3806: