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.AMW_IMPORT_STMNTS_ACCS_PKG dependencies on AMW_FIN_STMNT_SELECTION

Line 154: || ' where FINANCIAL_STATEMENT_ID in (select FINANCIAL_STATEMENT_ID from AMW_FIN_STMNT_SELECTION where run_id =' || to_char(P_RUN_ID) || ')';

150: sql_for_stmnt varchar2(2000):=
151: 'SELECT
152: FINANCIAL_STATEMENT_ID
153: from ' || fnd_profile.value('AMW_STMNT_SOURCE_VIEW')
154: || ' where FINANCIAL_STATEMENT_ID in (select FINANCIAL_STATEMENT_ID from AMW_FIN_STMNT_SELECTION where run_id =' || to_char(P_RUN_ID) || ')';
155:
156: TYPE statements_b IS RECORD (
157: FINANCIAL_STATEMENT_ID NUMBER);
158: statements_b_record statements_b ;

Line 172: || ' where FINANCIAL_STATEMENT_ID in (select FINANCIAL_STATEMENT_ID from AMW_FIN_STMNT_SELECTION where run_id ='|| to_char(P_RUN_ID) || ')';

168: FINANCIAL_ITEM_ID,
169: PARENT_FINANCIAL_ITEM_ID,
170: SEQUENCE_NUMBER
171: from ' || fnd_profile.value('AMW_FINITEM_SOURCE_VIEW')
172: || ' where FINANCIAL_STATEMENT_ID in (select FINANCIAL_STATEMENT_ID from AMW_FIN_STMNT_SELECTION where run_id ='|| to_char(P_RUN_ID) || ')';
173:
174:
175: TYPE statement_item_b IS RECORD (
176: FINANCIAL_STATEMENT_ID NUMBER,

Line 554: where FINANCIAL_STATEMENT_ID in (select FINANCIAL_STATEMENT_ID from AMW_FIN_STMNT_SELECTION where run_id = P_RUN_ID);

550: FINANCIAL_STATEMENT_ID,
551: NAME
552: from
553: AMW_STATEMENTS_V
554: where FINANCIAL_STATEMENT_ID in (select FINANCIAL_STATEMENT_ID from AMW_FIN_STMNT_SELECTION where run_id = P_RUN_ID);
555:
556:
557: cursor Get_fin_items_from_ora_gl
558: is

Line 568: where FINANCIAL_STATEMENT_ID in (select FINANCIAL_STATEMENT_ID from AMW_FIN_STMNT_SELECTION where run_id = P_RUN_ID);

564: DISPLAY_FLAG,
565: PARENT_FINANCIAL_ITEM_ID
566: from
567: AMW_FINANCIAL_ITEMS_V
568: where FINANCIAL_STATEMENT_ID in (select FINANCIAL_STATEMENT_ID from AMW_FIN_STMNT_SELECTION where run_id = P_RUN_ID);
569:
570: cursor Get_lang
571: is
572: select

Line 893: in (select FINANCIAL_STATEMENT_ID from AMW_FIN_STMNT_SELECTION where run_id = P_RUN_ID);

889: SEGMENT30_TYPE
890: FROM
891: AMW_FIN_ITEMS_ACCOUNT_RANGE_V
892: where FINANCIAL_STATEMENT_ID
893: in (select FINANCIAL_STATEMENT_ID from AMW_FIN_STMNT_SELECTION where run_id = P_RUN_ID);
894:
895: cursor Get_acc_range_column_ora_gl(P_CHART_OF_ACCOUNTS_ID number) is
896: Select
897: distinct v.APPLICATION_COLUMN_NAME ,

Line 1191: FINANCIAL_STATEMENT_ID in (select FINANCIAL_STATEMENT_ID from AMW_FIN_STMNT_SELECTION where run_id = P_RUNID);

1187:
1188:
1189: update AMW_FIN_STMNT_B set end_date = sysdate
1190: where STATEMENT_GROUP_ID <> P_STATEMENT_GROUP_ID and
1191: FINANCIAL_STATEMENT_ID in (select FINANCIAL_STATEMENT_ID from AMW_FIN_STMNT_SELECTION where run_id = P_RUNID);
1192:
1193: delete AMW_FIN_STMNT_TL tl where exists(select base.STATEMENT_GROUP_ID, base.FINANCIAL_STATEMENT_ID
1194: from AMW_FIN_STMNT_B base where base.STATEMENT_GROUP_ID= tl.STATEMENT_GROUP_ID
1195: and base.FINANCIAL_STATEMENT_ID = tl.FINANCIAL_STATEMENT_ID and base.end_date is not null