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.GL_FLATTEN_LEDGER_SEG_VALS dependencies on GL_LEDGERS

Line 60: FROM GL_LEDGERS

56: FROM GL_LEDGER_SEGMENT_VALUES
57: WHERE STATUS_CODE = l_status_flag
58: AND LEDGER_ID IN
59: (SELECT LEDGER_ID
60: FROM GL_LEDGERS
61: WHERE CHART_OF_ACCOUNTS_ID = GL_FLATTEN_SETUP_DATA.GLSTFL_COA_ID);
62:
63: L_Number_Of_Rows := SQL%ROWCOUNT;
64: GL_MESSAGE.Write_Log(MSG_NAME =>'SHRD0119',

Line 89: FROM GL_LEDGERS

85: SET status_code = NULL
86: WHERE status_code = 'D'
87: AND ledger_id IN
88: (SELECT ledger_id
89: FROM GL_LEDGERS
90: WHERE chart_of_accounts_id = GL_FLATTEN_SETUP_DATA.GLSTFL_COA_ID);
91:
92: L_Number_Of_Rows := SQL%ROWCOUNT;
93: GL_MESSAGE.Write_Log(MSG_NAME =>'SHRD0118',

Line 123: FROM GL_LEDGERS GLL,

119: FROM GL_LEDGER_NORM_SEG_VALS GLLNSV
120: WHERE GLLNSV.RECORD_ID = GLLSV.PARENT_RECORD_ID)
121: WHERE GLLSV.PARENT_RECORD_ID IN
122: (SELECT GLLNSV2.RECORD_ID
123: FROM GL_LEDGERS GLL,
124: GL_LEDGER_NORM_SEG_VALS GLLNSV2
125: WHERE GLL.CHART_OF_ACCOUNTS_ID =
126: GL_FLATTEN_SETUP_DATA.GLSTFL_COA_ID
127: AND GLLNSV2.STATUS_CODE = 'U'

Line 158: FROM GL_LEDGERS GLL,

154: UPDATE GL_LEDGER_SEGMENT_VALUES
155: SET STATUS_CODE = 'D'
156: WHERE PARENT_RECORD_ID IN
157: (SELECT RECORD_ID
158: FROM GL_LEDGERS GLL,
159: GL_LEDGER_NORM_SEG_VALS GLLNSV
160: WHERE GLL.CHART_OF_ACCOUNTS_ID =
161: GL_FLATTEN_SETUP_DATA.GLSTFL_COA_ID
162: AND GLLNSV.STATUS_CODE = 'D'

Line 208: FROM GL_LEDGERS GLL,

204: SYSDATE,
205: GL_FLATTEN_SETUP_DATA.GLSTFL_USER_ID,
206: GL_FLATTEN_SETUP_DATA.GLSTFL_LOGIN_ID,
207: GLLNSV.START_DATE, GLLNSV.END_DATE
208: FROM GL_LEDGERS GLL,
209: GL_LEDGER_NORM_SEG_VALS GLLNSV
210: WHERE GLL.CHART_OF_ACCOUNTS_ID =
211: GL_FLATTEN_SETUP_DATA.GLSTFL_COA_ID
212: AND GLLNSV.LEDGER_ID = GLL.LEDGER_ID

Line 345: FROM GL_LEDGERS GLL,

341: SYSDATE,
342: GL_FLATTEN_SETUP_DATA.GLSTFL_USER_ID,
343: GL_FLATTEN_SETUP_DATA.GLSTFL_LOGIN_ID,
344: GLLNSV.START_DATE, GLLNSV.END_DATE
345: FROM GL_LEDGERS GLL,
346: GL_LEDGER_NORM_SEG_VALS GLLNSV,
347: GL_SEG_VAL_HIERARCHIES GLSVH
348: WHERE GLL.CHART_OF_ACCOUNTS_ID =
349: GL_FLATTEN_SETUP_DATA.GLSTFL_COA_ID

Line 410: FROM GL_LEDGERS gll

406: sysdate,
407: GL_FLATTEN_SETUP_DATA.GLSTFL_USER_ID,
408: GL_FLATTEN_SETUP_DATA.GLSTFL_LOGIN_ID,
409: gllsv.start_date, gllsv.end_date
410: FROM GL_LEDGERS gll
411: ,GL_LEDGER_RELATIONSHIPS glr
412: ,GL_LEDGER_SEGMENT_VALUES gllsv
413: WHERE gll.chart_of_accounts_id =
414: GL_FLATTEN_SETUP_DATA.GLSTFL_COA_ID

Line 536: FROM GL_LEDGERS GLL

532: SELECT 1 INTO L_Check_Id
533: FROM DUAL
534: WHERE EXISTS
535: (SELECT 1
536: FROM GL_LEDGERS GLL
537: WHERE GLL.BAL_SEG_VALUE_SET_ID =
538: GL_FLATTEN_SETUP_DATA.GLSTFL_VS_ID
539: OR GLL.MGT_SEG_VALUE_SET_ID =
540: GL_FLATTEN_SETUP_DATA.GLSTFL_VS_ID

Line 584: FROM GL_LEDGERS

580: FROM GL_LEDGER_SEGMENT_VALUES
581: WHERE STATUS_CODE = 'I'
582: AND LEDGER_ID IN
583: (SELECT LEDGER_ID
584: FROM GL_LEDGERS
585: WHERE BAL_SEG_VALUE_SET_ID =
586: GL_FLATTEN_SETUP_DATA.GLSTFL_VS_ID
587: OR MGT_SEG_VALUE_SET_ID =
588: GL_FLATTEN_SETUP_DATA.GLSTFL_VS_ID);

Line 617: FROM GL_LEDGERS

613: SET STATUS_CODE = NULL
614: WHERE STATUS_CODE = 'D'
615: AND LEDGER_ID IN
616: (SELECT LEDGER_ID
617: FROM GL_LEDGERS
618: WHERE BAL_SEG_VALUE_SET_ID =
619: GL_FLATTEN_SETUP_DATA.GLSTFL_VS_ID
620: OR MGT_SEG_VALUE_SET_ID =
621: GL_FLATTEN_SETUP_DATA.GLSTFL_VS_ID);

Line 658: GL_LEDGERS GLL

654: (SELECT GLLNSV.LEDGER_ID, GLLNSV.RECORD_ID,
655: GLSVH.CHILD_FLEX_VALUE
656: FROM GL_SEG_VAL_HIERARCHIES GLSVH,
657: GL_LEDGER_NORM_SEG_VALS GLLNSV,
658: GL_LEDGERS GLL
659: WHERE GLSVH.FLEX_VALUE_SET_ID =
660: GL_FLATTEN_SETUP_DATA.GLSTFL_VS_ID
661: AND GLSVH.STATUS_CODE = 'D'
662: AND GLLNSV.SEGMENT_VALUE_TYPE_CODE = 'C'

Line 719: GL_LEDGERS GLL

715: GL_FLATTEN_SETUP_DATA.GLSTFL_LOGIN_ID,
716: GLLNSV.START_DATE, GLLNSV.END_DATE
717: FROM GL_SEG_VAL_HIERARCHIES GLSVH,
718: GL_LEDGER_NORM_SEG_VALS GLLNSV,
719: GL_LEDGERS GLL
720: WHERE GLSVH.FLEX_VALUE_SET_ID =
721: GL_FLATTEN_SETUP_DATA.GLSTFL_VS_ID
722: AND GLSVH.STATUS_CODE = 'I'
723: AND GLLNSV.SEGMENT_VALUE_TYPE_CODE = 'C'

Line 826: FROM GL_LEDGERS

822: AND request_id =
823: GL_FLATTEN_SETUP_DATA.GLSTFL_REQ_ID;
824: /* AND LEDGER_ID IN
825: (SELECT LEDGER_ID
826: FROM GL_LEDGERS
827: WHERE CHART_OF_ACCOUNTS_ID =
828: GL_FLATTEN_SETUP_DATA.GLSTFL_COA_ID); */
829:
830: L_Number_Of_Rows := SQL%ROWCOUNT;

Line 845: FROM GL_LEDGERS

841: SET STATUS_CODE = NULL
842: WHERE STATUS_CODE = 'I'
843: AND LEDGER_ID IN
844: (SELECT LEDGER_ID
845: FROM GL_LEDGERS
846: WHERE CHART_OF_ACCOUNTS_ID =
847: GL_FLATTEN_SETUP_DATA.GLSTFL_COA_ID);
848:
849: L_Number_Of_Rows := SQL%ROWCOUNT;

Line 866: FROM GL_LEDGERS

862: FROM GL_LEDGER_NORM_SEG_VALS
863: WHERE STATUS_CODE = l_status
864: AND LEDGER_ID IN
865: (SELECT LEDGER_ID
866: FROM GL_LEDGERS
867: WHERE CHART_OF_ACCOUNTS_ID =
868: GL_FLATTEN_SETUP_DATA.GLSTFL_COA_ID);
869:
870: L_Number_Of_Rows := SQL%ROWCOUNT;

Line 884: FROM GL_LEDGERS

880: FROM GL_LEDGER_SEGMENT_VALUES
881: WHERE STATUS_CODE = l_status
882: AND LEDGER_ID IN
883: (SELECT LEDGER_ID
884: FROM GL_LEDGERS
885: WHERE CHART_OF_ACCOUNTS_ID =
886: GL_FLATTEN_SETUP_DATA.GLSTFL_COA_ID);
887:
888: L_Number_Of_Rows := SQL%ROWCOUNT;

Line 948: FROM GL_LEDGERS

944: SET STATUS_CODE = NULL
945: WHERE STATUS_CODE = 'I'
946: AND LEDGER_ID IN
947: (SELECT LEDGER_ID
948: FROM GL_LEDGERS
949: WHERE BAL_SEG_VALUE_SET_ID =
950: GL_FLATTEN_SETUP_DATA.GLSTFL_VS_ID
951: OR MGT_SEG_VALUE_SET_ID =
952: GL_FLATTEN_SETUP_DATA.GLSTFL_VS_ID);

Line 967: FROM GL_LEDGERS

963: FROM GL_LEDGER_SEGMENT_VALUES
964: WHERE STATUS_CODE = 'D'
965: AND LEDGER_ID IN
966: (SELECT LEDGER_ID
967: FROM GL_LEDGERS
968: WHERE BAL_SEG_VALUE_SET_ID =
969: GL_FLATTEN_SETUP_DATA.GLSTFL_VS_ID
970: OR MGT_SEG_VALUE_SET_ID =
971: GL_FLATTEN_SETUP_DATA.GLSTFL_VS_ID);

Line 1043: FROM GL_LEDGERS GLL,

1039: DECLARE
1040:
1041: CURSOR Cursor_LV_Ledger IS
1042: SELECT DISTINCT GLLSV1.LEDGER_ID, GLLSV2.SEGMENT_VALUE
1043: FROM GL_LEDGERS GLL,
1044: GL_LEDGER_SEGMENT_VALUES GLLSV1,
1045: GL_LEDGER_SEGMENT_VALUES GLLSV2
1046: WHERE GLL.CHART_OF_ACCOUNTS_ID =
1047: GL_FLATTEN_SETUP_DATA.GLSTFL_COA_ID

Line 1084: FROM GL_LEDGERS

1080:
1081: IF (L_SEGMENT_VAL IS NOT NULL) THEN
1082:
1083: SELECT NAME INTO L_LEDGER_NAME
1084: FROM GL_LEDGERS
1085: WHERE LEDGER_ID = L_LEDGER_ID;
1086:
1087: GL_MESSAGE.Write_Log(MSG_NAME =>'FLAT0003',
1088: TOKEN_NUM => 2,

Line 1126: FROM GL_LEDGERS GLL,

1122: DECLARE
1123:
1124: CURSOR Cursor_SH_Ledger IS
1125: SELECT GLLSV1.LEDGER_ID, GLLSV2.SEGMENT_VALUE
1126: FROM GL_LEDGERS GLL,
1127: GL_LEDGER_SEGMENT_VALUES GLLSV1,
1128: GL_LEDGER_SEGMENT_VALUES GLLSV2
1129: WHERE ( GLL.BAL_SEG_VALUE_SET_ID =
1130: GL_FLATTEN_SETUP_DATA.GLSTFL_VS_ID

Line 1169: FROM GL_LEDGERS

1165:
1166: IF (L_Segment_Val IS NOT NULL) THEN
1167:
1168: SELECT NAME INTO L_LEDGER_NAME
1169: FROM GL_LEDGERS
1170: WHERE LEDGER_ID = L_LEDGER_ID;
1171:
1172: GL_MESSAGE.Write_Log(MSG_NAME =>'FLAT0003',
1173: TOKEN_NUM => 2,