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_INTERFACE

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 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 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 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 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: