DBA Data[Home] [Help]

APPS.EGO_USER_ATTRS_BULK_PVT dependencies on FND_OBJECTS

Line 1842: FROM FND_OBJECTS

1838: -- Fetching the object_id --
1839: ----------------------------------
1840: SELECT OBJECT_ID
1841: INTO l_object_id
1842: FROM FND_OBJECTS
1843: WHERE OBJ_NAME = p_object_name;
1844:
1845: -----------------------------------------
1846: -- Fetch the PK column names and data --

Line 1859: FROM FND_OBJECTS

1855: l_pk2_column_name, l_pk2_column_type,
1856: l_pk3_column_name, l_pk3_column_type,
1857: l_pk4_column_name, l_pk4_column_type,
1858: l_pk5_column_name, l_pk5_column_type
1859: FROM FND_OBJECTS
1860: WHERE OBJ_NAME = p_object_name;
1861:
1862: --------------------------------------
1863: -- Fetching the class code col name --

Line 1867: FROM EGO_FND_OBJECTS_EXT

1863: -- Fetching the class code col name --
1864: --------------------------------------
1865: SELECT CLASSIFICATION_COL_NAME, CLASSIFICATION_COL_TYPE
1866: INTO l_class_code_column_name, l_class_code_column_type
1867: FROM EGO_FND_OBJECTS_EXT
1868: WHERE OBJECT_NAME = p_object_name;
1869:
1870: ----------------------------------------------------------
1871: -- Get the B, TL, and VL names for this Attr Group Type --

Line 8984: FROM FND_OBJECTS

8980: l_pk2_column_name,
8981: l_pk3_column_name,
8982: l_pk4_column_name,
8983: l_pk5_column_name
8984: FROM FND_OBJECTS
8985: WHERE OBJ_NAME = p_object_name;
8986:
8987: ----------------------------------------------------------------------------
8988: -- CONSTRUCTING THE PK, DL AND THE CLASS CODE COLUMN SELECT LIST. --

Line 9034: FROM ego_fnd_objects_ext

9030: -- code_debug(l_api_name||' l_ext_templrtcq_pk_join: '||l_ext_templrtcq_pk_join); -- Bug 13414358
9031:
9032: SELECT classification_col_name, classification_col_type
9033: INTO l_class_code_column_name, l_class_code_column_type
9034: FROM ego_fnd_objects_ext
9035: WHERE object_name = p_object_name;
9036: code_debug(l_api_name||' l_class_code_column_name: ' ||l_class_code_column_name);
9037:
9038: -- adding the class code column

Line 10091: FROM FND_OBJECTS

10087: l_pk2_column_name, l_pk2_column_type,
10088: l_pk3_column_name, l_pk3_column_type,
10089: l_pk4_column_name, l_pk4_column_type,
10090: l_pk5_column_name, l_pk5_column_type
10091: FROM FND_OBJECTS
10092: WHERE OBJ_NAME = p_object_name;
10093:
10094: SELECT application_table_name
10095: INTO l_ext_b_table_name

Line 10117: FROM EGO_FND_OBJECTS_EXT

10113: ------------------------------------------------------------
10114:
10115: SELECT CLASSIFICATION_COL_NAME
10116: INTO l_class_code_column_name
10117: FROM EGO_FND_OBJECTS_EXT
10118: WHERE OBJECT_NAME = p_object_name;
10119:
10120: ----------------------------------------------------------
10121: -- Building the SQL --

Line 10675: FROM FND_OBJECTS

10671: l_pk2_column_name,
10672: l_pk3_column_name,
10673: l_pk4_column_name,
10674: l_pk5_column_name
10675: FROM FND_OBJECTS
10676: WHERE OBJ_NAME = p_object_name;
10677:
10678: --------------------------------------------
10679: -- Fetching the ext table/vl name --