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

Line 1464: FROM ap_invoice_distributions_all

1460: Print_Debug(l_api_name, l_debug_info);
1461: ----------------------------------------------------------------
1462: SELECT count(*)
1463: INTO l_prepay_dist_count
1464: FROM ap_invoice_distributions_all
1465: WHERE Invoice_ID = l_invoice_id
1466: AND Line_Type_Lookup_Code = 'PREPAY'
1467: AND Accounting_Event_ID IS NULL;
1468:

Line 2071: FROM ap_invoice_distributions_all

2067: IF (p_run_option = 'New') THEN
2068:
2069: SELECT count(*)
2070: INTO l_unapproved_dist_exists
2071: FROM ap_invoice_distributions_all
2072: WHERE invoice_id = p_invoice_id
2073: AND (nvl(match_status_flag, 'N')) = 'N'
2074: AND rownum = 1;
2075:

Line 2084: FROM ap_invoice_distributions_all aid

2080: FROM ap_invoice_lines_all L
2081: WHERE L.invoice_id = p_invoice_id
2082: AND L.amount <>
2083: (SELECT NVL(SUM(NVL(aid.amount,0)),0)
2084: FROM ap_invoice_distributions_all aid
2085: WHERE aid.invoice_id = L.invoice_id
2086: AND aid.invoice_line_number = L.line_number);
2087: END;
2088:

Line 2157: UPDATE ap_invoice_distributions_all D

2153:
2154: l_debug_info := 'Run Option: New: Set new distribution flag to S';
2155: Print_Debug (l_debug_loc,l_debug_info);
2156:
2157: UPDATE ap_invoice_distributions_all D
2158: SET match_status_flag = 'S'
2159: WHERE NVL(match_status_flag, 'N') = 'N'
2160: AND D.invoice_id = p_invoice_id
2161: AND D.invoice_line_number = p_line_number;

Line 2177: UPDATE ap_invoice_distributions_all D

2173:
2174: l_debug_info := 'Run Option: All: Set new distribution flag to S';
2175: Print_Debug (l_debug_loc,l_debug_info);
2176:
2177: UPDATE ap_invoice_distributions_all D
2178: SET match_status_flag = 'S'
2179: WHERE NVL(match_status_flag, '!') <> 'A'
2180: AND D.invoice_id = p_invoice_id;
2181:

Line 2984: l_ccid AP_INVOICE_DISTRIBUTIONS_ALL.dist_code_combination_id%TYPE;

2980: AND c_acct_date BETWEEN NVL(a.start_date_active, c_acct_date)
2981: AND NVL(a.end_date_active, c_acct_date)
2982: );
2983:
2984: l_ccid AP_INVOICE_DISTRIBUTIONS_ALL.dist_code_combination_id%TYPE;
2985: l_accounting_date AP_INVOICE_DISTRIBUTIONS_ALL.accounting_date%TYPE;
2986: l_alt_exists VARCHAR2(50) := 'N';
2987: l_invalid_dist_ccid_exists VARCHAR2(1) := 'N';
2988: l_test_var VARCHAR2(50);

Line 2985: l_accounting_date AP_INVOICE_DISTRIBUTIONS_ALL.accounting_date%TYPE;

2981: AND NVL(a.end_date_active, c_acct_date)
2982: );
2983:
2984: l_ccid AP_INVOICE_DISTRIBUTIONS_ALL.dist_code_combination_id%TYPE;
2985: l_accounting_date AP_INVOICE_DISTRIBUTIONS_ALL.accounting_date%TYPE;
2986: l_alt_exists VARCHAR2(50) := 'N';
2987: l_invalid_dist_ccid_exists VARCHAR2(1) := 'N';
2988: l_test_var VARCHAR2(50);
2989: l_debug_loc VARCHAR2(30) := 'Check_Invalid_Dist';

Line 3117: -- AP_INVOICE_DISTRIBUTIONS_ALL and

3113:
3114: CURSOR PO_Required_Cur IS
3115: -- Perf bug 5058995
3116: -- Modify below SQL to go to base tables : AP_INVOICES_ALL,
3117: -- AP_INVOICE_DISTRIBUTIONS_ALL and
3118: -- AP_SUPPLIER_SITES(instead of po_vendor_sites)
3119: /* Added the Hint index(apd AP_INVOICE_DISTRIBUTIONS_U1) for bug#7270053 */
3120: SELECT 'PO REQUIRED'
3121: FROM ap_invoices_all api, ap_supplier_sites pov

Line 3123: from ap_invoice_distributions_all apd

3119: /* Added the Hint index(apd AP_INVOICE_DISTRIBUTIONS_U1) for bug#7270053 */
3120: SELECT 'PO REQUIRED'
3121: FROM ap_invoices_all api, ap_supplier_sites pov
3122: WHERE EXISTS (select /*+ index(apd AP_INVOICE_DISTRIBUTIONS_U1) */ 'X'
3123: from ap_invoice_distributions_all apd
3124: where apd.invoice_id = api.invoice_id
3125: and apd.line_type_lookup_code in ( 'ITEM', 'ACCRUAL')
3126: and apd.po_distribution_id is null
3127: and apd.pa_addition_flag <> 'T'

Line 3324: FROM ap_invoice_lines_all AIL, ap_invoice_distributions_all D

3320: SELECT 'Distribution needs to be verified. '
3321: FROM DUAL
3322: WHERE EXISTS (
3323: SELECT 'Dist Total <> Invoice Line Amount'
3324: FROM ap_invoice_lines_all AIL, ap_invoice_distributions_all D
3325: -- WHERE AIL.invoice_id = D.invoice_id
3326: WHERE AIL.invoice_id = D.invoice_id(+)
3327: AND AIL.line_number = nvl(p_invoice_line_number, AIL.line_number) --bug6661773
3328: AND AIL.invoice_id = p_invoice_id

Line 3376: FROM ap_invoice_distributions_all aid

3372: FROM ap_invoices_all ai
3373: WHERE ai.invoice_id = p_invoice_id;
3374:
3375: SELECT count(*) INTO l_dist_count
3376: FROM ap_invoice_distributions_all aid
3377: WHERE aid.invoice_id = p_invoice_id
3378: AND ((aid.line_type_lookup_code <> 'PREPAY'
3379: AND aid.prepay_tax_parent_id IS NULL)
3380: OR nvl(invoice_includes_prepay_flag,'N') = 'Y')

Line 3681: FROM ap_invoice_distributions_all D

3677: AIL.last_update_login = FND_GLOBAL.login_id
3678: WHERE AIL.invoice_id = p_invoice_id
3679: -- Bug 6621883
3680: AND (EXISTS ( SELECT 'NOT POSTED'
3681: FROM ap_invoice_distributions_all D
3682: WHERE D.invoice_id = AIL.invoice_id
3683: AND D.invoice_line_number = AIL.line_number
3684: AND NVL(D.posted_flag, 'N') = 'N' )
3685: OR NOT EXISTS (SELECT 'DIST DOES NOT EXIST'

Line 3686: FROM ap_invoice_distributions_all D1

3682: WHERE D.invoice_id = AIL.invoice_id
3683: AND D.invoice_line_number = AIL.line_number
3684: AND NVL(D.posted_flag, 'N') = 'N' )
3685: OR NOT EXISTS (SELECT 'DIST DOES NOT EXIST'
3686: FROM ap_invoice_distributions_all D1
3687: WHERE D1.invoice_id = AIL.invoice_id
3688: AND D1.invoice_line_number = AIL.line_number
3689: AND AIL.amount IS NOT NULL
3690: )

Line 4297: FROM ap_invoice_distributions_all aid, ap_invoice_lines_all ail

4293: -- in the invoice
4294: CURSOR c_non_awt_dists_segs is
4295: SELECT ap_utilities_pkg.get_auto_offsets_segments(
4296: aid.dist_code_combination_id)
4297: FROM ap_invoice_distributions_all aid, ap_invoice_lines_all ail
4298: WHERE ail.invoice_id = p_invoice_id
4299: AND ail.invoice_id = aid.invoice_id
4300: AND ail.line_number = aid.invoice_line_number
4301: AND ((aid.line_type_lookup_code not in ('AWT','PREPAY')

Line 4502: -- AP_INVOICE_DISTRIBUTIONS_ALL

4498: -- invoice has no manual withholding lines --
4499: ------------------------------------------------------------------------
4500: -- Perf bug 5058995
4501: -- Modify below SQL to go to base tables : AP_INVOICES_ALL and
4502: -- AP_INVOICE_DISTRIBUTIONS_ALL
4503: SELECT 'OK to call Withholding Routine',
4504: (AI.invoice_amount * NVL(AI.exchange_rate, 1)),
4505: AI.invoice_num
4506: INTO l_ok_to_withhold,

Line 4512: FROM ap_invoice_distributions_all AID1

4508: l_invoice_num
4509: FROM ap_invoices_all AI
4510: WHERE AI.invoice_id = p_invoice_id
4511: AND EXISTS (SELECT 'At least 1 dist has an AWT Group'
4512: FROM ap_invoice_distributions_all AID1
4513: WHERE AID1.invoice_id = AI.invoice_id
4514: AND AID1.awt_group_id IS NOT NULL)
4515: AND NOT EXISTS (SELECT 'Unreleased System holds exist'
4516: FROM ap_holds AH,

Line 4524: FROM ap_invoice_distributions_all AID

4520: AND AH.hold_lookup_code <> 'AWT ERROR'
4521: AND AH.hold_lookup_code = AHC.hold_lookup_code
4522: AND AHC.user_releaseable_flag = 'N')
4523: AND NOT EXISTS (SELECT 'Manual AWT lines exist'
4524: FROM ap_invoice_distributions_all AID
4525: WHERE AID.invoice_id = AI.invoice_id
4526: AND AID.line_type_lookup_code = 'AWT'
4527: AND AID.awt_flag IN ('M', 'O'));
4528:

Line 4580: -- AP_INVOICE_DISTRIBUTIONS_ALL

4576: ------------------------------------------------------------------------
4577:
4578: -- Perf bug 5058995
4579: -- Modify below SQL to go to base tables : AP_INVOICES_ALL and
4580: -- AP_INVOICE_DISTRIBUTIONS_ALL
4581: SELECT 'OK to call Withholding Routine',
4582: (AI.invoice_amount * NVL(AI.exchange_rate,1)),
4583: AI.invoice_num
4584: INTO l_ok_to_withhold,

Line 4598: FROM ap_invoice_distributions_all AID

4594: AND AH.hold_lookup_code <> 'AWT ERROR'
4595: AND AH.hold_lookup_code = AHC.hold_lookup_code
4596: AND AHC.user_releaseable_flag = 'N')
4597: AND NOT EXISTS (SELECT 'Manual AWT lines exist'
4598: FROM ap_invoice_distributions_all AID
4599: WHERE AID.invoice_id = AI.invoice_id
4600: AND AID.line_type_lookup_code = 'AWT'
4601: AND AID.awt_flag IN ('M', 'O'));
4602:

Line 5742: UPDATE ap_invoice_distributions_all id1

5738: -------------------------------------------
5739:
5740: -- Fix for Bug #5107865. Replaced bulk update with single update for
5741: -- performance reasons.
5742: UPDATE ap_invoice_distributions_all id1
5743: SET (id1.total_dist_amount,
5744: id1.total_dist_base_amount) = (SELECT SUM(NVL(id2.amount,0)),
5745: SUM(NVL(id2.base_amount,0))
5746: FROM ap_invoice_distributions_all id2

Line 5746: FROM ap_invoice_distributions_all id2

5742: UPDATE ap_invoice_distributions_all id1
5743: SET (id1.total_dist_amount,
5744: id1.total_dist_base_amount) = (SELECT SUM(NVL(id2.amount,0)),
5745: SUM(NVL(id2.base_amount,0))
5746: FROM ap_invoice_distributions_all id2
5747: WHERE id2.invoice_distribution_id =
5748: id1.invoice_distribution_id
5749: OR id2.related_id =
5750: id1.invoice_distribution_id)

Line 6001: FROM ap_invoice_lines_all ail,ap_invoice_distributions_all aid

5997: --bugfix:5638734
5998: -- Get the exculusive tax amount for the prepay appln line.
5999: SELECT sum(aid.amount)
6000: INTO l_prepay_excl_tax_amt
6001: FROM ap_invoice_lines_all ail,ap_invoice_distributions_all aid
6002: WHERE ail.line_type_lookup_code='TAX'
6003: AND ail.invoice_id=p_invoice_id
6004: AND aid.invoice_id=ail.invoice_id
6005: AND aid.invoice_line_number=ail.line_number

Line 6067: FROM ap_invoice_distributions_all

6063: SELECT sum(nvl(amount,0)),
6064: sum(nvl(base_amount,0))
6065: INTO l_tmp_invoice_amount,
6066: l_tmp_base_amount
6067: FROM ap_invoice_distributions_all
6068: WHERE invoice_id = p_invoice_id
6069: AND ((line_type_lookup_code NOT IN ('PREPAY', 'AWT')
6070: AND prepay_distribution_id IS NULL)
6071: OR nvl(invoice_includes_prepay_flag,'N') = 'Y');

Line 6765: TYPE Invoice_Dists_Tab_Type IS TABLE OF ap_invoice_distributions_all%ROWTYPE;

6761:
6762: l_debug_info VARCHAR2(1000);
6763: l_curr_calling_sequence VARCHAR2(2000);
6764:
6765: TYPE Invoice_Dists_Tab_Type IS TABLE OF ap_invoice_distributions_all%ROWTYPE;
6766: l_dist_tab Invoice_Dists_Tab_Type := Invoice_Dists_Tab_Type();
6767:
6768: TYPE Expense_Report_Dists_Rec IS RECORD (
6769: Org_id ap_exp_report_dists_all.org_id%TYPE,

Line 7467: ' FROM AP_INVOICE_DISTRIBUTIONS_ALL D2 '||

7463: ' (AI.FORCE_REVALIDATION_FLAG = ''Y'')'||
7464: ' ) '||
7465: ' AND NOT EXISTS '||
7466: ' (SELECT ''Cancelled distributions'' '||
7467: ' FROM AP_INVOICE_DISTRIBUTIONS_ALL D2 '||
7468: ' WHERE D2.INVOICE_ID = AI.INVOICE_ID '||
7469: ' AND D2.CANCELLATION_FLAG = ''Y'''||
7470: ' )'||
7471: ' ) '||

Line 7482: ' FROM AP_INVOICE_DISTRIBUTIONS_ALL D5 '||

7478: ' AND NVL(AIL.CANCELLED_FLAG, ''N'') <> ''Y'' '||
7479: ' AND NOT EXISTS '||
7480: ' (SELECT /*+ NO_UNNEST */ '||
7481: ' ''distributed line'' '||
7482: ' FROM AP_INVOICE_DISTRIBUTIONS_ALL D5 '||
7483: ' WHERE D5.INVOICE_ID = AIL.INVOICE_ID '||
7484: ' AND D5.INVOICE_LINE_NUMBER = AIL.LINE_NUMBER))) ' ;
7485: IF P_org_id IS NOT NULL THEN
7486: l_sql_stmt := l_sql_stmt|| 'AND AI.org_id = ' || l_org_id || ' ' ;