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_INVOICE_DISTRIBUTIONS_PKG dependencies on AP_INVOICE_DISTRIBUTIONS_ALL

Line 255: FROM ap_invoice_distributions_all aid,

251: --Bug4539547 Added IF statement
252: If (X_LINE_NUMBER is null) then
253: SELECT NVL(SUM(aid.amount), 0)
254: INTO X_Total
255: FROM ap_invoice_distributions_all aid,
256: ap_invoice_lines_all ail
257: WHERE ail.invoice_id = X_Invoice_Id
258: AND ail.invoice_id = aid.invoice_id
259: AND ail.line_number = aid.invoice_line_number

Line 268: FROM ap_invoice_distributions_all aid,

264: OR NVL(ail.invoice_includes_prepay_flag,'N') = 'Y');
265: else
266: SELECT NVL(SUM(aid.amount), 0)
267: INTO X_Total
268: FROM ap_invoice_distributions_all aid,
269: ap_invoice_lines_all ail
270: WHERE ail.invoice_id = X_Invoice_Id
271: AND ail.invoice_id = aid.invoice_id
272: AND ail.line_number = aid.invoice_line_number

Line 1519: --to ap_invoice_distributions_all

1515: -- Set the exchange rate info, base amount and WHO columns
1516: -- for the distributions
1517:
1518: --Bugfix:4644053 changed ap_invoice_distributions
1519: --to ap_invoice_distributions_all
1520: debug_info := 'Update AP_INVOICE_DISTRIBUTIONS base amounts';
1521:
1522: UPDATE AP_INVOICE_DISTRIBUTIONS_ALL
1523: SET base_amount =

Line 1522: UPDATE AP_INVOICE_DISTRIBUTIONS_ALL

1518: --Bugfix:4644053 changed ap_invoice_distributions
1519: --to ap_invoice_distributions_all
1520: debug_info := 'Update AP_INVOICE_DISTRIBUTIONS base amounts';
1521:
1522: UPDATE AP_INVOICE_DISTRIBUTIONS_ALL
1523: SET base_amount =
1524: DECODE(l_base_currency_code,
1525: l_invoice_currency_code, NULL,
1526: ap_utilities_pkg.ap_round_currency(

Line 3586: FROM ap_invoice_distributions_all d5

3582: WHERE d1.invoice_id = X_Invoice_Id
3583: AND d1.posted_flag = 'N'
3584: AND (d1.invoice_id, d1.distribution_line_number) IN
3585: (SELECT d5.invoice_id, MAX(d5.distribution_line_number)
3586: FROM ap_invoice_distributions_all d5
3587: WHERE (d5.invoice_id, abs(d5.amount)) IN
3588: (SELECT i1.invoice_id , MAX(ABS(d3.amount))
3589: FROM ap_invoices_all i1, ap_invoice_distributions_all d3
3590: WHERE i1.invoice_id = X_Invoice_Id

Line 3589: FROM ap_invoices_all i1, ap_invoice_distributions_all d3

3585: (SELECT d5.invoice_id, MAX(d5.distribution_line_number)
3586: FROM ap_invoice_distributions_all d5
3587: WHERE (d5.invoice_id, abs(d5.amount)) IN
3588: (SELECT i1.invoice_id , MAX(ABS(d3.amount))
3589: FROM ap_invoices_all i1, ap_invoice_distributions_all d3
3590: WHERE i1.invoice_id = X_Invoice_Id
3591: AND i1.invoice_id = d3.invoice_id
3592: AND d3.line_type_lookup_code <> 'TAX'
3593: AND NOT EXISTS

Line 3595: FROM ap_invoice_distributions_all d4

3591: AND i1.invoice_id = d3.invoice_id
3592: AND d3.line_type_lookup_code <> 'TAX'
3593: AND NOT EXISTS
3594: (SELECT d4.invoice_id
3595: FROM ap_invoice_distributions_all d4
3596: WHERE d4.invoice_id = X_Invoice_Id
3597: AND (1 = DECODE(X_Base_Currency_Code,
3598: i1.invoice_currency_code,1,
3599: DECODE(d4.exchange_rate,null,1,0))

Line 5277: AP_invoice_distributions_all AID

5273: ARL.percentage,
5274: ARL.amount,
5275: Sum(AID.amount)
5276: FROM AP_Allocation_Rule_Lines ARL,
5277: AP_invoice_distributions_all AID
5278: WHERE ARL.invoice_id = X_invoice_id
5279: AND AID.invoice_id = X_invoice_id
5280: AND ARL.chrg_invoice_line_number = X_line_number
5281: AND AID.invoice_line_number = ARL.to_invoice_line_number

Line 5294: AP_invoice_distributions_all AID

5290: SELECT AIL.line_number,
5291: AIL.amount,
5292: sum(AID.amount)
5293: FROM AP_invoice_lines AIL,
5294: AP_invoice_distributions_all AID
5295: WHERE AIL.invoice_id = X_invoice_id
5296: AND nvl(AIL.discarded_flag, 'N') = 'N'
5297: AND nvl(AIL.cancelled_flag, 'N') = 'N'
5298: AND AIL.amount <> 0

Line 5326: FROM ap_invoice_distributions_all AID

5322: AID.assets_tracking_flag,
5323: AID.asset_book_type_code,
5324: AID.asset_category_id,
5325: AID.description
5326: FROM ap_invoice_distributions_all AID
5327: WHERE AID.invoice_id = X_invoice_id
5328: AND AID.invoice_line_number = P_line_number
5329: AND AID.line_type_lookup_code in ('ITEM', 'ACCRUAL')
5330: ORDER BY AID.distribution_line_number;

Line 5670: FROM ap_invoice_distributions_all AID

5666: ('PRICE_CORRECTION', 'QTY_CORRECTION','LINE_CORRECTION','AMOUNT_CORRECTION')
5667: --Bug 5558693
5668: AND amount <>
5669: (SELECT NVL(SUM(NVL(aid.amount,0)),0)
5670: FROM ap_invoice_distributions_all AID
5671: WHERE AID.invoice_id = ail.invoice_id
5672: AND AID.invoice_line_number = AIL.line_number
5673: AND (AID.line_type_lookup_code NOT IN ('RETAINAGE','PREPAY')
5674: OR (AID.prepay_distribution_id IS NOT NULL

Line 6563: ap_invoice_distributions_all aid

6559: AND chrg_invoice_line_number = X_line_number
6560: AND exists
6561: (select 'Line Amount Equals Distribution Total'
6562: from ap_invoice_lines_all ail,
6563: ap_invoice_distributions_all aid
6564: where ail.invoice_id = aid.invoice_id
6565: and ail.line_number = aid.invoice_line_number
6566: and ail.invoice_id = X_invoice_id
6567: and ail.line_number = X_line_number

Line 6607: FROM ap_invoice_distributions_all AID

6603: BEGIN
6604:
6605: SELECT sum(nvl(AID.amount,0))
6606: INTO l_original_amount
6607: FROM ap_invoice_distributions_all AID
6608: WHERE AID.invoice_distribution_id = X_invoice_distribution_id
6609: OR AID.related_id = X_invoice_distribution_id;
6610:
6611:

Line 7179: debug_info := 'Select from ap_invoice_distributions_all';

7175: current_calling_sequence :=
7176: 'AP_INVOICE_DISTRIBUTIONS_PKG.DIST_REFER_ACTIVE_CORR<-'
7177: ||p_Calling_Sequence;
7178:
7179: debug_info := 'Select from ap_invoice_distributions_all';
7180:
7181: Select count(*)
7182: Into dummy
7183: From ap_invoice_distributions_all AID

Line 7183: From ap_invoice_distributions_all AID

7179: debug_info := 'Select from ap_invoice_distributions_all';
7180:
7181: Select count(*)
7182: Into dummy
7183: From ap_invoice_distributions_all AID
7184: Where NVL(AID.cancellation_flag, 'N' ) <> 'Y'
7185: And NVL( AID.reversal_flag, 'N' ) <> 'Y'
7186: And AID.corrected_invoice_dist_id = p_invoice_dist_id
7187: And rownum < 2; --bug 5034678

Line 7241: debug_info := 'Select from ap_invoice_distributions_all';

7237: current_calling_sequence :=
7238: 'AP_INVOICE_DISTRIBUTIONS_PKG.CHRG_REFER_ACTIVE_DIST<-'
7239: ||p_Calling_Sequence;
7240:
7241: debug_info := 'Select from ap_invoice_distributions_all';
7242:
7243: Select count(*)
7244: Into dummy
7245: From ap_invoice_distributions_all AID

Line 7245: From ap_invoice_distributions_all AID

7241: debug_info := 'Select from ap_invoice_distributions_all';
7242:
7243: Select count(*)
7244: Into dummy
7245: From ap_invoice_distributions_all AID
7246: Where AID.charge_applicable_to_dist_id = p_invoice_dist_id
7247: And NVL(AID.cancellation_flag, 'N') <> 'Y'
7248: And NVL(AID.reversal_flag, 'N') <> 'Y';
7249:

Line 7290: UPDATE ap_invoice_distributions_all

7286: ||p_calling_sequence;
7287:
7288: l_debug_info := 'Updating ap_invoice_distributions';
7289:
7290: UPDATE ap_invoice_distributions_all
7291: SET distribution_class = 'PERMANENT'
7292: WHERE invoice_id = p_invoice_id
7293: AND invoice_line_number = NVL(p_invoice_line_number, invoice_line_number)
7294: AND distribution_class = 'CANDIDATE'

Line 7319: FROM ap_invoice_distributions_all aid

7315: AND ail.line_number = l_line_number_tab(uniq_values);
7316:
7317: --Commented below condition for the bug 7483192
7318: /*AND ail.amount = (SELECT SUM(NVL(aid.amount,0))
7319: FROM ap_invoice_distributions_all aid
7320: WHERE aid.invoice_id = ail.invoice_id
7321: AND aid.invoice_line_number = ail.line_number
7322: AND aid.distribution_class = 'PERMANENT'); */
7323: