DBA Data[Home] [Help]

APPS.EGO_USER_ATTRS_BULK_PVT dependencies on FND_OBJECTS

Line 1527: FROM FND_OBJECTS

1523: -- Fetching the object_id --
1524: ----------------------------------
1525: SELECT OBJECT_ID
1526: INTO l_object_id
1527: FROM FND_OBJECTS
1528: WHERE OBJ_NAME = p_object_name;
1529:
1530: -----------------------------------------
1531: -- Fetch the PK column names and data --

Line 1544: FROM FND_OBJECTS

1540: l_pk2_column_name, l_pk2_column_type,
1541: l_pk3_column_name, l_pk3_column_type,
1542: l_pk4_column_name, l_pk4_column_type,
1543: l_pk5_column_name, l_pk5_column_type
1544: FROM FND_OBJECTS
1545: WHERE OBJ_NAME = p_object_name;
1546:
1547: --------------------------------------
1548: -- Fetching the class code col name --

Line 1552: FROM EGO_FND_OBJECTS_EXT

1548: -- Fetching the class code col name --
1549: --------------------------------------
1550: SELECT CLASSIFICATION_COL_NAME, CLASSIFICATION_COL_TYPE
1551: INTO l_class_code_column_name, l_class_code_column_type
1552: FROM EGO_FND_OBJECTS_EXT
1553: WHERE OBJECT_NAME = p_object_name;
1554:
1555: ----------------------------------------------------------
1556: -- Get the B, TL, and VL names for this Attr Group Type --

Line 7326: FROM FND_OBJECTS

7322: l_pk2_column_name,
7323: l_pk3_column_name,
7324: l_pk4_column_name,
7325: l_pk5_column_name
7326: FROM FND_OBJECTS
7327: WHERE OBJ_NAME = p_object_name;
7328:
7329: ----------------------------------------------------------------------------
7330: -- CONSTRUCTING THE PK, DL AND THE CLASS CODE COLUMN SELECT LIST. --

Line 7376: FROM ego_fnd_objects_ext

7372: code_debug(l_api_name||' l_ext_templrtcq_pk_join: '||l_ext_templrtcq_pk_join);
7373:
7374: SELECT classification_col_name, classification_col_type
7375: INTO l_class_code_column_name, l_class_code_column_type
7376: FROM ego_fnd_objects_ext
7377: WHERE object_name = p_object_name;
7378: code_debug(l_api_name||' l_class_code_column_name: ' ||l_class_code_column_name);
7379:
7380: -- adding the class code column

Line 8354: FROM FND_OBJECTS

8350: l_pk2_column_name, l_pk2_column_type,
8351: l_pk3_column_name, l_pk3_column_type,
8352: l_pk4_column_name, l_pk4_column_type,
8353: l_pk5_column_name, l_pk5_column_type
8354: FROM FND_OBJECTS
8355: WHERE OBJ_NAME = p_object_name;
8356:
8357: SELECT application_table_name
8358: INTO l_ext_b_table_name

Line 8380: FROM EGO_FND_OBJECTS_EXT

8376: ------------------------------------------------------------
8377:
8378: SELECT CLASSIFICATION_COL_NAME
8379: INTO l_class_code_column_name
8380: FROM EGO_FND_OBJECTS_EXT
8381: WHERE OBJECT_NAME = p_object_name;
8382:
8383: ----------------------------------------------------------
8384: -- Building the SQL --

Line 8898: FROM FND_OBJECTS

8894: l_pk2_column_name,
8895: l_pk3_column_name,
8896: l_pk4_column_name,
8897: l_pk5_column_name
8898: FROM FND_OBJECTS
8899: WHERE OBJ_NAME = p_object_name;
8900:
8901: --------------------------------------------
8902: -- Fetching the ext table/vl name --