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_KEY_ACCOUNTS_B

Line 256: AMW_FIN_KEY_ACCOUNTS_B keyacc

252: distinct keyacc.ACCOUNT_GROUP_ID
253: --, keyacc.NATURAL_ACCOUNT_ID
254: --, NATURAL_ACCOUNT_VALUE
255: from
256: AMW_FIN_KEY_ACCOUNTS_B keyacc
257: WHERE keyacc.End_Date is null
258: And keyacc.NATURAL_ACCOUNT_ID = P_NATURAL_ACCOUNT_ID
259: and END_DATE is null
260: and ACCOUNT_GROUP_ID =

Line 261: (select max(keyacc2.ACCOUNT_GROUP_ID) from AMW_FIN_KEY_ACCOUNTS_B keyacc2 where keyacc2.End_Date is null) ;

257: WHERE keyacc.End_Date is null
258: And keyacc.NATURAL_ACCOUNT_ID = P_NATURAL_ACCOUNT_ID
259: and END_DATE is null
260: and ACCOUNT_GROUP_ID =
261: (select max(keyacc2.ACCOUNT_GROUP_ID) from AMW_FIN_KEY_ACCOUNTS_B keyacc2 where keyacc2.End_Date is null) ;
262:
263:
264: begin
265: -- AMW_IMPORT_STMNTS_ACCS_PKG.end_date_stmnts_before_import(P_RUNID => m_run_id) ;

Line 928: AMW_FIN_KEY_ACCOUNTS_B

924: --(p_CHART_OF_ACCOUNTS_ID number)
925: SELECT
926: distinct ACCOUNT_GROUP_ID , NATURAL_ACCOUNT_ID, NATURAL_ACCOUNT_VALUE
927: from
928: AMW_FIN_KEY_ACCOUNTS_B
929: WHERE End_Date is null
930: And NATURAL_ACCOUNT_VALUE >= M_Low_Value
931: And NATURAL_ACCOUNT_VALUE <= M_High_Value
932: and END_DATE is null;

Line 1333: --update AMW_FIN_KEY_ACCOUNTS_B set end_date = sysdate;

1329:
1330:
1331: begin
1332:
1333: --update AMW_FIN_KEY_ACCOUNTS_B set end_date = sysdate;
1334:
1335: --fix bug 5926333
1336: m_acc_value_set_id := to_number(fnd_profile.value('AMW_NATRL_ACCT_VALUE_SET'));
1337:

Line 1442: update AMW_FIN_KEY_ACCOUNTS_B set end_date = sysdate

1438:
1439: end loop;
1440:
1441: end loop;
1442: update AMW_FIN_KEY_ACCOUNTS_B set end_date = sysdate
1443: where ACCOUNT_GROUP_ID<>M_ACCOUNT_GROUP_ID;
1444:
1445: -- Sanket.
1446: amw_import_stmnts_accs_pkg.flatten_accounts ( x_group_id => m_account_group_id );

Line 1638: --accounts_b_record AMW_FIN_KEY_ACCOUNTS_B%rowtype;

1634: --SITE_RECORD;
1635:
1636: accounts_b_record accounts_b;
1637:
1638: --accounts_b_record AMW_FIN_KEY_ACCOUNTS_B%rowtype;
1639: TYPE get_acc_cursor IS ref CURSOR ;
1640: Get_acc_from_external_apps get_acc_cursor;
1641:
1642:

Line 1675: --update AMW_FIN_KEY_ACCOUNTS_B set end_date = sysdate;

1671:
1672:
1673: begin
1674:
1675: --update AMW_FIN_KEY_ACCOUNTS_B set end_date = sysdate;
1676: select AMW_FIN_KEY_ACCOUNTS_S.nextval into M_ACCOUNT_GROUP_ID from dual;
1677:
1678:
1679: open Get_acc_from_external_apps for sql_for_acc;

Line 1759: update AMW_FIN_KEY_ACCOUNTS_B set end_date = sysdate

1755: X_CREATION_DATE => SYSDATE,
1756: X_CREATED_BY => g_user_id);
1757:
1758: end loop;
1759: update AMW_FIN_KEY_ACCOUNTS_B set end_date = sysdate
1760: where ACCOUNT_GROUP_ID<>M_ACCOUNT_GROUP_ID;
1761:
1762:
1763: -- Sanket.

Line 1809: -- cursor C is select NATURAL_ACCOUNT_ID from AMW_FIN_KEY_ACCOUNTS_B

1805: X_ATTRIBUTE14 in VARCHAR2,
1806: X_ATTRIBUTE15 in VARCHAR2,
1807: X_PARENT_NATURAL_ACCOUNT_ID in NUMBER) is
1808:
1809: -- cursor C is select NATURAL_ACCOUNT_ID from AMW_FIN_KEY_ACCOUNTS_B
1810: -- where ACCOUNT_GROUP_ID = X_ACCOUNT_GROUP_ID;
1811:
1812: var_NATURAL_ACCOUNT_ID number;
1813:

Line 1817: from AMW_FIN_KEY_ACCOUNTS_B

1813:
1814: begin
1815: select
1816: NATURAL_ACCOUNT_ID into var_NATURAL_ACCOUNT_ID
1817: from AMW_FIN_KEY_ACCOUNTS_B
1818: where ACCOUNT_GROUP_ID = X_ACCOUNT_GROUP_ID AND
1819: NATURAL_ACCOUNT_ID = X_NATURAL_ACCOUNT_ID AND
1820: NVL(PARENT_NATURAL_ACCOUNT_ID,-1)= NVL(X_PARENT_NATURAL_ACCOUNT_ID,-1);
1821: EXCEPTION

Line 1824: insert into AMW_FIN_KEY_ACCOUNTS_B (

1820: NVL(PARENT_NATURAL_ACCOUNT_ID,-1)= NVL(X_PARENT_NATURAL_ACCOUNT_ID,-1);
1821: EXCEPTION
1822: WHEN NO_DATA_FOUND THEN
1823:
1824: insert into AMW_FIN_KEY_ACCOUNTS_B (
1825: ACCOUNT_GROUP_ID,
1826: NATURAL_ACCOUNT_ID,
1827: NATURAL_ACCOUNT_VALUE,
1828: END_DATE,

Line 2674: select count(account_group_id) into M_acct_count from amw_fin_key_Accounts_b where END_DATE is null;

2670:
2671: m_errMsg varchar2(2000);
2672: M_acct_count number := 0;
2673: begin
2674: select count(account_group_id) into M_acct_count from amw_fin_key_Accounts_b where END_DATE is null;
2675:
2676: if M_acct_count = 0 then
2677: FND_MESSAGE.SET_NAME ('AMW', 'AMW_KEY_ACCOUNTS_NOT_IMPORTED');
2678: g_errbuf := FND_MESSAGE.GET_STRING('AMW', 'AMW_KEY_ACCOUNTS_NOT_IMPORTED');

Line 2714: -- For every parent - child relationship in amw_fin_key_accounts_b table,

2710:
2711: -------------------------------------------------------------------------
2712: -- Procedure that flattens the accounts table (Sanket).
2713: --
2714: -- For every parent - child relationship in amw_fin_key_accounts_b table,
2715: -- we insert one record in the flat table. This implies that given a
2716: -- particular account group id g, for a root
2717: -- account id x, we will not have a row in the flat table with child =
2718: -- x. Similarly, for a leaf acct y, we will not have a row with parent =

Line 2727: from amw_fin_key_accounts_b

2723: procedure flatten_accounts ( x_group_id in number ) is
2724:
2725: cursor acct_cursor is
2726: select distinct natural_account_id acct_id, account_group_id group_id
2727: from amw_fin_key_accounts_b
2728: where account_group_id = x_group_id ;
2729:
2730: cursor nested_cursor ( p_acct_id number, p_group_id number ) is
2731:

Line 2735: from AMW_FIN_KEY_ACCOUNTS_B acct

2731:
2732: select p_acct_id parent_id,
2733: acct.natural_account_id child_id,
2734: acct.account_group_id group_id
2735: from AMW_FIN_KEY_ACCOUNTS_B acct
2736: start with account_group_id = p_group_id
2737: and parent_natural_account_id = p_acct_id
2738: connect by prior natural_account_id = parent_natural_account_id
2739: and account_group_id = p_group_id;