eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.EGO_AG_BULKLOAD_PVT dependencies on FND_DESCR_FLEX_COLUMN_USAGES

Line 1920: FROM FND_DESCR_FLEX_COLUMN_USAGES

1916: Nvl(program_id,G_PROGRAM_ID),
1917: Nvl(program_update_date,SYSDATE)
1918: FROM ego_attr_group_cols_intf eagi
1919: WHERE EXISTS (SELECT 1
1920: FROM FND_DESCR_FLEX_COLUMN_USAGES
1921: WHERE APPLICATION_ID = G_EGO_APPLICATION_ID
1922: AND DESCRIPTIVE_FLEXFIELD_NAME = G_EGO_ITEMMGMT_GROUP
1923: AND DESCRIPTIVE_FLEX_CONTEXT_Code = eagi.attr_group_name
1924: AND END_USER_COLUMN_NAME = eagi.internal_name

Line 1938: FROM FND_DESCR_FLEX_COLUMN_USAGES

1934: last_updated_by = G_USER_ID,
1935: last_update_date = SYSDATE,
1936: last_update_login = G_LOGIN_ID
1937: WHERE EXISTS (SELECT 1
1938: FROM FND_DESCR_FLEX_COLUMN_USAGES
1939: WHERE APPLICATION_ID = G_EGO_APPLICATION_ID
1940: AND DESCRIPTIVE_FLEXFIELD_NAME = G_EGO_ITEMMGMT_GROUP
1941: AND DESCRIPTIVE_FLEX_CONTEXT_Code = eagi.attr_group_name
1942: AND END_USER_COLUMN_NAME = eagi.internal_name

Line 2583: FROM fnd_descr_flex_column_usages fdfcu,

2579:
2580: /*Sets the Attr_id for the update and sync flow*/
2581: UPDATE ego_attr_group_cols_intf eagci
2582: SET eagci.attr_id = (SELECT efdcue.attr_id
2583: FROM fnd_descr_flex_column_usages fdfcu,
2584: ego_fnd_df_col_usgs_ext efdcue
2585: WHERE fdfcu.application_id = efdcue.application_id
2586: AND fdfcu.descriptive_flexfield_name = efdcue.descriptive_flexfield_name
2587: AND fdfcu.descriptive_flex_context_code = efdcue.descriptive_flex_context_code

Line 2894: FROM fnd_descr_flex_column_usages fdfcu,

2890:
2891: /*Sets the Internal Attribute name when then Attr id is given*/
2892: UPDATE ego_attr_group_cols_intf eagci
2893: SET eagci.internal_name = (SELECT fdfcu.end_user_column_name
2894: FROM fnd_descr_flex_column_usages fdfcu,
2895: ego_fnd_df_col_usgs_ext efdcue
2896: WHERE fdfcu.application_id = efdcue.application_id
2897: AND fdfcu.descriptive_flexfield_name = efdcue.descriptive_flexfield_name
2898: AND fdfcu.descriptive_flex_context_code = efdcue.descriptive_flex_context_code

Line 4207: FROM fnd_descr_flex_column_usages fdfcu,

4203: OR P_attr_tbl(i).transaction_type = G_OPR_SYNC)) THEN
4204: BEGIN
4205: SELECT efdcue.attr_id
4206: INTO P_attr_tbl(i).attr_id
4207: FROM fnd_descr_flex_column_usages fdfcu,
4208: ego_fnd_df_col_usgs_ext efdcue
4209: WHERE fdfcu.application_id = efdcue.application_id
4210: AND fdfcu.descriptive_flexfield_name = efdcue.descriptive_flexfield_name
4211: AND fdfcu.descriptive_flex_context_code = efdcue.descriptive_flex_context_code

Line 4769: FROM FND_DESCR_FLEX_COLUMN_USAGES

4765: /*Checks for existing sequence number - CREATE flow*/ --Added for 9625957
4766: IF (p_attr_tbl(i).sequence IS NOT NULL AND p_attr_tbl(i).transaction_type = G_OPR_CREATE) THEN
4767: BEGIN
4768: SELECT 'Y' INTO lv_flag
4769: FROM FND_DESCR_FLEX_COLUMN_USAGES
4770: WHERE APPLICATION_ID = G_EGO_APPLICATION_ID
4771: AND DESCRIPTIVE_FLEXFIELD_NAME = p_attr_tbl(i).attr_group_type
4772: AND DESCRIPTIVE_FLEX_CONTEXT_Code = p_attr_tbl(i).attr_group_name
4773: AND COLUMN_SEQ_NUM = p_attr_tbl(i).sequence;

Line 4814: FROM FND_DESCR_FLEX_COLUMN_USAGES

4810: l_sequence NUMBER;
4811: BEGIN
4812: SELECT COLUMN_SEQ_NUM
4813: INTO l_sequence
4814: FROM FND_DESCR_FLEX_COLUMN_USAGES
4815: WHERE APPLICATION_ID = G_EGO_APPLICATION_ID
4816: AND DESCRIPTIVE_FLEXFIELD_NAME = p_attr_tbl(i).attr_group_type
4817: AND DESCRIPTIVE_FLEX_CONTEXT_Code = p_attr_tbl(i).attr_group_name
4818: AND END_USER_COLUMN_NAME = p_attr_tbl(i).internal_name;

Line 4826: FROM FND_DESCR_FLEX_COLUMN_USAGES

4822: -- check for uniqueness
4823:
4824: SELECT COUNT(*)
4825: INTO l_sequence
4826: FROM FND_DESCR_FLEX_COLUMN_USAGES
4827: WHERE APPLICATION_ID = G_EGO_APPLICATION_ID
4828: AND DESCRIPTIVE_FLEXFIELD_NAME = p_attr_tbl(i).attr_group_type
4829: AND DESCRIPTIVE_FLEX_CONTEXT_Code = p_attr_tbl(i).attr_group_name
4830: AND COLUMN_SEQ_NUM = p_attr_tbl(i).sequence;

Line 4866: FROM FND_DESCR_FLEX_COLUMN_USAGES

4862: /*Checks for existing column name - CREATE flow*/ --Added for 9625957
4863: IF (p_attr_tbl(i).application_column_name IS NOT NULL AND p_attr_tbl(i).transaction_type = G_OPR_CREATE) THEN
4864: BEGIN
4865: SELECT 'Y' INTO lv_flag
4866: FROM FND_DESCR_FLEX_COLUMN_USAGES
4867: WHERE APPLICATION_ID = G_EGO_APPLICATION_ID
4868: AND DESCRIPTIVE_FLEXFIELD_NAME = p_attr_tbl(i).attr_group_type
4869: AND DESCRIPTIVE_FLEX_CONTEXT_Code = p_attr_tbl(i).attr_group_name
4870: AND application_column_name = p_attr_tbl(i).application_column_name;

Line 4912: FROM FND_DESCR_FLEX_COLUMN_USAGES

4908: lv_count NUMBER;
4909: BEGIN
4910: SELECT application_column_name
4911: INTO lv_column
4912: FROM FND_DESCR_FLEX_COLUMN_USAGES
4913: WHERE APPLICATION_ID = G_EGO_APPLICATION_ID
4914: AND DESCRIPTIVE_FLEXFIELD_NAME = p_attr_tbl(i).attr_group_type
4915: AND DESCRIPTIVE_FLEX_CONTEXT_Code = p_attr_tbl(i).attr_group_name
4916: AND END_USER_COLUMN_NAME = p_attr_tbl(i).internal_name;

Line 4924: FROM FND_DESCR_FLEX_COLUMN_USAGES

4920: -- check for uniqueness
4921:
4922: SELECT COUNT(*)
4923: INTO lv_count
4924: FROM FND_DESCR_FLEX_COLUMN_USAGES
4925: WHERE APPLICATION_ID = G_EGO_APPLICATION_ID
4926: AND DESCRIPTIVE_FLEXFIELD_NAME = p_attr_tbl(i).attr_group_type
4927: AND DESCRIPTIVE_FLEX_CONTEXT_Code = p_attr_tbl(i).attr_group_name
4928: AND application_column_name = p_attr_tbl(i).application_column_name;

Line 6012: FROM fnd_descr_flex_column_usages fdfcu,

6008: AND P_attr_tbl(i).internal_name IS NULL) THEN
6009: BEGIN
6010: SELECT fdfcu.end_user_column_name
6011: INTO P_attr_tbl(i).internal_name
6012: FROM fnd_descr_flex_column_usages fdfcu,
6013: ego_fnd_df_col_usgs_ext efdcue
6014: WHERE fdfcu.application_id = efdcue.application_id
6015: AND fdfcu.descriptive_flexfield_name = efdcue.descriptive_flexfield_name
6016: AND fdfcu.descriptive_flex_context_code = efdcue.descriptive_flex_context_code

Line 6526: FROM FND_DESCR_FLEX_COLUMN_USAGES

6522: IF (p_attr_tbl(i).process_status = G_PROCESS_RECORD
6523: AND p_attr_tbl(i).transaction_type = G_OPR_UPDATE) THEN
6524: BEGIN
6525: SELECT FLEX_VALUE_SET_ID,DEFAULT_VALUE INTO lv_value_set_id, lv_default_value
6526: FROM FND_DESCR_FLEX_COLUMN_USAGES
6527: WHERE APPLICATION_ID = G_EGO_APPLICATION_ID
6528: AND DESCRIPTIVE_FLEXFIELD_NAME = p_attr_tbl(i).attr_group_type
6529: AND DESCRIPTIVE_FLEX_CONTEXT_CODE = p_attr_tbl(i).attr_group_name
6530: AND APPLICATION_COLUMN_NAME = p_attr_tbl(i).application_column_name;