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_VS_BULKLOAD_PVT dependencies on FND_FLEX_VALUES

Line 249: fnd_flex_values val

245: IS
246:
247: SELECT val.flex_value_id value_id
248: FROM fnd_flex_value_sets vs,
249: fnd_flex_values val
250: WHERE vs.flex_value_set_id = val.flex_value_set_id
251: AND vs.flex_value_set_id = cp_value_set_id
252: AND val.flex_value = cp_flex_value;
253:

Line 328: FROM fnd_flex_values

324: CURSOR cur_value_name( cp_flex_value_set_id NUMBER,
325: cp_flex_value_id NUMBER )
326: IS
327: SELECT flex_value
328: FROM fnd_flex_values
329: WHERE flex_value_set_id= cp_flex_value_set_id
330: AND flex_value_id = cp_flex_value_id;
331:
332:

Line 1458: fnd_flex_values FVSV

1454: AND NOT EXISTS --evsvi.flex_value NOT IN
1455: (
1456: SELECT flex_value
1457: FROM fnd_flex_value_sets FVS,
1458: fnd_flex_values FVSV
1459: --Ego_Flex_Value_Set_Intf EVS
1460: WHERE fvs.flex_value_set_id= fvsv.flex_value_set_id
1461: AND fvs.flex_value_set_name = evsvi.value_set_name
1462: --AND evs.value_set_name = evsv.value_set_name

Line 1482: fnd_flex_values FVSV

1478: AND EVSV.flex_value IN
1479: (
1480: SELECT FVSV.flex_value
1481: FROM fnd_flex_value_sets FVS,
1482: fnd_flex_values FVSV
1483: --Ego_Flex_Value_Set_Intf EVS
1484: WHERE fvs.flex_value_set_id= fvsv.flex_value_set_id
1485: AND fvs.flex_value_set_name = evsv.value_set_name
1486: --AND evs.value_set_name = evsv.value_set_name

Line 1508: fnd_flex_values FVSV,

1504: AND flex_value NOT IN
1505: (
1506: SELECT fvsv.flex_value
1507: FROM fnd_flex_value_sets FVS,
1508: fnd_flex_values FVSV,
1509: fnd_flex_values_tl FVSTV,
1510: Ego_Flex_Value_Set_Intf EVS,
1511: Ego_Flex_Value_Intf EVSV
1512: WHERE fvs.flex_value_set_id= fvsv.flex_value_set_id

Line 1509: fnd_flex_values_tl FVSTV,

1505: (
1506: SELECT fvsv.flex_value
1507: FROM fnd_flex_value_sets FVS,
1508: fnd_flex_values FVSV,
1509: fnd_flex_values_tl FVSTV,
1510: Ego_Flex_Value_Set_Intf EVS,
1511: Ego_Flex_Value_Intf EVSV
1512: WHERE fvs.flex_value_set_id= fvsv.flex_value_set_id
1513: AND fvsv.flex_value_id= fvstv.flex_value_id

Line 1537: fnd_flex_values FVSV,

1533: AND EVSTV.flex_value IN
1534: (
1535: SELECT fvsv.flex_value
1536: FROM fnd_flex_value_sets FVS,
1537: fnd_flex_values FVSV,
1538: fnd_flex_values_tl FVSTV,
1539: Ego_Flex_Value_Set_Intf EVS
1540: WHERE fvs.flex_value_set_id= fvsv.flex_value_set_id
1541: AND fvsv.flex_value_id= fvstv.flex_value_id

Line 1538: fnd_flex_values_tl FVSTV,

1534: (
1535: SELECT fvsv.flex_value
1536: FROM fnd_flex_value_sets FVS,
1537: fnd_flex_values FVSV,
1538: fnd_flex_values_tl FVSTV,
1539: Ego_Flex_Value_Set_Intf EVS
1540: WHERE fvs.flex_value_set_id= fvsv.flex_value_set_id
1541: AND fvsv.flex_value_id= fvstv.flex_value_id
1542: AND fvs.flex_value_set_name = evs.value_set_name

Line 2784: FROM FND_FLEX_VALUES ,FND_FLEX_VALUES_TL

2780:
2781: CURSOR Cur_Value
2782: IS
2783: SELECT FLEX_VALUE_MEANING,DESCRIPTION, START_DATE_ACTIVE,END_DATE_ACTIVE, ENABLED_FLAG
2784: FROM FND_FLEX_VALUES ,FND_FLEX_VALUES_TL
2785: WHERE FND_FLEX_VALUES.flex_value_set_id = p_value_set_id
2786: AND FND_FLEX_VALUES.FLEX_VALUE_ID = p_value_id
2787: AND FND_FLEX_VALUES.FLEX_VALUE_ID = FND_FLEX_VALUES_TL.FLEX_VALUE_ID
2788: AND LANGUAGE = userenv('LANG')

Line 2785: WHERE FND_FLEX_VALUES.flex_value_set_id = p_value_set_id

2781: CURSOR Cur_Value
2782: IS
2783: SELECT FLEX_VALUE_MEANING,DESCRIPTION, START_DATE_ACTIVE,END_DATE_ACTIVE, ENABLED_FLAG
2784: FROM FND_FLEX_VALUES ,FND_FLEX_VALUES_TL
2785: WHERE FND_FLEX_VALUES.flex_value_set_id = p_value_set_id
2786: AND FND_FLEX_VALUES.FLEX_VALUE_ID = p_value_id
2787: AND FND_FLEX_VALUES.FLEX_VALUE_ID = FND_FLEX_VALUES_TL.FLEX_VALUE_ID
2788: AND LANGUAGE = userenv('LANG')
2789: AND ROWNUM=1;

Line 2786: AND FND_FLEX_VALUES.FLEX_VALUE_ID = p_value_id

2782: IS
2783: SELECT FLEX_VALUE_MEANING,DESCRIPTION, START_DATE_ACTIVE,END_DATE_ACTIVE, ENABLED_FLAG
2784: FROM FND_FLEX_VALUES ,FND_FLEX_VALUES_TL
2785: WHERE FND_FLEX_VALUES.flex_value_set_id = p_value_set_id
2786: AND FND_FLEX_VALUES.FLEX_VALUE_ID = p_value_id
2787: AND FND_FLEX_VALUES.FLEX_VALUE_ID = FND_FLEX_VALUES_TL.FLEX_VALUE_ID
2788: AND LANGUAGE = userenv('LANG')
2789: AND ROWNUM=1;
2790:

Line 2787: AND FND_FLEX_VALUES.FLEX_VALUE_ID = FND_FLEX_VALUES_TL.FLEX_VALUE_ID

2783: SELECT FLEX_VALUE_MEANING,DESCRIPTION, START_DATE_ACTIVE,END_DATE_ACTIVE, ENABLED_FLAG
2784: FROM FND_FLEX_VALUES ,FND_FLEX_VALUES_TL
2785: WHERE FND_FLEX_VALUES.flex_value_set_id = p_value_set_id
2786: AND FND_FLEX_VALUES.FLEX_VALUE_ID = p_value_id
2787: AND FND_FLEX_VALUES.FLEX_VALUE_ID = FND_FLEX_VALUES_TL.FLEX_VALUE_ID
2788: AND LANGUAGE = userenv('LANG')
2789: AND ROWNUM=1;
2790:
2791:

Line 7125: l_value_set_id FND_FLEX_VALUES.FLEX_VALUE_SET_ID%TYPE;

7121: l_owner NUMBER := G_User_Id;
7122: -- l_owner_name VARCHAR2(40):='ANONYMOUS';
7123:
7124: l_value_set_name FND_FLEX_VALUE_SETS.FLEX_VALUE_SET_NAME%TYPE; -- VARCHAR2(60);
7125: l_value_set_id FND_FLEX_VALUES.FLEX_VALUE_SET_ID%TYPE;
7126:
7127: l_flex_value fnd_flex_values.flex_value%TYPE;
7128: l_flex_value_id fnd_flex_values.flex_value_id%TYPE;
7129: l_version_seq_id NUMBER;

Line 7127: l_flex_value fnd_flex_values.flex_value%TYPE;

7123:
7124: l_value_set_name FND_FLEX_VALUE_SETS.FLEX_VALUE_SET_NAME%TYPE; -- VARCHAR2(60);
7125: l_value_set_id FND_FLEX_VALUES.FLEX_VALUE_SET_ID%TYPE;
7126:
7127: l_flex_value fnd_flex_values.flex_value%TYPE;
7128: l_flex_value_id fnd_flex_values.flex_value_id%TYPE;
7129: l_version_seq_id NUMBER;
7130: --l_sequence NUMBER;
7131: l_start_active_date DATE;

Line 7128: l_flex_value_id fnd_flex_values.flex_value_id%TYPE;

7124: l_value_set_name FND_FLEX_VALUE_SETS.FLEX_VALUE_SET_NAME%TYPE; -- VARCHAR2(60);
7125: l_value_set_id FND_FLEX_VALUES.FLEX_VALUE_SET_ID%TYPE;
7126:
7127: l_flex_value fnd_flex_values.flex_value%TYPE;
7128: l_flex_value_id fnd_flex_values.flex_value_id%TYPE;
7129: l_version_seq_id NUMBER;
7130: --l_sequence NUMBER;
7131: l_start_active_date DATE;
7132: l_end_active_date DATE;

Line 7205: FROM fnd_flex_values

7201: -- Cursor to find out if value already exist in system.
7202: CURSOR cur_value( cp_flex_value_set_id NUMBER,
7203: cp_flex_value VARCHAR2) IS
7204: SELECT flex_value_id
7205: FROM fnd_flex_values
7206: WHERE flex_value_set_id= cp_flex_value_set_id
7207: AND flex_value= cp_flex_value;
7208:
7209:

Line 7215: FROM fnd_flex_values

7211: CURSOR cur_value_name( cp_flex_value_set_id NUMBER,
7212: cp_flex_value_id NUMBER )
7213: IS
7214: SELECT flex_value
7215: FROM fnd_flex_values
7216: WHERE flex_value_set_id= cp_flex_value_set_id
7217: AND flex_value_id = cp_flex_value_id;
7218:
7219:

Line 9029: l_value_set_id FND_FLEX_VALUES.FLEX_VALUE_SET_ID%TYPE;

9025: l_owner NUMBER := G_User_Id;
9026: -- l_owner_name VARCHAR2(40):='ANONYMOUS';
9027:
9028: l_value_set_name FND_FLEX_VALUE_SETS.FLEX_VALUE_SET_NAME%TYPE; -- VARCHAR2(60);
9029: l_value_set_id FND_FLEX_VALUES.FLEX_VALUE_SET_ID%TYPE;
9030:
9031: l_flex_value fnd_flex_values.flex_value%TYPE;
9032: l_flex_value_id fnd_flex_values.flex_value_id%TYPE;
9033: l_version_seq_id NUMBER;

Line 9031: l_flex_value fnd_flex_values.flex_value%TYPE;

9027:
9028: l_value_set_name FND_FLEX_VALUE_SETS.FLEX_VALUE_SET_NAME%TYPE; -- VARCHAR2(60);
9029: l_value_set_id FND_FLEX_VALUES.FLEX_VALUE_SET_ID%TYPE;
9030:
9031: l_flex_value fnd_flex_values.flex_value%TYPE;
9032: l_flex_value_id fnd_flex_values.flex_value_id%TYPE;
9033: l_version_seq_id NUMBER;
9034: --l_sequence NUMBER;
9035: l_start_active_date DATE;

Line 9032: l_flex_value_id fnd_flex_values.flex_value_id%TYPE;

9028: l_value_set_name FND_FLEX_VALUE_SETS.FLEX_VALUE_SET_NAME%TYPE; -- VARCHAR2(60);
9029: l_value_set_id FND_FLEX_VALUES.FLEX_VALUE_SET_ID%TYPE;
9030:
9031: l_flex_value fnd_flex_values.flex_value%TYPE;
9032: l_flex_value_id fnd_flex_values.flex_value_id%TYPE;
9033: l_version_seq_id NUMBER;
9034: --l_sequence NUMBER;
9035: l_start_active_date DATE;
9036: l_end_active_date DATE;

Line 10630: FROM fnd_flex_value_sets vs, fnd_flex_values val

10626: CURSOR cur_value_id(cp_value_set_name VARCHAR2,
10627: cp_flex_value VARCHAR2)
10628: IS
10629: SELECT flex_value_id
10630: FROM fnd_flex_value_sets vs, fnd_flex_values val
10631: WHERE vs.flex_value_set_id= val.flex_value_set_id
10632: AND vs.flex_value_set_name= cp_value_set_name
10633: AND flex_value=cp_flex_value;
10634: