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_IMPORT_VALIDATION_PKG dependencies on AP_INVOICE_LINES

Line 3366: FROM ap_invoice_lines_interface

3362: END IF;
3363:
3364: SELECT nvl(sum(amount),0) , count(*)
3365: INTO l_lines_amount_sum, l_no_of_lines
3366: FROM ap_invoice_lines_interface
3367: WHERE invoice_id = p_invoice_rec.invoice_id;
3368:
3369: IF (AP_IMPORT_INVOICES_PKG.g_source = 'EDI GATEWAY') THEN
3370: debug_info := '(Check Invoice step 4) Check Invoice amount to match '

Line 4483: FROM po_headers p, ap_invoice_lines_interface l

4479: END IF;
4480: BEGIN
4481: SELECT p.terms_id
4482: INTO l_term_id
4483: FROM po_headers p, ap_invoice_lines_interface l
4484: WHERE p.type_lookup_code in ('BLANKET', 'PLANNED', 'STANDARD')
4485: AND ((l.po_header_id = p.po_header_id) OR
4486: (l.po_number = p.segment1))
4487: AND l.invoice_id = p_invoice_rec.invoice_id

Line 4525: ap_invoice_lines_interface l

4521: SELECT p.terms_id
4522: INTO l_term_id
4523: FROM rcv_transactions r,
4524: po_headers p,
4525: ap_invoice_lines_interface l
4526: WHERE p.po_header_id = r.po_header_id
4527: AND r.transaction_id = l.rcv_transaction_id
4528: AND l.invoice_id = p_invoice_rec.invoice_id
4529: AND p.terms_id IS NOT NULL

Line 6382: FROM ap_invoice_lines ail,

6378: BEGIN
6379:
6380: SELECT count(*)
6381: INTO l_count_lines_matched
6382: FROM ap_invoice_lines ail,
6383: ap_invoices ai,
6384: po_line_locations pll
6385: WHERE ai.invoice_num = p_invoice_rec.prepay_num
6386: AND ai.org_id = p_invoice_rec.org_id

Line 7017: FROM ap_invoice_lines_interface

7013: ,Created_By
7014: ,sysdate --CREATION_DATE
7015: ,sysdate --LAST_UPDATE_DATE
7016: /*Bug 14271140 End*/
7017: FROM ap_invoice_lines_interface
7018: WHERE invoice_id = p_invoice_rec.invoice_id
7019: ORDER BY invoice_line_id;
7020: -- FOR UPDATE OF invoice_line_id; -- Bug 1714845
7021:

Line 7036: FROM ap_invoice_lines_interface ail3

7032: --amount,
7033: -- Bug 6369356 summarize tax lines
7034: DECODE(line_type_lookup_code , 'TAX',
7035: (SELECT SUM(ail3.amount)
7036: FROM ap_invoice_lines_interface ail3
7037: WHERE ail3.tax_code = ail.tax_code
7038: AND ail3.line_type_lookup_code = 'TAX'
7039: AND ail3.invoice_id = ail.invoice_id
7040: GROUP BY tax_code),

Line 7244: FROM ap_invoice_lines_interface ail

7240: ,Created_By
7241: ,sysdate --CREATION_DATE
7242: ,sysdate --LAST_UPDATE_DATE
7243: /*Bug 14271140 End*/
7244: FROM ap_invoice_lines_interface ail
7245: WHERE invoice_id = p_invoice_rec.invoice_id
7246: -- Bug 6369356
7247: AND ((line_type_lookup_code <> 'TAX')
7248: OR ( line_type_lookup_code = 'TAX' AND

Line 7250: FROM ap_invoice_lines_interface ail2

7246: -- Bug 6369356
7247: AND ((line_type_lookup_code <> 'TAX')
7248: OR ( line_type_lookup_code = 'TAX' AND
7249: rowid =(SELECT max(ail2.rowid)
7250: FROM ap_invoice_lines_interface ail2
7251: WHERE ail2.tax_code = ail.tax_code
7252: AND ail2.line_type_lookup_code = 'TAX'
7253: AND ail2.invoice_id = ail.invoice_id
7254: GROUP BY tax_code)

Line 7357: FROM ap_invoice_lines_interface ail

7353: IF AP_IMPORT_INVOICES_PKG.g_source = 'RETEK' THEN
7354: BEGIN
7355: SELECT NVL(MAX(line_number),0)
7356: INTO l_max_line_number
7357: FROM ap_invoice_lines_interface ail
7358: WHERE invoice_id = p_invoice_rec.invoice_id
7359: AND ((line_type_lookup_code <> 'TAX')
7360: OR ( line_type_lookup_code = 'TAX' AND
7361: rowid =(SELECT MAX(ail2.rowid)

Line 7362: FROM ap_invoice_lines_interface ail2

7358: WHERE invoice_id = p_invoice_rec.invoice_id
7359: AND ((line_type_lookup_code <> 'TAX')
7360: OR ( line_type_lookup_code = 'TAX' AND
7361: rowid =(SELECT MAX(ail2.rowid)
7362: FROM ap_invoice_lines_interface ail2
7363: WHERE ail2.tax_code = ail.tax_code
7364: AND ail2.line_type_lookup_code = 'TAX'
7365: AND ail2.invoice_id = ail.invoice_id
7366: GROUP BY tax_code)

Line 7380: FROM ap_invoice_lines_interface

7376: BEGIN
7377: --bugfix:4745899 , added the NVL condition
7378: SELECT NVL(MAX(line_number),0)
7379: INTO l_max_line_number
7380: FROM ap_invoice_lines_interface
7381: WHERE invoice_id = p_invoice_rec.invoice_id;
7382:
7383: EXCEPTION
7384: WHEN OTHERS THEN

Line 7651: UPDATE ap_invoice_lines_interface

7647: END IF;
7648:
7649: ELSE
7650:
7651: UPDATE ap_invoice_lines_interface
7652: SET org_id = p_invoice_rec.org_id
7653: WHERE rowid = p_invoice_lines_tab(i).row_id;
7654:
7655: p_invoice_lines_tab(i).org_id := p_invoice_rec.org_id;

Line 7673: ||'ap_invoice_lines_interface';

7669: debug_info);
7670: END IF;
7671:
7672: debug_info := '(Check_lines 6.2) Update new invoice_line_id to '
7673: ||'ap_invoice_lines_interface';
7674: IF (AP_IMPORT_INVOICES_PKG.g_debug_switch = 'Y') then
7675: AP_IMPORT_UTILITIES_PKG.Print(AP_IMPORT_INVOICES_PKG.g_debug_switch,
7676: debug_info);
7677: END IF;

Line 7679: UPDATE ap_invoice_lines_interface

7675: AP_IMPORT_UTILITIES_PKG.Print(AP_IMPORT_INVOICES_PKG.g_debug_switch,
7676: debug_info);
7677: END IF;
7678:
7679: UPDATE ap_invoice_lines_interface
7680: SET invoice_line_id = ap_invoice_lines_interface_s.NEXTVAL
7681: WHERE rowid = p_invoice_lines_tab(i).row_id
7682: RETURNING invoice_line_id INTO p_invoice_lines_tab(i).invoice_line_id;
7683: END IF;

Line 7680: SET invoice_line_id = ap_invoice_lines_interface_s.NEXTVAL

7676: debug_info);
7677: END IF;
7678:
7679: UPDATE ap_invoice_lines_interface
7680: SET invoice_line_id = ap_invoice_lines_interface_s.NEXTVAL
7681: WHERE rowid = p_invoice_lines_tab(i).row_id
7682: RETURNING invoice_line_id INTO p_invoice_lines_tab(i).invoice_line_id;
7683: END IF;
7684:

Line 9004: FROM AP_INVOICE_LINES_INTERFACE

9000: Global_Attribute_Category /*Bug#15977829*/
9001: INTO p_invoice_lines_tab(i).Global_Attribute1, p_invoice_lines_tab(i).Global_Attribute2,
9002: p_invoice_lines_tab(i).Global_Attribute3,
9003: p_invoice_lines_tab(i).Global_Attribute_Category
9004: FROM AP_INVOICE_LINES_INTERFACE
9005: WHERE invoice_line_id = p_invoice_lines_tab(i).invoice_line_id;
9006: END IF;
9007: --End Bug#13464635
9008:

Line 9154: l_purchasing_category_id AP_INVOICE_LINES_ALL.PURCHASING_CATEGORY_ID%TYPE;

9150: l_po_inv_curr_is_consis_flag VARCHAR2(1) := 'N';
9151: l_current_invoice_status VARCHAR2(1) := 'Y';
9152: l_po_is_not_blanket VARCHAR2(1) := 'N';
9153: l_vendor_id NUMBER;
9154: l_purchasing_category_id AP_INVOICE_LINES_ALL.PURCHASING_CATEGORY_ID%TYPE;
9155: current_calling_sequence VARCHAR2(2000);
9156: debug_info VARCHAR2(500);
9157:
9158: -- Contextual Information for XML Gateway

Line 12478: FROM ap_invoices ai, ap_invoice_lines ail, ap_invoice_distributions aid

12474: l_price_cor_po_header_id,
12475: l_price_cor_po_line_id,
12476: l_price_cor_po_line_loc_id,
12477: l_price_cor_po_distribution_id
12478: FROM ap_invoices ai, ap_invoice_lines ail, ap_invoice_distributions aid
12479: WHERE ai.invoice_num = p_invoice_lines_rec.price_correct_inv_num
12480: AND ail.invoice_id = ai.invoice_id
12481: AND ail.line_number = p_invoice_lines_rec.price_correct_inv_line_num
12482: AND aid.invoice_id = ail.invoice_id

Line 12692: FROM ap_invoice_lines ail, po_line_locations pll

12688: END IF;
12689:
12690: SELECT 'Y'
12691: INTO l_shipment_finally_closed
12692: FROM ap_invoice_lines ail, po_line_locations pll
12693: WHERE ail.invoice_id = l_price_correct_inv_id
12694: AND ail.line_number = p_invoice_lines_rec.price_correct_inv_line_num
12695: AND pll.line_location_id = ail.po_line_location_id
12696: AND pll.closed_code = 'FINALLY CLOSED';

Line 12819: FROM ap_invoice_lines ail

12815: BEGIN
12816:
12817: SELECT ail.quantity_invoiced
12818: INTO l_base_match_quantity
12819: FROM ap_invoice_lines ail
12820: WHERE ail.invoice_id = l_price_correct_inv_id
12821: AND ail.line_number = p_invoice_lines_rec.price_correct_inv_line_num;
12822:
12823:

Line 12913: FROM ap_invoice_lines ail

12909: BEGIN
12910:
12911: SELECT nvl(sum(ail.amount),0)
12912: INTO l_correction_amount
12913: FROM ap_invoice_lines ail
12914: WHERE ail.invoice_id = l_price_correct_inv_id
12915: AND ail.line_number = p_invoice_lines_rec.price_correct_inv_line_num
12916: AND ail.match_type IN ('PRICE_CORRECTION','QTY_CORRECTION');
12917:

Line 13007: FROM ap_invoice_lines ail

13003: BEGIN
13004:
13005: SELECT amount, quantity_invoiced
13006: INTO l_total_amount_invoiced, l_total_quantity_invoiced
13007: FROM ap_invoice_lines ail
13008: WHERE ail.invoice_id = l_price_correct_inv_id
13009: AND ail.line_number = p_invoice_lines_rec.price_correct_inv_line_num;
13010:
13011: --bugfix:5640388

Line 13772: into ap_invoice_lines and ap_invoice_distributions*/

13768: p_invoice_lines_rec.match_type := 'PRICE_CORRECTION'; /* 5400087 */
13769: END IF;
13770:
13771: /*Bug8546486 Assigning the description fetched from PO to be inserted
13772: into ap_invoice_lines and ap_invoice_distributions*/
13773: IF (l_item_description IS NOT NULL) then
13774: IF (p_invoice_lines_rec.description IS NULL) then /* B 9569917 ... added IF condition */
13775: p_invoice_lines_rec.description := l_item_description;
13776: END IF;

Line 14709: -- AP_INVOICE_LINES_INTERFACE. If the PO's unit price is not

14705: -- Check for Invalid Unit Price against PO
14706: -- Retropricing:
14707: -- We assume that PO will not allow to retroprice a PO again
14708: -- if there are pending PO shipment instructions in the
14709: -- AP_INVOICE_LINES_INTERFACE. If the PO's unit price is not
14710: -- equal to the unit price on the PPA, then it should
14711: -- be rejected . Currently UNIT PRC NOT EQUAL TO PO
14712: -- rejection is only meant for EDI-GATEWAY.
14713: -- Thia step should not be executed in context of PPA's.

Line 14744: FROM ap_invoice_lines L

14740: ROUND(NVL(p_invoice_lines_rec.amount +
14741: NVL(SUM(NVL(L.amount, 0)),0),0),5)
14742: INTO l_total_qty_billed,
14743: l_total_match_amount
14744: FROM ap_invoice_lines L
14745: WHERE l.po_line_location_id = l_po_line_location_id;
14746:
14747: -- If total qty billed is below zero
14748: -- we should reject. In invoice workbench the form takes care of this.

Line 14863: FROM ap_invoice_lines L,

14859: NVL(SUM(NVL(PLL.amount,0)),0) +
14860: NVL(p_invoice_lines_rec.amount, l_line_amount)
14861: INTO l_total_qty_billed,
14862: l_total_match_amount /* Amount Based Matching */
14863: FROM ap_invoice_lines L,
14864: po_line_locations PLL
14865: WHERE L.po_line_location_id = PLL.line_location_id
14866: AND PLL.po_line_id = l_po_line_id;
14867:

Line 18751: l_expd_item_date ap_invoice_lines.expenditure_item_date%TYPE:= '';

18747: l_inactive_date_per_name DATE;
18748: l_total_percent_distribution
18749: AP_DISTRIBUTION_SETS.TOTAL_PERCENT_DISTRIBUTION%TYPE;
18750: l_dset_lines_tab AP_IMPORT_VALIDATION_PKG.dset_line_tab_type;
18751: l_expd_item_date ap_invoice_lines.expenditure_item_date%TYPE:= '';
18752: l_error_found VARCHAR2(1);
18753: i BINARY_INTEGER := 0;
18754: l_running_total_amount NUMBER := 0;
18755: l_running_total_base_amt NUMBER := 0;

Line 20545: FROM ap_invoice_lines_interface

20541: END IF;
20542:
20543: SELECT count(*)
20544: INTO l_line_count
20545: FROM ap_invoice_lines_interface
20546: WHERE invoice_id = p_invoice_rec.invoice_id
20547: AND line_number = p_invoice_lines_rec.line_number;
20548:
20549: IF (l_line_count > 1) THEN

Line 21073: FROM ap_invoice_lines_interface AIL

21069: END IF;
21070:
21071: SELECT SUM(nvl(AIL.amount,0))
21072: INTO l_item_line_total
21073: FROM ap_invoice_lines_interface AIL
21074: WHERE AIL.invoice_id = p_invoice_rec.invoice_id
21075: AND ((line_group_number = p_invoice_lines_rec.line_group_number AND
21076: p_invoice_lines_rec.line_group_number IS NOT NULL) OR
21077: p_invoice_lines_rec.line_group_number is NULL)

Line 21116: FROM ap_invoice_lines_interface AIL

21112: -- For TAX line, prorate_across_flag should be Y
21113:
21114: SELECT COUNT(*)
21115: INTO l_count_item_lines
21116: FROM ap_invoice_lines_interface AIL
21117: WHERE AIL.invoice_id = p_invoice_rec.invoice_id
21118: AND line_group_number = p_invoice_lines_rec.line_group_number
21119: AND (line_type_lookup_code = 'ITEM'
21120: OR (line_type_lookup_code = 'TAX' AND prorate_across_flag = 'Y'));

Line 21143: FROM ap_invoice_lines_interface AIL

21139:
21140: /* Commented for bug 9700233
21141: SELECT COUNT(*)
21142: INTO l_count_non_item_lines
21143: FROM ap_invoice_lines_interface AIL
21144: WHERE AIL.invoice_id = p_invoice_rec.invoice_id
21145: AND line_group_number = p_invoice_lines_rec.line_group_number
21146: AND line_type_lookup_code <> 'ITEM';
21147:

Line 21554: FROM ap_invoice_lines_interface

21550:
21551: BEGIN
21552: SELECT invoice_id
21553: INTO l_exist_tax_line
21554: FROM ap_invoice_lines_interface
21555: WHERE invoice_id = p_invoice_rec.invoice_id
21556: AND line_type_lookup_code = 'TAX'
21557: AND ROWNUM =1;
21558:

Line 21600: FROM ap_invoice_lines_interface aili

21596: INTO l_alloc_not_provided
21597: FROM ap_invoices_interface aii
21598: WHERE aii.invoice_id = p_invoice_rec.invoice_id
21599: AND 1 < (SELECT COUNT(*)
21600: FROM ap_invoice_lines_interface aili
21601: WHERE aili.line_type_lookup_code <> 'TAX'
21602: AND aili.invoice_id = aii.invoice_id)
21603: AND EXISTS (SELECT 'Y'
21604: FROM ap_invoice_lines_interface ail2

Line 21604: FROM ap_invoice_lines_interface ail2

21600: FROM ap_invoice_lines_interface aili
21601: WHERE aili.line_type_lookup_code <> 'TAX'
21602: AND aili.invoice_id = aii.invoice_id)
21603: AND EXISTS (SELECT 'Y'
21604: FROM ap_invoice_lines_interface ail2
21605: WHERE ail2.invoice_id = aii.invoice_id
21606: AND ail2.line_type_lookup_code = 'TAX'
21607: AND ail2.line_group_number IS NULL
21608: AND NVL(ail2.incl_in_taxable_line_flag, 'N') = 'Y');

Line 21647: FROM ap_invoice_lines_interface ail2

21643: INTO l_tax_found_in_nontax_line
21644: FROM ap_invoices_interface aii
21645: WHERE aii.invoice_id = p_invoice_rec.invoice_id
21646: AND EXISTS (SELECT 'Y'
21647: FROM ap_invoice_lines_interface ail2
21648: WHERE ail2.invoice_id = aii.invoice_id
21649: AND ail2.line_type_lookup_code <> 'TAX'
21650: AND (ail2.tax_regime_code IS NOT NULL OR
21651: ail2.tax IS NOT NULL OR

Line 21703: FROM ap_invoice_lines_interface ail2

21699: INTO l_tax_lines_cannot_coexist
21700: FROM ap_invoices_interface aii
21701: WHERE aii.invoice_id = p_invoice_rec.invoice_id
21702: AND EXISTS (SELECT 'Y'
21703: FROM ap_invoice_lines_interface ail2
21704: WHERE ail2.invoice_id = aii.invoice_id
21705: AND ail2.line_type_lookup_code = 'TAX'
21706: AND ail2.rcv_transaction_id IS NOT NULL)
21707: AND EXISTS (SELECT 'Y'

Line 21708: FROM ap_invoice_lines_interface ail3

21704: WHERE ail2.invoice_id = aii.invoice_id
21705: AND ail2.line_type_lookup_code = 'TAX'
21706: AND ail2.rcv_transaction_id IS NOT NULL)
21707: AND EXISTS (SELECT 'Y'
21708: FROM ap_invoice_lines_interface ail3
21709: WHERE ail3.invoice_id = aii.invoice_id
21710: AND ail3.line_type_lookup_code = 'TAX'
21711: AND ail3.rcv_transaction_id IS NULL);
21712: EXCEPTION

Line 21764: | ap_invoice_lines_interface table as part of the eTax Uptake project:

Line 21801: l_po_line_location_id ap_invoice_lines_interface.po_line_location_id%TYPE;

21797: current_calling_sequence VARCHAR2(2000);
21798: debug_info VARCHAR2(500);
21799:
21800: --6412397
21801: l_po_line_location_id ap_invoice_lines_interface.po_line_location_id%TYPE;
21802: l_location_id zx_transaction_lines_gt.ship_from_location_id%type;
21803: l_ship_to_location_id ap_supplier_sites_all.ship_to_location_id%type;
21804: l_bill_to_location_id zx_transaction_lines_gt.bill_to_location_id%TYPE;
21805: l_fob_point po_vendor_sites_all.fob_lookup_code%TYPE;

Line 21888: ap_invoice_lines_interface aili

21884: BEGIN
21885: SELECT aii.invoice_type_lookup_code
21886: INTO l_inv_hdr_inv_type
21887: FROM ap_invoices_interface aii,
21888: ap_invoice_lines_interface aili
21889: WHERE aii.invoice_id = aili.invoice_id
21890: AND aili.ROWID = p_invoice_lines_rec.row_id;
21891:
21892: IF (AP_IMPORT_INVOICES_PKG.g_debug_switch = 'Y') THEN

Line 22011: ap_invoice_lines_interface aili

22007: l_inv_hdr_vendor_id,
22008: l_inv_hdr_vendor_site_id,
22009: l_inv_hdr_inv_type
22010: FROM ap_invoices_interface aii,
22011: ap_invoice_lines_interface aili
22012: WHERE aii.invoice_id = aili.invoice_id
22013: AND aili.ROWID = p_invoice_lines_rec.row_id;
22014:
22015: IF (AP_IMPORT_INVOICES_PKG.g_debug_switch = 'Y') THEN

Line 22234: l_purchasing_category_id AP_INVOICE_LINES_ALL.PURCHASING_CATEGORY_ID%TYPE;

22230: p_calling_sequence IN VARCHAR2) RETURN BOOLEAN
22231:
22232: IS
22233: purch_category_check_failure EXCEPTION;
22234: l_purchasing_category_id AP_INVOICE_LINES_ALL.PURCHASING_CATEGORY_ID%TYPE;
22235: l_current_invoice_status VARCHAR2(1) := 'Y';
22236: current_calling_sequence VARCHAR2(2000);
22237: debug_info VARCHAR2(500);
22238:

Line 22450: l_cost_factor_id AP_INVOICE_LINES_ALL.COST_FACTOR_ID%TYPE;

22446: p_calling_sequence IN VARCHAR2) RETURN BOOLEAN
22447:
22448: IS
22449: cost_factor_check_failure EXCEPTION;
22450: l_cost_factor_id AP_INVOICE_LINES_ALL.COST_FACTOR_ID%TYPE;
22451: l_valid_cost_factor VARCHAR2(1);
22452: l_current_invoice_status VARCHAR2(1) := 'Y';
22453: current_calling_sequence VARCHAR2(2000);
22454: debug_info VARCHAR2(500);

Line 22661: l_retained_amount := ap_invoice_lines_utility_pkg.get_retained_amount

22657: AP_IMPORT_UTILITIES_PKG.Print(
22658: AP_IMPORT_INVOICES_PKG.g_debug_switch, debug_info);
22659: END IF;
22660:
22661: l_retained_amount := ap_invoice_lines_utility_pkg.get_retained_amount
22662: (p_invoice_lines_rec.po_line_location_id,
22663: p_invoice_lines_rec.amount);
22664:
22665: --------------------------------------------------------------------------

Line 24457: 'AP_INVOICE_LINES_INTERFACE', --P_table_name

24453: IF (p_valid_level = 'INVOICE LINE')THEN
24454: AP_INVOICES_UTILITY_PKG.CHECK_GDF_VALID
24455: (p_invoice_line_id, --P_id
24456: 'INV_IMP', --P_calling_mode
24457: 'AP_INVOICE_LINES_INTERFACE', --P_table_name
24458: l_hold_reject_exists_flag, --P_hold_reject_exists_flag
24459: l_return_code, --p_return_code
24460: current_calling_sequence);
24461: