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.FII_AR_REVENUE_B_C dependencies on FII_AR_REV_ACCTS

Line 3003: -- program will insert the new accounts into FII_AR_REV_ACCTS

2999: -- accounts assigned to 'Revenue'. Only when deletion
3000: -- happens do we ask the user to truncate Revenue summary
3001: -- and reload. If new accounts were added to 'Revenue'
3002: -- users do not need to truncate Revenue summary, this
3003: -- program will insert the new accounts into FII_AR_REV_ACCTS
3004: -- after it populates the Revenue summary table
3005: ---------------------------------------------------------
3006: g_section := 'Section 10';
3007: drop_table('fii_ar_rev_accts_temp');

Line 3007: drop_table('fii_ar_rev_accts_temp');

3003: -- program will insert the new accounts into FII_AR_REV_ACCTS
3004: -- after it populates the Revenue summary table
3005: ---------------------------------------------------------
3006: g_section := 'Section 10';
3007: drop_table('fii_ar_rev_accts_temp');
3008:
3009: if g_debug_flag = 'Y' then
3010: FII_UTIL.put_line('Creating temp table FII_AR_REV_ACCTS_TEMP');
3011: fii_util.start_timer;

Line 3010: FII_UTIL.put_line('Creating temp table FII_AR_REV_ACCTS_TEMP');

3006: g_section := 'Section 10';
3007: drop_table('fii_ar_rev_accts_temp');
3008:
3009: if g_debug_flag = 'Y' then
3010: FII_UTIL.put_line('Creating temp table FII_AR_REV_ACCTS_TEMP');
3011: fii_util.start_timer;
3012: end if;
3013:
3014: g_section := 'Section 20';

Line 3018: CREATE TABLE '||g_fii_schema||'.fii_ar_rev_accts_temp

3014: g_section := 'Section 20';
3015:
3016: /*
3017: l_stmt:='
3018: CREATE TABLE '||g_fii_schema||'.fii_ar_rev_accts_temp
3019: TABLESPACE '||g_tablespace||'
3020: NOLOGGING STORAGE (INITIAL 4K NEXT 16K MAXEXTENTS UNLIMITED) AS
3021: SELECT fin_category_id cur_rev_acct_id,
3022: fin_cat_type_code cur_fin_cat_type_code

Line 3027: CREATE TABLE '||g_fii_schema||'.fii_ar_rev_accts_temp

3023: FROM fii_fin_cat_type_assgns ffcta
3024: WHERE ffcta.fin_cat_type_code in (''R'', ''DR'') ';
3025: */
3026: l_stmt:='
3027: CREATE TABLE '||g_fii_schema||'.fii_ar_rev_accts_temp
3028: TABLESPACE '||g_tablespace||'
3029: NOLOGGING STORAGE (INITIAL 4K NEXT 16K MAXEXTENTS UNLIMITED) AS
3030: WITH ACCNT_CLASS AS (SELECT XAD.Ledger_ID,
3031: XACA.Accounting_Class_Code,

Line 3057: FROM fii_ar_rev_accts fra,

3053:
3054: /*
3055: l_stmt:= '
3056: SELECT COUNT(*)
3057: FROM fii_ar_rev_accts fra,
3058: '||g_fii_schema||'.fii_ar_rev_accts_temp temp
3059: WHERE fra.rev_acct_id = temp.cur_rev_acct_id(+)
3060: AND fra.fin_cat_type_code = temp.cur_fin_cat_type_code(+)
3061: AND temp.cur_rev_acct_id IS NULL ';

Line 3058: '||g_fii_schema||'.fii_ar_rev_accts_temp temp

3054: /*
3055: l_stmt:= '
3056: SELECT COUNT(*)
3057: FROM fii_ar_rev_accts fra,
3058: '||g_fii_schema||'.fii_ar_rev_accts_temp temp
3059: WHERE fra.rev_acct_id = temp.cur_rev_acct_id(+)
3060: AND fra.fin_cat_type_code = temp.cur_fin_cat_type_code(+)
3061: AND temp.cur_rev_acct_id IS NULL ';
3062: */

Line 3065: FROM fii_ar_rev_accts fra

3061: AND temp.cur_rev_acct_id IS NULL ';
3062: */
3063: l_stmt:= '
3064: SELECT COUNT(*)
3065: FROM fii_ar_rev_accts fra
3066: WHERE NOT EXISTS (
3067: SELECT 1
3068: FROM '||g_fii_schema||'.fii_ar_rev_accts_temp temp
3069: WHERE ( fra.rev_acct_id = temp.Ledger_ID

Line 3068: FROM '||g_fii_schema||'.fii_ar_rev_accts_temp temp

3064: SELECT COUNT(*)
3065: FROM fii_ar_rev_accts fra
3066: WHERE NOT EXISTS (
3067: SELECT 1
3068: FROM '||g_fii_schema||'.fii_ar_rev_accts_temp temp
3069: WHERE ( fra.rev_acct_id = temp.Ledger_ID
3070: OR temp.Ledger_ID IS NULL )
3071: AND fra.rev_acct = temp.Accounting_Class_Code
3072: AND fra.fin_cat_type_code = temp.Fin_Cat_Type_Code

Line 3908: TRUNCATE_TABLE('FII_AR_REV_ACCTS');

3904: END IF;
3905: -- DEBUG
3906: TRUNCATE_TABLE('FII_AR_REVENUE_STG');
3907: TRUNCATE_TABLE('FII_AR_REVENUE_B');
3908: TRUNCATE_TABLE('FII_AR_REV_ACCTS');
3909: BIS_COLLECTION_UTILITIES.DELETELOGFOROBJECT('FII_AR_REVENUE_B_I');
3910: BIS_COLLECTION_UTILITIES.DELETELOGFOROBJECT('FII_AR_REVENUE_B_L');
3911: COMMIT;
3912: END IF;

Line 4612: -- after load is completed, insert into table fii_ar_rev_accts

4608: -------------------------------------------------------------------
4609: g_truncate_staging := 'Y';
4610:
4611: ---------------------------------------------------------------
4612: -- after load is completed, insert into table fii_ar_rev_accts
4613: -- new accounts assigned to 'Revenue'.
4614: ---------------------------------------------------------------
4615: if g_debug_flag = 'Y' then
4616: fii_util.put_line(' ');

Line 4617: fii_util.put_line('Inserting new revenue accounts in fii_ar_rev_accts ');

4613: -- new accounts assigned to 'Revenue'.
4614: ---------------------------------------------------------------
4615: if g_debug_flag = 'Y' then
4616: fii_util.put_line(' ');
4617: fii_util.put_line('Inserting new revenue accounts in fii_ar_rev_accts ');
4618: fii_util.start_timer;
4619: end if;
4620:
4621: /*

Line 4626: -- related into FII_AR_REV_ACCTS table

4622: IF (p_program_type = 'L') THEN
4623:
4624: --------------------------------------------------
4625: -- Inserting natural accounts which are revenue
4626: -- related into FII_AR_REV_ACCTS table
4627: --------------------------------------------------
4628: INSERT INTO fii_ar_rev_accts (rev_acct_id, fin_cat_type_code)
4629: SELECT ffcta.fin_category_id, ffcta.fin_cat_type_code
4630: FROM fii_fin_cat_type_assgns ffcta

Line 4628: INSERT INTO fii_ar_rev_accts (rev_acct_id, fin_cat_type_code)

4624: --------------------------------------------------
4625: -- Inserting natural accounts which are revenue
4626: -- related into FII_AR_REV_ACCTS table
4627: --------------------------------------------------
4628: INSERT INTO fii_ar_rev_accts (rev_acct_id, fin_cat_type_code)
4629: SELECT ffcta.fin_category_id, ffcta.fin_cat_type_code
4630: FROM fii_fin_cat_type_assgns ffcta
4631: WHERE ffcta.fin_cat_type_code in ('R', 'DR');
4632:

Line 4636: INSERT INTO fii_ar_rev_accts (rev_acct_id, fin_cat_type_code)

4632:
4633: ELSE
4634:
4635: l_stmt := '
4636: INSERT INTO fii_ar_rev_accts (rev_acct_id, fin_cat_type_code)
4637: SELECT temp.cur_rev_acct_id, temp.cur_fin_cat_type_code
4638: FROM '||g_fii_schema||'.fii_ar_rev_accts_temp temp,
4639: fii_ar_rev_accts fra
4640: WHERE temp.cur_rev_acct_id = fra.rev_acct_id(+)

Line 4638: FROM '||g_fii_schema||'.fii_ar_rev_accts_temp temp,

4634:
4635: l_stmt := '
4636: INSERT INTO fii_ar_rev_accts (rev_acct_id, fin_cat_type_code)
4637: SELECT temp.cur_rev_acct_id, temp.cur_fin_cat_type_code
4638: FROM '||g_fii_schema||'.fii_ar_rev_accts_temp temp,
4639: fii_ar_rev_accts fra
4640: WHERE temp.cur_rev_acct_id = fra.rev_acct_id(+)
4641: AND temp.cur_fin_cat_type_code = fra.fin_cat_type_code(+)
4642: AND fra.rev_acct_id IS NULL ';

Line 4639: fii_ar_rev_accts fra

4635: l_stmt := '
4636: INSERT INTO fii_ar_rev_accts (rev_acct_id, fin_cat_type_code)
4637: SELECT temp.cur_rev_acct_id, temp.cur_fin_cat_type_code
4638: FROM '||g_fii_schema||'.fii_ar_rev_accts_temp temp,
4639: fii_ar_rev_accts fra
4640: WHERE temp.cur_rev_acct_id = fra.rev_acct_id(+)
4641: AND temp.cur_fin_cat_type_code = fra.fin_cat_type_code(+)
4642: AND fra.rev_acct_id IS NULL ';
4643:

Line 4656: TRUNCATE_TABLE('FII_AR_REV_ACCTS');

4652: */
4653:
4654: IF (p_program_type <> 'L') THEN
4655:
4656: TRUNCATE_TABLE('FII_AR_REV_ACCTS');
4657:
4658: END IF;
4659:
4660: INSERT INTO fii_ar_rev_accts (rev_acct_id, rev_acct, fin_cat_type_code)

Line 4660: INSERT INTO fii_ar_rev_accts (rev_acct_id, rev_acct, fin_cat_type_code)

4656: TRUNCATE_TABLE('FII_AR_REV_ACCTS');
4657:
4658: END IF;
4659:
4660: INSERT INTO fii_ar_rev_accts (rev_acct_id, rev_acct, fin_cat_type_code)
4661: WITH ACCNT_CLASS AS (SELECT XAD.Ledger_ID,
4662: XACA.Accounting_Class_Code,
4663: decode(XAD.Program_Code,
4664: g_program_code_R, 'R',

Line 4773: drop_table('fii_ar_rev_accts_temp');

4769:
4770: COMMIT;
4771:
4772: CLEAN_UP;
4773: drop_table('fii_ar_rev_accts_temp');
4774: WHEN OTHERS THEN
4775: Retcode:= -1;
4776: Errbuf := '
4777: ---------------------------------

Line 4793: drop_table('fii_ar_rev_accts_temp');

4789:
4790: COMMIT;
4791:
4792: CLEAN_UP;
4793: drop_table('fii_ar_rev_accts_temp');
4794: END MAIN;
4795:
4796:
4797: --------------------------------------------------