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 2006: FROM ap_invoice_distributions_all

2002: -- the Prepayment Application Distributions (APAD)
2003: --
2004: SELECT count(*)
2005: INTO l_prepay_dist_count
2006: FROM ap_invoice_distributions_all
2007: WHERE Invoice_ID = l_invoice_id
2008: AND Line_Type_Lookup_Code = 'PREPAY'
2009: --AND Accounting_Event_ID IS NULL;
2010: AND NVL(Posted_Flag, 'N') <> 'Y'

Line 2140: FROM AP_INVOICE_DISTRIBUTIONS_ALL aid,

2136: INTO l_lcm_used
2137: FROM DUAL
2138: WHERE EXISTS
2139: (SELECT 1
2140: FROM AP_INVOICE_DISTRIBUTIONS_ALL aid,
2141: RCV_TRANSACTIONS rt
2142: WHERE aid.invoice_id = l_invoice_id
2143: AND aid.rcv_transaction_id = rt.transaction_id
2144: AND rt.lcm_shipment_line_id IS NOT NULL

Line 2150: FROM AP_INVOICE_DISTRIBUTIONS_ALL aid,

2146:
2147: UNION ALL
2148:
2149: SELECT 1
2150: FROM AP_INVOICE_DISTRIBUTIONS_ALL aid,
2151: RCV_TRANSACTIONS rt,
2152: AP_INVOICE_DISTRIBUTIONS_ALL aid2
2153: WHERE aid.invoice_id = l_invoice_id
2154: AND aid.corrected_invoice_dist_id = aid2.invoice_distribution_id

Line 2152: AP_INVOICE_DISTRIBUTIONS_ALL aid2

2148:
2149: SELECT 1
2150: FROM AP_INVOICE_DISTRIBUTIONS_ALL aid,
2151: RCV_TRANSACTIONS rt,
2152: AP_INVOICE_DISTRIBUTIONS_ALL aid2
2153: WHERE aid.invoice_id = l_invoice_id
2154: AND aid.corrected_invoice_dist_id = aid2.invoice_distribution_id
2155: AND aid2.rcv_transaction_id = rt.transaction_id
2156: AND rt.lcm_shipment_line_id IS NOT NULL

Line 2877: FROM ap_invoice_distributions_all

2873: IF (p_run_option = 'New') THEN
2874:
2875: SELECT count(*)
2876: INTO l_unapproved_dist_exists
2877: FROM ap_invoice_distributions_all
2878: WHERE invoice_id = p_invoice_id
2879: AND (nvl(match_status_flag, 'N')) = 'N'
2880: AND rownum = 1;
2881:

Line 2890: FROM ap_invoice_distributions_all aid

2886: FROM ap_invoice_lines_all L
2887: WHERE L.invoice_id = p_invoice_id
2888: AND L.amount <>
2889: (SELECT NVL(SUM(NVL(aid.amount,0)),0)
2890: FROM ap_invoice_distributions_all aid
2891: WHERE aid.invoice_id = L.invoice_id
2892: AND aid.invoice_line_number = L.line_number);
2893: END;
2894:

Line 2977: UPDATE ap_invoice_distributions_all D

2973: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2974: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_debug_loc,l_debug_info);
2975: END IF;
2976:
2977: UPDATE ap_invoice_distributions_all D
2978: SET match_status_flag = 'S'
2979: WHERE NVL(match_status_flag, 'N') = 'N'
2980: AND NVL(D.posted_flag, 'N' ) = 'N' -- Bug 9777752
2981: AND D.invoice_id = p_invoice_id

Line 3006: UPDATE ap_invoice_distributions_all D

3002: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
3003: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_debug_loc,l_debug_info);
3004: END IF;
3005:
3006: UPDATE ap_invoice_distributions_all D
3007: SET match_status_flag = 'S'
3008: WHERE NVL(match_status_flag, '!') <> 'A'
3009: AND NVL(D.posted_flag, 'N' ) = 'N' -- Bug 9777752
3010: AND D.invoice_id = p_invoice_id;

Line 4087: l_ccid AP_INVOICE_DISTRIBUTIONS_ALL.dist_code_combination_id%TYPE;

4083: AND c_acct_date BETWEEN NVL(a.start_date_active, c_acct_date)
4084: AND NVL(a.end_date_active, c_acct_date)
4085: );
4086:
4087: l_ccid AP_INVOICE_DISTRIBUTIONS_ALL.dist_code_combination_id%TYPE;
4088: l_accounting_date AP_INVOICE_DISTRIBUTIONS_ALL.accounting_date%TYPE;
4089: l_alt_exists VARCHAR2(50) := 'N';
4090: l_invalid_dist_ccid_exists VARCHAR2(1) := 'N';
4091: l_test_var VARCHAR2(50);

Line 4088: l_accounting_date AP_INVOICE_DISTRIBUTIONS_ALL.accounting_date%TYPE;

4084: AND NVL(a.end_date_active, c_acct_date)
4085: );
4086:
4087: l_ccid AP_INVOICE_DISTRIBUTIONS_ALL.dist_code_combination_id%TYPE;
4088: l_accounting_date AP_INVOICE_DISTRIBUTIONS_ALL.accounting_date%TYPE;
4089: l_alt_exists VARCHAR2(50) := 'N';
4090: l_invalid_dist_ccid_exists VARCHAR2(1) := 'N';
4091: l_test_var VARCHAR2(50);
4092: l_debug_loc VARCHAR2(30) := 'Check_Invalid_Dist';

Line 4220: -- AP_INVOICE_DISTRIBUTIONS_ALL and

4216:
4217: CURSOR PO_Required_Cur IS
4218: -- Perf bug 5058995
4219: -- Modify below SQL to go to base tables : AP_INVOICES_ALL,
4220: -- AP_INVOICE_DISTRIBUTIONS_ALL and
4221: -- AP_SUPPLIER_SITES(instead of po_vendor_sites)
4222: /* Added the Hint index(apd AP_INVOICE_DISTRIBUTIONS_U1) for bug#7270053 */
4223: SELECT 'PO REQUIRED'
4224: FROM ap_invoices_all api, ap_supplier_sites pov

Line 4226: from ap_invoice_distributions_all apd

4222: /* Added the Hint index(apd AP_INVOICE_DISTRIBUTIONS_U1) for bug#7270053 */
4223: SELECT 'PO REQUIRED'
4224: FROM ap_invoices_all api, ap_supplier_sites pov
4225: WHERE EXISTS (select /*+ index(apd AP_INVOICE_DISTRIBUTIONS_U1) */ 'X'
4226: from ap_invoice_distributions_all apd
4227: where apd.invoice_id = api.invoice_id
4228: and apd.line_type_lookup_code in ( 'ITEM', 'ACCRUAL')
4229: and apd.po_distribution_id is null
4230: and apd.pa_addition_flag <> 'T'

Line 4550: FROM ap_invoice_lines_all AIL, ap_invoice_distributions_all D

4546: SELECT 'Distribution needs to be verified. '
4547: FROM DUAL
4548: WHERE EXISTS (
4549: SELECT 'Dist Total <> Invoice Line Amount'
4550: FROM ap_invoice_lines_all AIL, ap_invoice_distributions_all D
4551: -- WHERE AIL.invoice_id = D.invoice_id
4552: WHERE AIL.invoice_id = D.invoice_id(+)
4553: AND AIL.line_number = nvl(p_invoice_line_number, AIL.line_number) --bug6661773
4554: AND AIL.invoice_id = p_invoice_id

Line 4602: FROM ap_invoice_distributions_all aid

4598: FROM ap_invoices_all ai
4599: WHERE ai.invoice_id = p_invoice_id;
4600:
4601: SELECT count(*) INTO l_dist_count
4602: FROM ap_invoice_distributions_all aid
4603: WHERE aid.invoice_id = p_invoice_id
4604: AND ((aid.line_type_lookup_code <> 'PREPAY'
4605: AND aid.prepay_tax_parent_id IS NULL)
4606: OR nvl(invoice_includes_prepay_flag,'N') = 'Y')

Line 5079: FROM ap_invoice_distributions_all D

5075: WHERE AIL.invoice_id = p_invoice_id
5076: AND AIL.LINE_TYPE_LOOKUP_CODE not in ('TAX', 'AWT') -- bug 9582952 --bug16090813
5077: -- Bug 6621883
5078: AND (EXISTS ( SELECT 'NOT POSTED'
5079: FROM ap_invoice_distributions_all D
5080: WHERE D.invoice_id = AIL.invoice_id
5081: AND D.invoice_line_number = AIL.line_number
5082: AND NVL(D.posted_flag, 'N') = 'N' )
5083: OR NOT EXISTS (SELECT 'DIST DOES NOT EXIST'

Line 5084: FROM ap_invoice_distributions_all D1

5080: WHERE D.invoice_id = AIL.invoice_id
5081: AND D.invoice_line_number = AIL.line_number
5082: AND NVL(D.posted_flag, 'N') = 'N' )
5083: OR NOT EXISTS (SELECT 'DIST DOES NOT EXIST'
5084: FROM ap_invoice_distributions_all D1
5085: WHERE D1.invoice_id = AIL.invoice_id
5086: AND D1.invoice_line_number = AIL.line_number
5087: AND AIL.amount IS NOT NULL
5088: )

Line 5799: FROM ap_invoice_distributions_all aid, ap_invoice_lines_all ail

5795: -- in the invoice
5796: CURSOR c_non_awt_dists_segs is
5797: SELECT ap_utilities_pkg.get_auto_offsets_segments(
5798: aid.dist_code_combination_id)
5799: FROM ap_invoice_distributions_all aid, ap_invoice_lines_all ail
5800: WHERE ail.invoice_id = p_invoice_id
5801: AND ail.invoice_id = aid.invoice_id
5802: AND ail.line_number = aid.invoice_line_number
5803: AND ((aid.line_type_lookup_code not in ('AWT','PREPAY')

Line 6009: -- AP_INVOICE_DISTRIBUTIONS_ALL

6005: -- invoice has no manual withholding lines --
6006: ------------------------------------------------------------------------
6007: -- Perf bug 5058995
6008: -- Modify below SQL to go to base tables : AP_INVOICES_ALL and
6009: -- AP_INVOICE_DISTRIBUTIONS_ALL
6010: SELECT 'OK to call Withholding Routine',
6011: (AI.invoice_amount * NVL(AI.exchange_rate, 1)),
6012: AI.invoice_num
6013: INTO l_ok_to_withhold,

Line 6019: FROM ap_invoice_distributions_all AID1

6015: l_invoice_num
6016: FROM ap_invoices_all AI
6017: WHERE AI.invoice_id = p_invoice_id
6018: AND EXISTS (SELECT 'At least 1 dist has an AWT Group'
6019: FROM ap_invoice_distributions_all AID1
6020: WHERE AID1.invoice_id = AI.invoice_id
6021: AND AID1.awt_group_id IS NOT NULL)
6022: AND NOT EXISTS (SELECT 'Unreleased System holds exist'
6023: FROM ap_holds AH,

Line 6031: FROM ap_invoice_distributions_all AID

6027: AND AH.hold_lookup_code <> 'AWT ERROR'
6028: AND AH.hold_lookup_code = AHC.hold_lookup_code
6029: AND AHC.user_releaseable_flag = 'N')
6030: AND NOT EXISTS (SELECT 'Manual AWT lines exist'
6031: FROM ap_invoice_distributions_all AID
6032: WHERE AID.invoice_id = AI.invoice_id
6033: AND AID.line_type_lookup_code = 'AWT'
6034: AND AID.awt_flag IN ('M', 'O'));
6035:

Line 6103: -- AP_INVOICE_DISTRIBUTIONS_ALL

6099: ------------------------------------------------------------------------
6100:
6101: -- Perf bug 5058995
6102: -- Modify below SQL to go to base tables : AP_INVOICES_ALL and
6103: -- AP_INVOICE_DISTRIBUTIONS_ALL
6104: SELECT 'OK to call Withholding Routine',
6105: (AI.invoice_amount * NVL(AI.exchange_rate,1)),
6106: AI.invoice_num
6107: INTO l_ok_to_withhold,

Line 6121: FROM ap_invoice_distributions_all AID

6117: AND AH.hold_lookup_code <> 'AWT ERROR'
6118: AND AH.hold_lookup_code = AHC.hold_lookup_code
6119: AND AHC.user_releaseable_flag = 'N')
6120: AND NOT EXISTS (SELECT 'Manual AWT lines exist'
6121: FROM ap_invoice_distributions_all AID
6122: WHERE AID.invoice_id = AI.invoice_id
6123: AND AID.line_type_lookup_code = 'AWT'
6124: AND AID.awt_flag IN ('M', 'O'));
6125:

Line 6261: UPDATE ap_invoice_distributions_all D

6257: END IF;
6258: ------------------------------------------------------------
6259: --Used the base table insead of secured synonym bug 10171820
6260:
6261: UPDATE ap_invoice_distributions_all D
6262: SET match_status_flag = 'T',
6263: last_update_date = SYSDATE,
6264: last_updated_by = p_user_id,
6265: program_application_id = decode(fnd_global.prog_appl_id,

Line 6318: UPDATE ap_invoice_distributions_all D

6314:
6315: -- BUG 4340061
6316: -- For the AWT lines we have encumbered_flag set to N in invoice-dist.
6317: --Used the base table insead of secured synonym bug 10171820
6318: UPDATE ap_invoice_distributions_all D
6319: SET match_status_flag = 'A',
6320: packet_id = ''
6321: WHERE match_status_flag = 'T'
6322: AND D.invoice_id = p_invoice_id

Line 7638: UPDATE ap_invoice_distributions_all id1

7634: -------------------------------------------
7635:
7636: -- Fix for Bug #5107865. Replaced bulk update with single update for
7637: -- performance reasons.
7638: UPDATE ap_invoice_distributions_all id1
7639: SET (id1.total_dist_amount,
7640: id1.total_dist_base_amount) = (SELECT SUM(NVL(id2.amount,0)),
7641: SUM(NVL(id2.base_amount,0))
7642: FROM ap_invoice_distributions_all id2

Line 7642: FROM ap_invoice_distributions_all id2

7638: UPDATE ap_invoice_distributions_all id1
7639: SET (id1.total_dist_amount,
7640: id1.total_dist_base_amount) = (SELECT SUM(NVL(id2.amount,0)),
7641: SUM(NVL(id2.base_amount,0))
7642: FROM ap_invoice_distributions_all id2
7643: WHERE id2.invoice_distribution_id =
7644: id1.invoice_distribution_id
7645: OR id2.related_id =
7646: id1.invoice_distribution_id)

Line 7942: FROM ap_invoice_lines_all ail,ap_invoice_distributions_all aid

7938: --bugfix:5638734
7939: -- Get the exculusive tax amount for the prepay appln line.
7940: SELECT sum(aid.amount)
7941: INTO l_prepay_excl_tax_amt
7942: FROM ap_invoice_lines_all ail,ap_invoice_distributions_all aid
7943: WHERE ail.line_type_lookup_code='TAX'
7944: AND ail.invoice_id=p_invoice_id
7945: AND aid.invoice_id=ail.invoice_id
7946: AND aid.invoice_line_number=ail.line_number

Line 8017: FROM ap_invoice_distributions_all

8013: SELECT sum(amount),
8014: sum(base_amount)
8015: INTO l_tmp_invoice_amount,
8016: l_tmp_base_amount
8017: FROM ap_invoice_distributions_all
8018: WHERE invoice_id = p_invoice_id
8019: AND ((line_type_lookup_code NOT IN ('PREPAY', 'AWT')
8020: AND prepay_distribution_id IS NULL)
8021: OR nvl(invoice_includes_prepay_flag,'N') = 'Y');

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

8760:
8761: l_debug_info VARCHAR2(1000);
8762: l_curr_calling_sequence VARCHAR2(2000);
8763:
8764: TYPE Invoice_Dists_Tab_Type IS TABLE OF ap_invoice_distributions_all%ROWTYPE;
8765: l_dist_tab Invoice_Dists_Tab_Type := Invoice_Dists_Tab_Type();
8766:
8767: TYPE Expense_Report_Dists_Rec IS RECORD (
8768: Org_id ap_exp_report_dists_all.org_id%TYPE,

Line 9810: FROM AP_INVOICE_DISTRIBUTIONS_ALL D,

9806: FROM DUAL
9807: WHERE AI.FORCE_REVALIDATION_FLAG = ''Y''
9808: UNION ALL
9809: SELECT 1
9810: FROM AP_INVOICE_DISTRIBUTIONS_ALL D,
9811: FINANCIALS_SYSTEM_PARAMS_ALL FSP
9812: WHERE D.INVOICE_ID = AI.INVOICE_ID
9813: AND FSP.ORG_ID = AI.ORG_ID
9814: AND FSP.SET_OF_BOOKS_ID = AI.SET_OF_BOOKS_ID

Line 9867: FROM AP_INVOICE_DISTRIBUTIONS_ALL D5

9863: (AIL.AMOUNT = 0 AND AIL.GENERATE_DISTS = ''Y'')) --8580790
9864: AND NOT EXISTS
9865: ( SELECT /*+ NO_UNNEST */
9866: ''distributed line''
9867: FROM AP_INVOICE_DISTRIBUTIONS_ALL D5
9868: WHERE D5.INVOICE_ID = AIL.INVOICE_ID
9869: AND D5.INVOICE_LINE_NUMBER = AIL.LINE_NUMBER
9870: )
9871: )

Line 9874: FROM AP_INVOICE_DISTRIBUTIONS_ALL D3

9870: )
9871: )
9872: AND NOT EXISTS
9873: ( SELECT /*+ no_push_subq */ ''Cancelled distributions''
9874: FROM AP_INVOICE_DISTRIBUTIONS_ALL D3
9875: WHERE D3.INVOICE_ID = AI.INVOICE_ID
9876: AND D3.CANCELLATION_FLAG = ''Y''
9877: ) ' ;
9878:

Line 12344: FROM ap_invoice_distributions_all aid

12340: p_calling_sequence => l_curr_calling_sequence );
12341:
12342: SELECT COUNT(*)
12343: INTO l_regenerate_dist
12344: FROM ap_invoice_distributions_all aid
12345: WHERE aid.invoice_id = t_inv_lines_table(i) .invoice_id
12346: AND aid.invoice_line_number = t_inv_lines_table(i) .line_number
12347: AND (NVL(posted_flag , 'N') <> 'N'
12348: OR NVL(encumbered_flag,'N') <>'N');

Line 12607: FROM ap_invoice_distributions_all

12603:
12604: l_debug_info := 'Before getting the count of encumbered distributions';
12605: SELECT count(*)
12606: INTO l_check_encumbrance
12607: FROM ap_invoice_distributions_all
12608: WHERE invoice_id = P_invoice_id
12609: AND nvl(encumbered_flag, 'N') NOT IN ('N','R')
12610: AND rownum < 2;
12611: