DBA Data[Home] [Help]

APPS.PO_UDA_TEMPLATES_UTIL dependencies on FND_OBJECTS

Line 315: FROM FND_OBJECTS

311: d_progress := 335;
312:
313: SELECT OBJECT_ID
314: INTO l_object_id
315: FROM FND_OBJECTS
316: WHERE OBJ_NAME = PO_UDA_DATA_UTIL.g_object_dff_tl(l_entity_type).l_object_name;
317:
318: d_progress := 340;
319:

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:

Line 5738: FROM fnd_objects

5734:
5735: --Get the dummy object id
5736: SELECT object_id
5737: INTO l_dummy_object_id
5738: FROM fnd_objects
5739: WHERE obj_name = 'PO_UDA_DUMMY_ALL';
5740:
5741: --Get the dummy data level id
5742: SELECT data_level_name