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 209: FROM GL_LEDGERS GLL,

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

Line 348: FROM GL_LEDGERS GLL,

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

Line 413: FROM GL_LEDGERS gll

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

Line 539: FROM GL_LEDGERS GLL

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

Line 587: FROM GL_LEDGERS

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

Line 620: FROM GL_LEDGERS

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

Line 661: GL_LEDGERS GLL

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

Line 722: GL_LEDGERS GLL

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

Line 827: AND LEDGER_ID IN (SELECT LEDGER_ID FROM GL_LEDGERS

823: UPDATE GL_LEDGER_NORM_SEG_VALS
824: SET STATUS_CODE = NULL, request_id = NULL
825: WHERE STATUS_CODE IN ( 'I','U')
826: AND request_id = GL_FLATTEN_SETUP_DATA.GLSTFL_REQ_ID
827: AND LEDGER_ID IN (SELECT LEDGER_ID FROM GL_LEDGERS
828: WHERE CHART_OF_ACCOUNTS_ID = GL_FLATTEN_SETUP_DATA.GLSTFL_COA_ID
829: AND IMPLICIT_ACCESS_SET_ID IS NOT NULL);
830:
831:

Line 834: FROM GL_LEDGERS

830:
831:
832: /* AND LEDGER_ID IN
833: (SELECT LEDGER_ID
834: FROM GL_LEDGERS
835: WHERE CHART_OF_ACCOUNTS_ID =
836: GL_FLATTEN_SETUP_DATA.GLSTFL_COA_ID); */
837:
838: L_Number_Of_Rows := SQL%ROWCOUNT;

Line 853: FROM GL_LEDGERS

849: SET STATUS_CODE = NULL
850: WHERE STATUS_CODE = 'I'
851: AND LEDGER_ID IN
852: (SELECT LEDGER_ID
853: FROM GL_LEDGERS
854: WHERE CHART_OF_ACCOUNTS_ID =
855: GL_FLATTEN_SETUP_DATA.GLSTFL_COA_ID);
856:
857: L_Number_Of_Rows := SQL%ROWCOUNT;

Line 874: FROM GL_LEDGERS

870: FROM GL_LEDGER_NORM_SEG_VALS
871: WHERE STATUS_CODE = l_status
872: AND LEDGER_ID IN
873: (SELECT LEDGER_ID
874: FROM GL_LEDGERS
875: WHERE CHART_OF_ACCOUNTS_ID =
876: GL_FLATTEN_SETUP_DATA.GLSTFL_COA_ID);
877:
878: L_Number_Of_Rows := SQL%ROWCOUNT;

Line 892: FROM GL_LEDGERS

888: FROM GL_LEDGER_SEGMENT_VALUES
889: WHERE STATUS_CODE = l_status
890: AND LEDGER_ID IN
891: (SELECT LEDGER_ID
892: FROM GL_LEDGERS
893: WHERE CHART_OF_ACCOUNTS_ID =
894: GL_FLATTEN_SETUP_DATA.GLSTFL_COA_ID);
895:
896: L_Number_Of_Rows := SQL%ROWCOUNT;

Line 956: FROM GL_LEDGERS

952: SET STATUS_CODE = NULL
953: WHERE STATUS_CODE = 'I'
954: AND LEDGER_ID IN
955: (SELECT LEDGER_ID
956: FROM GL_LEDGERS
957: WHERE BAL_SEG_VALUE_SET_ID =
958: GL_FLATTEN_SETUP_DATA.GLSTFL_VS_ID
959: OR MGT_SEG_VALUE_SET_ID =
960: GL_FLATTEN_SETUP_DATA.GLSTFL_VS_ID);

Line 975: FROM GL_LEDGERS

971: FROM GL_LEDGER_SEGMENT_VALUES
972: WHERE STATUS_CODE = 'D'
973: AND LEDGER_ID IN
974: (SELECT LEDGER_ID
975: FROM GL_LEDGERS
976: WHERE BAL_SEG_VALUE_SET_ID =
977: GL_FLATTEN_SETUP_DATA.GLSTFL_VS_ID
978: OR MGT_SEG_VALUE_SET_ID =
979: GL_FLATTEN_SETUP_DATA.GLSTFL_VS_ID);

Line 1051: FROM GL_LEDGERS GLL,

1047: DECLARE
1048:
1049: CURSOR Cursor_LV_Ledger IS
1050: SELECT DISTINCT GLLSV1.LEDGER_ID, GLLSV2.SEGMENT_VALUE
1051: FROM GL_LEDGERS GLL,
1052: GL_LEDGER_SEGMENT_VALUES GLLSV1,
1053: GL_LEDGER_SEGMENT_VALUES GLLSV2
1054: WHERE GLL.CHART_OF_ACCOUNTS_ID =
1055: GL_FLATTEN_SETUP_DATA.GLSTFL_COA_ID

Line 1092: FROM GL_LEDGERS

1088:
1089: IF (L_SEGMENT_VAL IS NOT NULL) THEN
1090:
1091: SELECT NAME INTO L_LEDGER_NAME
1092: FROM GL_LEDGERS
1093: WHERE LEDGER_ID = L_LEDGER_ID;
1094:
1095: GL_MESSAGE.Write_Log(MSG_NAME =>'FLAT0003',
1096: TOKEN_NUM => 2,

Line 1134: FROM GL_LEDGERS GLL,

1130: DECLARE
1131:
1132: CURSOR Cursor_SH_Ledger IS
1133: SELECT GLLSV1.LEDGER_ID, GLLSV2.SEGMENT_VALUE
1134: FROM GL_LEDGERS GLL,
1135: GL_LEDGER_SEGMENT_VALUES GLLSV1,
1136: GL_LEDGER_SEGMENT_VALUES GLLSV2
1137: WHERE ( GLL.BAL_SEG_VALUE_SET_ID =
1138: GL_FLATTEN_SETUP_DATA.GLSTFL_VS_ID

Line 1177: FROM GL_LEDGERS

1173:
1174: IF (L_Segment_Val IS NOT NULL) THEN
1175:
1176: SELECT NAME INTO L_LEDGER_NAME
1177: FROM GL_LEDGERS
1178: WHERE LEDGER_ID = L_LEDGER_ID;
1179:
1180: GL_MESSAGE.Write_Log(MSG_NAME =>'FLAT0003',
1181: TOKEN_NUM => 2,