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.AP_ACCTG_DATA_FIX_PKG dependencies on AP_INVOICE_DISTRIBUTIONS_ALL

Line 2364: UPDATE ap_Invoice_distributions_All aid

2360: WHERE Accounting_Event_Id = Events_to_Process_tab(i).Event_Id
2361: AND Check_Id = p_Source_Id;
2362:
2363: --8306966
2364: UPDATE ap_Invoice_distributions_All aid
2365: SET Accounting_Date = l_gl_Date,
2366: Posted_Flag = 'N',
2367: Accrual_Posted_Flag = 'N',
2368: Last_Updated_By = fnd_Global.User_Id,

Line 2411: UPDATE ap_Invoice_Distributions_All Aid

2407: l_event_status_code = 'U') THEN
2408:
2409: BEGIN
2410:
2411: UPDATE ap_Invoice_Distributions_All Aid
2412: SET Accounting_Date = l_gl_Date,
2413: Posted_Flag = 'N',
2414: Accrual_Posted_Flag = 'N',
2415: Last_Updated_By = fnd_Global.User_Id,

Line 3328: FROM AP_Invoice_Distributions_All AID

3324: AID.Accounting_Event_ID,
3325: AID.Prepay_Distribution_ID,
3326: AID.Prepay_Tax_Diff_Amount,
3327: AID.Parent_Reversal_ID
3328: FROM AP_Invoice_Distributions_All AID
3329: WHERE Invoice_ID = P_Invoice_ID
3330: AND Line_Type_Lookup_Code = 'PREPAY'
3331: AND Accounting_Event_ID = P_event_id
3332: ORDER BY abs(AID.amount) DESC;

Line 3381: ap_invoice_distributions_all aid

3377: ) write_off_code_combination
3378: FROM ap_payment_hist_dists aphd,
3379: ap_payment_history_all aph,
3380: ap_system_parameters_all asp,
3381: ap_invoice_distributions_all aid
3382: WHERE aphd.accounting_event_id = p_event_id
3383: AND aph.payment_history_id = aphd.payment_history_id
3384: AND aph.org_id = asp.org_id
3385: AND aphd.invoice_distribution_id = aid.invoice_distribution_id

Line 3442: ap_invoice_distributions_all aid

3438: ) write_off_code_combination
3439: FROM ap_prepay_app_dists apad,
3440: ap_prepay_history_all apph,
3441: ap_system_parameters_all asp,
3442: ap_invoice_distributions_all aid
3443: WHERE apad.accounting_event_id = P_Event_Id
3444: AND apad.prepay_history_id = apph.prepay_history_id
3445: AND apph.org_id = asp.org_id
3446: AND apad.invoice_distribution_id = aid.invoice_distribution_id

Line 3746: FROM ap_invoice_distributions_all aid

3742: AND aph_rev.rev_pmt_hist_id IS NOT NULL
3743: )
3744: UNION
3745: SELECT aid.accounting_event_id
3746: FROM ap_invoice_distributions_all aid
3747: WHERE aid.invoice_id = l_invoice_id
3748: AND aid.line_type_lookup_code = 'PREPAY'
3749: AND nvl(aid.reversal_flag, 'N') <> 'Y')
3750: AND EXISTS

Line 4265: FROM ap_invoice_distributions_all aid

4261: AND apph.posted_flag <> 'Y'
4262: AND NOT EXISTS
4263: (
4264: SELECT 'encumbered'
4265: FROM ap_invoice_distributions_all aid
4266: WHERE aid.accounting_event_id = apph.accounting_event_id
4267: AND NVL(aid.encumbered_flag, 'N') = 'Y' --bug11880177,bug12407622
4268: )
4269: AND xe.event_id = apph.accounting_event_id

Line 4432: TYPE Tab_Number IS TABLE OF AP_INVOICE_DISTRIBUTIONS_ALL.INVOICE_DISTRIBUTION_ID%TYPE INDEX BY BINARY_INTEGER;

4428: l_check_ret_stat_col VARCHAR2(1) := 'N';
4429: l_check_process_col VARCHAR2(1) := 'N';
4430: l_sql_stmt LONG;
4431: l_sql_errors NUMBER;
4432: TYPE Tab_Number IS TABLE OF AP_INVOICE_DISTRIBUTIONS_ALL.INVOICE_DISTRIBUTION_ID%TYPE INDEX BY BINARY_INTEGER;
4433: l_inv_dist_id_tab TAB_NUMBER;
4434: l_inv_line_no_tab TAB_NUMBER;
4435: l_acct_event_id_tab TAB_NUMBER;
4436: l_bc_event_id_tab TAB_NUMBER;

Line 4437: TYPE Tab_Char IS TABLE OF AP_INVOICE_DISTRIBUTIONS_ALL.MATCH_STATUS_FLAG%TYPE INDEX BY BINARY_INTEGER;

4433: l_inv_dist_id_tab TAB_NUMBER;
4434: l_inv_line_no_tab TAB_NUMBER;
4435: l_acct_event_id_tab TAB_NUMBER;
4436: l_bc_event_id_tab TAB_NUMBER;
4437: TYPE Tab_Char IS TABLE OF AP_INVOICE_DISTRIBUTIONS_ALL.MATCH_STATUS_FLAG%TYPE INDEX BY BINARY_INTEGER;
4438: l_match_status_flg_tab TAB_CHAR;
4439: l_bug_no VARCHAR2(100);
4440: l_driver_table ALL_TABLES.TABLE_NAME%TYPE;
4441: l_debug_info VARCHAR2(4000);

Line 4496: FROM ap_invoice_distributions_all aid,

4492: aid.invoice_line_number,
4493: aid.accounting_event_id,
4494: aid.bc_event_id,
4495: aid.match_status_flag
4496: FROM ap_invoice_distributions_all aid,
4497: xla_events xe
4498: WHERE xe.application_id = 200
4499: AND aid.accounting_event_id = xe.event_id
4500: AND aid.invoice_id = P_Invoice_ID

Line 4604: ' FROM ap_invoice_distributions_all '||

4600:
4601: l_debug_info := 'Populating the invoice_id column in the driver table';
4602: l_sql_stmt := 'UPDATE '||l_driver_table||' dr '||
4603: ' SET invoice_id = (SELECT DISTINCT invoice_id '||
4604: ' FROM ap_invoice_distributions_all '||
4605: ' WHERE accounting_event_id = nvl(dr.event_id,-99)) ';
4606: EXECUTE IMMEDIATE l_sql_stmt;
4607: ELSE
4608: l_debug_info := 'Either the invoice_id or the event_id column needs to be present in driver table '

Line 4633: ' FROM ap_invoice_distributions_all '||

4629: ' FROM '||l_driver_table||' dr '||
4630: ' WHERE dr.process_flag NOT IN (''N'',''E'') '|| --bug10019343
4631: ' AND EXISTS '||
4632: ' (SELECT ''Prepay Invoice'''||
4633: ' FROM ap_invoice_distributions_all '||
4634: ' WHERE invoice_id = dr.invoice_id '||
4635: ' AND line_type_lookup_code = ''PREPAY'')';
4636:
4637: l_debug_info := 'After the l_sql_stmt, before opening the cursor';

Line 4676: UPDATE ap_invoice_distributions_all aid

4672: CLOSE distributions_cur;
4673:
4674: l_debug_info := 'Updating ap_invoice_distributions';
4675: FORALL j IN l_inv_dist_id_tab.FIRST..l_inv_dist_id_tab.LAST
4676: UPDATE ap_invoice_distributions_all aid
4677: SET aid.accounting_event_id = NULL,
4678: aid.bc_event_id = NULL,
4679: aid.posted_flag = DECODE(aid.posted_flag, 'S', 'N', aid.posted_flag),
4680: aid.match_status_flag = 'S'

Line 4713: ap_invoice_distributions_all aid

4709: AND apph.invoice_line_number = l_inv_line_no_tab(j)
4710: AND NOT EXISTS
4711: (SELECT 1
4712: FROM ap_prepay_app_dists apad,
4713: ap_invoice_distributions_all aid
4714: WHERE apad.prepay_history_id = apph.prepay_history_id
4715: AND apad.prepay_app_distribution_id = aid.invoice_distribution_id
4716: AND (aid.posted_flag = 'Y' OR
4717: aid.encumbered_flag = 'Y')

Line 4747: UPDATE ap_invoice_distributions_all aid

4743: END IF;
4744:
4745: l_debug_info := 'Updating ap_invoice_distributions';
4746: FORALL j IN l_inv_dist_id_tab.FIRST..l_inv_dist_id_tab.LAST
4747: UPDATE ap_invoice_distributions_all aid
4748: SET aid.accounting_event_id = l_acct_event_id_tab(j),
4749: aid.bc_event_id = l_bc_event_id_tab(j),
4750: aid.match_status_flag = l_match_status_flg_tab(j)
4751: WHERE aid.invoice_distribution_id = l_inv_dist_id_tab(j);

Line 5155: ' FROM ap_invoice_distributions_all '||

5151:
5152: l_debug_info := 'Populating the invoice_id column in the driver table';
5153: l_sql_stmt := 'UPDATE '||l_driver_table||' dr '||
5154: ' SET invoice_id = (SELECT DISTINCT invoice_id '||
5155: ' FROM ap_invoice_distributions_all '||
5156: ' WHERE accounting_event_id = nvl(dr.event_id,-99))';
5157: EXECUTE IMMEDIATE l_sql_stmt;
5158:
5159: END IF;

Line 5667: FROM ap_invoice_distributions_all aid

5663: BEGIN
5664: IF( Events_to_Process_tab( i ).budgetary_control_flag = 'Y' ) THEN
5665: SELECT COUNT( 1 )
5666: INTO l_rel_act_acct_event_cnt
5667: FROM ap_invoice_distributions_all aid
5668: , xla_events xe
5669: WHERE aid.invoice_id = p_source_id
5670: AND aid.bc_event_id = Events_to_Process_tab( i ).event_id
5671: AND xe.event_id = aid.accounting_event_id

Line 5774: UPDATE ap_Invoice_Distributions_All Aid

5770: END;
5771:
5772: IF( l_event_status_code = 'U' AND Events_to_Process_tab(i).budgetary_control_flag <> 'Y') THEN
5773: BEGIN
5774: UPDATE ap_Invoice_Distributions_All Aid
5775: SET Accounting_Date = l_gl_Date
5776: , Posted_Flag = 'N'
5777: , Accrual_Posted_Flag = 'N'
5778: , Last_Updated_By = fnd_Global.User_Id

Line 5840: FROM ap_invoice_distributions_all aid

5836: SET fc_status = 'N'
5837: , last_updated_by = fnd_Global.User_Id
5838: WHERE invoice_distribution_id IN
5839: (SELECT aid.invoice_distribution_id
5840: FROM ap_invoice_distributions_all aid
5841: WHERE aid.bc_event_id = events_to_process_tab(i).event_id
5842: AND aid.invoice_id = p_source_id)
5843: AND fc_status = 'A';
5844:

Line 5845: UPDATE ap_invoice_distributions_all aid

5841: WHERE aid.bc_event_id = events_to_process_tab(i).event_id
5842: AND aid.invoice_id = p_source_id)
5843: AND fc_status = 'A';
5844:
5845: UPDATE ap_invoice_distributions_all aid
5846: SET encumbered_flag = 'N'
5847: , bc_event_id = NULL
5848: , match_status_flag = 'T'
5849: , last_updated_by = fnd_Global.User_Id

Line 6060: FROM ap_invoice_distributions_all aid

6056: l_total_prepay_amt NUMBER := -99;
6057: BEGIN
6058: SELECT NVL((SUM(AID.Amount)), 0) --bug12764043, removed ABS
6059: INTO l_total_prepay_amt
6060: FROM ap_invoice_distributions_all aid
6061: WHERE aid.line_type_lookup_code IN ('PREPAY','REC_TAX','NONREC_TAX')
6062: AND aid.prepay_distribution_id IS NOT NULL
6063: AND aid.accounting_event_id = P_Event_ID;
6064: