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_AP_INV_LINES_F_C dependencies on FII_AP_TMP_LINE_PK

Line 69: INSERT INTO fii_ap_tmp_line_pk(

65: -- Need to store invoice_line_number in the temp table. Change done for Inv Lines Uptake
66: -- See design doc on fol for more details
67: ------------------------------------------------------------------------------------------------------
68:
69: INSERT INTO fii_ap_tmp_line_pk(
70: Primary_Key1,
71: Primary_Key2,
72: Primary_key4,
73: Primary_Key5 )

Line 492: from fii_ap_tmp_line_pk apk

488: cursor c_tmp is
489: select apk.PRIMARY_KEY_CHAR1 pk,
490: apk.PRIMARY_KEY4 amt_t,
491: apk.PRIMARY_KEY5 amt_b
492: from fii_ap_tmp_line_pk apk
493: where apk.SEQ_ID = -878;
494:
495: l_temp_date DATE;
496: l_duration NUMBER;

Line 512: -- truncate fii_ap_tmp_line_pk

508: -- get minimum accountable unit of the warehouse currency;
509:
510: l_mau := nvl( edw_currency.get_mau, 0.01);
511:
512: -- truncate fii_ap_tmp_line_pk
513:
514: TRUNCATE_TABLE ('fii_ap_tmp_line_pk');
515:
516: -- populate fii_ap_tmp_line_pk from local staging

Line 514: TRUNCATE_TABLE ('fii_ap_tmp_line_pk');

510: l_mau := nvl( edw_currency.get_mau, 0.01);
511:
512: -- truncate fii_ap_tmp_line_pk
513:
514: TRUNCATE_TABLE ('fii_ap_tmp_line_pk');
515:
516: -- populate fii_ap_tmp_line_pk from local staging
517:
518: l_temp_date := sysdate;

Line 516: -- populate fii_ap_tmp_line_pk from local staging

512: -- truncate fii_ap_tmp_line_pk
513:
514: TRUNCATE_TABLE ('fii_ap_tmp_line_pk');
515:
516: -- populate fii_ap_tmp_line_pk from local staging
517:
518: l_temp_date := sysdate;
519:
520: insert into fii_ap_tmp_line_pk (

Line 520: insert into fii_ap_tmp_line_pk (

516: -- populate fii_ap_tmp_line_pk from local staging
517:
518: l_temp_date := sysdate;
519:
520: insert into fii_ap_tmp_line_pk (
521: SEQ_ID,
522: PRIMARY_KEY1, --invoice_id
523: PRIMARY_KEY2, --old_dist_line_number
524: /* PRIMARY_KEY_CHAR2, ap_ae_lines_all.reference8 */

Line 545: -- populate Discount Amounts into fii_ap_tmp_line_pk

541:
542: l_duration := sysdate - l_temp_date;
543: edw_log.put_line ('Process Time for Insert into TMP: '||edw_log.duration(l_duration));
544:
545: -- populate Discount Amounts into fii_ap_tmp_line_pk
546:
547: l_temp_date := sysdate;
548:
549:

Line 555: TABNAME => 'FII_AP_TMP_LINE_PK') ;

551: /* need to analyze the temp table */
552:
553: IF (FND_INSTALLATION.GET_APP_INFO('FII', l_status, l_industry, l_fii_schema)) THEN
554: FND_STATS.GATHER_TABLE_STATS(OWNNAME => l_fii_schema,
555: TABNAME => 'FII_AP_TMP_LINE_PK') ;
556: END IF;
557:
558: --bug 3012243: consider DR columns in calculating discount
559: -- bug 3381164 : added leading hint to imporve the performance

Line 560: insert into fii_ap_tmp_line_pk (

556: END IF;
557:
558: --bug 3012243: consider DR columns in calculating discount
559: -- bug 3381164 : added leading hint to imporve the performance
560: insert into fii_ap_tmp_line_pk (
561: SEQ_ID,
562: PRIMARY_KEY_CHAR1, --inv_line_pk
563: PRIMARY_KEY4, --discount_amt_t
564: PRIMARY_KEY5) --discount_amt_b

Line 569: FROM fii_ap_tmp_line_pk apk,

565: SELECT -878,
566: apk.PRIMARY_KEY_CHAR1,
567: sum (nvl (aphd.amount,0)),
568: sum(nvl(aphd.paid_base_amount,0))
569: FROM fii_ap_tmp_line_pk apk,
570: ap_invoice_payments_all aip,
571: ap_payment_hist_dists aphd,
572: ap_payment_history_all aph
573: WHERE apk.PRIMARY_KEY1 = aip.invoice_id

Line 589: FROM fii_ap_tmp_line_pk apk,

585: apk.PRIMARY_KEY_CHAR1,
586: NVL(sum(xal.entered_cr), 0) - NVL(sum(xal.entered_dr), 0),
587: NVL(sum(NVL(xal.accounted_cr, xal.entered_cr)), 0) -
588: NVL(sum(NVL(xal.accounted_dr, xal.entered_dr)), 0)
589: FROM fii_ap_tmp_line_pk apk,
590: ap_invoice_payments_all aip,
591: -- ap_payment_history_all aph,
592: xla_ae_lines xal,
593: xla_ae_headers xah

Line 609: -- update fii_ap_inv_lines_fstg from fii_ap_tmp_line_pk

605: l_duration := sysdate - l_temp_date;
606: edw_log.put_line ('Process Time for Insert into TMP w/ Discount: ' ||
607: edw_log.duration(l_duration));
608:
609: -- update fii_ap_inv_lines_fstg from fii_ap_tmp_line_pk
610:
611: l_temp_date := sysdate;
612:
613: FOR v_tmp IN c_tmp LOOP

Line 972: l_stmt := ' INSERT INTO fii_ap_tmp_line_pk(

968: -- The value of the profile option stored in the global variable g_acct_or_inv_date
969: -- will be stored in the column Primary_Key5 . Modified for Currency Conversion Date Enhancement, 4-APR-03
970: -----------------------------------------------------------------------------------------------------
971:
972: l_stmt := ' INSERT INTO fii_ap_tmp_line_pk(
973: Primary_Key1,
974: Primary_Key2,
975: Primary_Key4,
976: Primary_Key5)

Line 1088: TABNAME => 'FII_AP_TMP_LINE_PK') ;

1084: to_char(p_count));
1085:
1086: IF (FND_INSTALLATION.GET_APP_INFO('FII', l_status, l_industry, l_fii_schema)) THEN
1087: FND_STATS.GATHER_TABLE_STATS(OWNNAME => l_fii_schema,
1088: TABNAME => 'FII_AP_TMP_LINE_PK') ;
1089: END IF;
1090: --**
1091:
1092:

Line 1106: from fii_ap_tmp_line_pk;

1102:
1103: PROCEDURE UPDATE_DIST_CCID IS
1104: cursor ccid_cursor is
1105: select distinct primary_key1 ccid, primary_key_char1 inv_line_pk
1106: from fii_ap_tmp_line_pk;
1107: BEGIN
1108: TRUNCATE_TABLE('fii_ap_tmp_line_pk');
1109:
1110: insert into fii_ap_tmp_line_pk(Primary_key1,

Line 1108: TRUNCATE_TABLE('fii_ap_tmp_line_pk');

1104: cursor ccid_cursor is
1105: select distinct primary_key1 ccid, primary_key_char1 inv_line_pk
1106: from fii_ap_tmp_line_pk;
1107: BEGIN
1108: TRUNCATE_TABLE('fii_ap_tmp_line_pk');
1109:
1110: insert into fii_ap_tmp_line_pk(Primary_key1,
1111: Primary_key_Char1)
1112: with accounting_class AS (SELECT distinct xaca.accounting_class_Code

Line 1110: insert into fii_ap_tmp_line_pk(Primary_key1,

1106: from fii_ap_tmp_line_pk;
1107: BEGIN
1108: TRUNCATE_TABLE('fii_ap_tmp_line_pk');
1109:
1110: insert into fii_ap_tmp_line_pk(Primary_key1,
1111: Primary_key_Char1)
1112: with accounting_class AS (SELECT distinct xaca.accounting_class_Code
1113: FROM xla_assignment_defns_B xad,
1114: xla_acct_class_assgns xaca

Line 1282: from fii_ap_tmp_line_pk;

1278: select Primary_key1,
1279: Primary_key2,
1280: Primary_Key5,
1281: Primary_Key4
1282: from fii_ap_tmp_line_pk;
1283: commit;
1284: else
1285:
1286: TRUNCATE_TABLE('FII_AP_TMP_LINE_PK');--bug#3818907

Line 1286: TRUNCATE_TABLE('FII_AP_TMP_LINE_PK');--bug#3818907

1282: from fii_ap_tmp_line_pk;
1283: commit;
1284: else
1285:
1286: TRUNCATE_TABLE('FII_AP_TMP_LINE_PK');--bug#3818907
1287:
1288: --bug#3818907
1289: --move the missing rates related info. from the missing rates
1290: --table to the temp table for further processing.

Line 1291: Insert into fii_ap_tmp_line_pk(Primary_Key1,

1287:
1288: --bug#3818907
1289: --move the missing rates related info. from the missing rates
1290: --table to the temp table for further processing.
1291: Insert into fii_ap_tmp_line_pk(Primary_Key1,
1292: Primary_Key2,
1293: Primary_Key5,
1294: Primary_Key4) /* Inv Line Uptake */
1295: select Primary_Key1,

Line 1378: TRUNCATE_TABLE('fii_ap_tmp_line_pk');

1374:
1375: -- --------------------------------------------------------
1376: -- 4. Delete all temp table records
1377: -- --------------------------------------------------------
1378: TRUNCATE_TABLE('fii_ap_tmp_line_pk');
1379:
1380: -- ------------------------------------------------------------------------------------------------
1381: -- 4A. Insert missing rates from local fstg into tmp_pk table printing data to file
1382: -- ------------------------------------------------------------------------------------------------

Line 1537: from fii_ap_tmp_line_pk;

1533: select Primary_Key1,
1534: Primary_Key2,
1535: Primary_Key5,
1536: Primary_Key4
1537: from fii_ap_tmp_line_pk;
1538:
1539: -- -----------------------------------------------
1540: -- Successful. Commit and call
1541: -- wrapup to commit and insert messages into logs

Line 1565: TRUNCATE_TABLE('FII_AP_TMP_LINE_PK');

1561: --bug#3818907
1562: --Program is on the verge of completing successfully,so clean up
1563: -- the temp table
1564: begin
1565: TRUNCATE_TABLE('FII_AP_TMP_LINE_PK');
1566: exception
1567: when others then
1568: null;
1569: end;