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 3169: FROM ap_invoice_lines_interface

3165: END IF;
3166:
3167: SELECT nvl(sum(amount),0) , count(*)
3168: INTO l_lines_amount_sum, l_no_of_lines
3169: FROM ap_invoice_lines_interface
3170: WHERE invoice_id = p_invoice_rec.invoice_id;
3171:
3172: IF (AP_IMPORT_INVOICES_PKG.g_source = 'EDI GATEWAY') THEN
3173: debug_info := '(Check Invoice step 4) Check Invoice amount to match '

Line 4216: FROM po_headers p, ap_invoice_lines_interface l

4212: END IF;
4213: BEGIN
4214: SELECT p.terms_id
4215: INTO l_term_id
4216: FROM po_headers p, ap_invoice_lines_interface l
4217: WHERE p.type_lookup_code in ('BLANKET', 'PLANNED', 'STANDARD')
4218: AND ((l.po_header_id = p.po_header_id) OR
4219: (l.po_number = p.segment1))
4220: AND l.invoice_id = p_invoice_rec.invoice_id

Line 4258: ap_invoice_lines_interface l

4254: SELECT p.terms_id
4255: INTO l_term_id
4256: FROM rcv_transactions r,
4257: po_headers p,
4258: ap_invoice_lines_interface l
4259: WHERE p.po_header_id = r.po_header_id
4260: AND r.transaction_id = l.rcv_transaction_id
4261: AND l.invoice_id = p_invoice_rec.invoice_id
4262: AND p.terms_id IS NOT NULL

Line 5941: FROM ap_invoice_lines ail,

5937: BEGIN
5938:
5939: SELECT count(*)
5940: INTO l_count_lines_matched
5941: FROM ap_invoice_lines ail,
5942: ap_invoices ai,
5943: po_line_locations pll
5944: WHERE ai.invoice_num = p_invoice_rec.prepay_num
5945: AND ai.org_id = p_invoice_rec.org_id

Line 6510: FROM ap_invoice_lines_interface

6506: receipt_currency_amount,
6507: receipt_currency_code,
6508: country_of_supply
6509: --Bug6167068 ends
6510: FROM ap_invoice_lines_interface
6511: WHERE invoice_id = p_invoice_rec.invoice_id
6512: ORDER BY invoice_line_id;
6513: -- FOR UPDATE OF invoice_line_id; -- Bug 1714845
6514:

Line 6529: FROM ap_invoice_lines_interface ail3

6525: --amount,
6526: -- Bug 6369356 summarize tax lines
6527: DECODE(line_type_lookup_code , 'TAX',
6528: (SELECT SUM(ail3.amount)
6529: FROM ap_invoice_lines_interface ail3
6530: WHERE ail3.tax_code = ail.tax_code
6531: AND ail3.line_type_lookup_code = 'TAX'
6532: AND ail3.invoice_id = ail.invoice_id
6533: GROUP BY tax_code),

Line 6716: FROM ap_invoice_lines_interface ail

6712: receipt_currency_amount,
6713: receipt_currency_code,
6714: country_of_supply
6715: --Bug6167068 ends
6716: FROM ap_invoice_lines_interface ail
6717: WHERE invoice_id = p_invoice_rec.invoice_id
6718: -- Bug 6369356
6719: AND ((line_type_lookup_code <> 'TAX')
6720: OR ( line_type_lookup_code = 'TAX' AND

Line 6722: FROM ap_invoice_lines_interface ail2

6718: -- Bug 6369356
6719: AND ((line_type_lookup_code <> 'TAX')
6720: OR ( line_type_lookup_code = 'TAX' AND
6721: rowid =(SELECT max(ail2.rowid)
6722: FROM ap_invoice_lines_interface ail2
6723: WHERE ail2.tax_code = ail.tax_code
6724: AND ail2.line_type_lookup_code = 'TAX'
6725: AND ail2.invoice_id = ail.invoice_id
6726: GROUP BY tax_code)

Line 6815: FROM ap_invoice_lines_interface ail

6811: IF AP_IMPORT_INVOICES_PKG.g_source = 'RETEK' THEN
6812: BEGIN
6813: SELECT NVL(MAX(line_number),0)
6814: INTO l_max_line_number
6815: FROM ap_invoice_lines_interface ail
6816: WHERE invoice_id = p_invoice_rec.invoice_id
6817: AND ((line_type_lookup_code <> 'TAX')
6818: OR ( line_type_lookup_code = 'TAX' AND
6819: rowid =(SELECT MAX(ail2.rowid)

Line 6820: FROM ap_invoice_lines_interface ail2

6816: WHERE invoice_id = p_invoice_rec.invoice_id
6817: AND ((line_type_lookup_code <> 'TAX')
6818: OR ( line_type_lookup_code = 'TAX' AND
6819: rowid =(SELECT MAX(ail2.rowid)
6820: FROM ap_invoice_lines_interface ail2
6821: WHERE ail2.tax_code = ail.tax_code
6822: AND ail2.line_type_lookup_code = 'TAX'
6823: AND ail2.invoice_id = ail.invoice_id
6824: GROUP BY tax_code)

Line 6838: FROM ap_invoice_lines_interface

6834: BEGIN
6835: --bugfix:4745899 , added the NVL condition
6836: SELECT NVL(MAX(line_number),0)
6837: INTO l_max_line_number
6838: FROM ap_invoice_lines_interface
6839: WHERE invoice_id = p_invoice_rec.invoice_id;
6840:
6841: EXCEPTION
6842: WHEN OTHERS THEN

Line 7094: UPDATE ap_invoice_lines_interface

7090: END IF;
7091:
7092: ELSE
7093:
7094: UPDATE ap_invoice_lines_interface
7095: SET org_id = p_invoice_rec.org_id
7096: WHERE rowid = p_invoice_lines_tab(i).row_id;
7097:
7098: p_invoice_lines_tab(i).org_id := p_invoice_rec.org_id;

Line 7116: ||'ap_invoice_lines_interface';

7112: debug_info);
7113: END IF;
7114:
7115: debug_info := '(Check_lines 6.2) Update new invoice_line_id to '
7116: ||'ap_invoice_lines_interface';
7117: IF (AP_IMPORT_INVOICES_PKG.g_debug_switch = 'Y') then
7118: AP_IMPORT_UTILITIES_PKG.Print(AP_IMPORT_INVOICES_PKG.g_debug_switch,
7119: debug_info);
7120: END IF;

Line 7122: UPDATE ap_invoice_lines_interface

7118: AP_IMPORT_UTILITIES_PKG.Print(AP_IMPORT_INVOICES_PKG.g_debug_switch,
7119: debug_info);
7120: END IF;
7121:
7122: UPDATE ap_invoice_lines_interface
7123: SET invoice_line_id = ap_invoice_lines_interface_s.NEXTVAL
7124: WHERE rowid = p_invoice_lines_tab(i).row_id
7125: RETURNING invoice_line_id INTO p_invoice_lines_tab(i).invoice_line_id;
7126: END IF;

Line 7123: SET invoice_line_id = ap_invoice_lines_interface_s.NEXTVAL

7119: debug_info);
7120: END IF;
7121:
7122: UPDATE ap_invoice_lines_interface
7123: SET invoice_line_id = ap_invoice_lines_interface_s.NEXTVAL
7124: WHERE rowid = p_invoice_lines_tab(i).row_id
7125: RETURNING invoice_line_id INTO p_invoice_lines_tab(i).invoice_line_id;
7126: END IF;
7127:

Line 8339: l_purchasing_category_id AP_INVOICE_LINES_ALL.PURCHASING_CATEGORY_ID%TYPE;

8335: l_po_inv_curr_is_consis_flag VARCHAR2(1) := 'N';
8336: l_current_invoice_status VARCHAR2(1) := 'Y';
8337: l_po_is_not_blanket VARCHAR2(1) := 'N';
8338: l_vendor_id NUMBER;
8339: l_purchasing_category_id AP_INVOICE_LINES_ALL.PURCHASING_CATEGORY_ID%TYPE;
8340: current_calling_sequence VARCHAR2(2000);
8341: debug_info VARCHAR2(500);
8342:
8343: -- Contextual Information for XML Gateway

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

11345: END IF;
11346:
11347: SELECT DISTINCT ai.invoice_id, ail.amount
11348: INTO l_price_correct_inv_id, l_base_match_amount
11349: FROM ap_invoices ai, ap_invoice_lines ail, ap_invoice_distributions aid
11350: WHERE ai.invoice_num = p_invoice_lines_rec.price_correct_inv_num
11351: AND ail.invoice_id = ai.invoice_id
11352: AND ail.line_number = p_invoice_lines_rec.price_correct_inv_line_num
11353: AND aid.invoice_id = ail.invoice_id

Line 11533: FROM ap_invoice_lines ail, po_line_locations pll

11529: END IF;
11530:
11531: SELECT 'Y'
11532: INTO l_shipment_finally_closed
11533: FROM ap_invoice_lines ail, po_line_locations pll
11534: WHERE ail.invoice_id = l_price_correct_inv_id
11535: AND ail.line_number = p_invoice_lines_rec.price_correct_inv_line_num
11536: AND pll.line_location_id = ail.po_line_location_id
11537: AND pll.closed_code = 'FINALLY CLOSED';

Line 11660: FROM ap_invoice_lines ail

11656: BEGIN
11657:
11658: SELECT ail.quantity_invoiced
11659: INTO l_base_match_quantity
11660: FROM ap_invoice_lines ail
11661: WHERE ail.invoice_id = l_price_correct_inv_id
11662: AND ail.line_number = p_invoice_lines_rec.price_correct_inv_line_num;
11663:
11664:

Line 11744: FROM ap_invoice_lines ail

11740: BEGIN
11741:
11742: SELECT nvl(sum(ail.amount),0)
11743: INTO l_correction_amount
11744: FROM ap_invoice_lines ail
11745: WHERE ail.invoice_id = l_price_correct_inv_id
11746: AND ail.line_number = p_invoice_lines_rec.price_correct_inv_line_num
11747: AND ail.match_type IN ('PRICE_CORRECTION','QTY_CORRECTION');
11748:

Line 11825: FROM ap_invoice_lines ail

11821: BEGIN
11822:
11823: SELECT amount, quantity_invoiced
11824: INTO l_total_amount_invoiced, l_total_quantity_invoiced
11825: FROM ap_invoice_lines ail
11826: WHERE ail.invoice_id = l_price_correct_inv_id
11827: AND ail.line_number = p_invoice_lines_rec.price_correct_inv_line_num;
11828:
11829: --bugfix:5640388

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

13335: -- Check for Invalid Unit Price against PO
13336: -- Retropricing:
13337: -- We assume that PO will not allow to retroprice a PO again
13338: -- if there are pending PO shipment instructions in the
13339: -- AP_INVOICE_LINES_INTERFACE. If the PO's unit price is not
13340: -- equal to the unit price on the PPA, then it should
13341: -- be rejected . Currently UNIT PRC NOT EQUAL TO PO
13342: -- rejection is only meant for EDI-GATEWAY.
13343: -- Thia step should not be executed in context of PPA's.

Line 13374: FROM ap_invoice_lines L

13370: ROUND(NVL(p_invoice_lines_rec.amount +
13371: NVL(SUM(NVL(L.amount, 0)),0),0),5)
13372: INTO l_total_qty_billed,
13373: l_total_match_amount
13374: FROM ap_invoice_lines L
13375: WHERE l.po_line_location_id = l_po_line_location_id;
13376:
13377: -- If total qty billed is below zero
13378: -- we should reject. In invoice workbench the form takes care of this.

Line 13493: FROM ap_invoice_lines L,

13489: NVL(SUM(NVL(PLL.amount,0)),0) +
13490: NVL(p_invoice_lines_rec.amount, l_line_amount)
13491: INTO l_total_qty_billed,
13492: l_total_match_amount /* Amount Based Matching */
13493: FROM ap_invoice_lines L,
13494: po_line_locations PLL
13495: WHERE L.po_line_location_id = PLL.line_location_id
13496: AND PLL.po_line_id = l_po_line_id;
13497:

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

17070: l_inactive_date_per_name DATE;
17071: l_total_percent_distribution
17072: AP_DISTRIBUTION_SETS.TOTAL_PERCENT_DISTRIBUTION%TYPE;
17073: l_dset_lines_tab AP_IMPORT_VALIDATION_PKG.dset_line_tab_type;
17074: l_expd_item_date ap_invoice_lines.expenditure_item_date%TYPE:= '';
17075: l_error_found VARCHAR2(1);
17076: i BINARY_INTEGER := 0;
17077: l_running_total_amount NUMBER := 0;
17078: l_running_total_base_amt NUMBER := 0;

Line 18831: FROM ap_invoice_lines_interface

18827: END IF;
18828:
18829: SELECT count(*)
18830: INTO l_line_count
18831: FROM ap_invoice_lines_interface
18832: WHERE invoice_id = p_invoice_rec.invoice_id
18833: AND line_number = p_invoice_lines_rec.line_number;
18834:
18835: IF (l_line_count > 1) THEN

Line 19305: FROM ap_invoice_lines_interface AIL

19301: END IF;
19302:
19303: SELECT SUM(nvl(AIL.amount,0))
19304: INTO l_item_line_total
19305: FROM ap_invoice_lines_interface AIL
19306: WHERE AIL.invoice_id = p_invoice_rec.invoice_id
19307: AND ((line_group_number = p_invoice_lines_rec.line_group_number AND
19308: p_invoice_lines_rec.line_group_number IS NOT NULL) OR
19309: p_invoice_lines_rec.line_group_number is NULL)

Line 19343: FROM ap_invoice_lines_interface AIL

19339: IF (p_invoice_lines_rec.line_group_number IS NOT NULL) THEN
19340:
19341: SELECT COUNT(*)
19342: INTO l_count_non_item_lines
19343: FROM ap_invoice_lines_interface AIL
19344: WHERE AIL.invoice_id = p_invoice_rec.invoice_id
19345: AND line_group_number = p_invoice_lines_rec.line_group_number
19346: AND line_type_lookup_code <> 'ITEM';
19347:

Line 19749: FROM ap_invoice_lines_interface

19745:
19746: BEGIN
19747: SELECT invoice_id
19748: INTO l_exist_tax_line
19749: FROM ap_invoice_lines_interface
19750: WHERE invoice_id = p_invoice_rec.invoice_id
19751: AND line_type_lookup_code = 'TAX'
19752: AND ROWNUM =1;
19753:

Line 19795: FROM ap_invoice_lines_interface aili

19791: INTO l_alloc_not_provided
19792: FROM ap_invoices_interface aii
19793: WHERE aii.invoice_id = p_invoice_rec.invoice_id
19794: AND 1 < (SELECT COUNT(*)
19795: FROM ap_invoice_lines_interface aili
19796: WHERE aili.line_type_lookup_code <> 'TAX'
19797: AND aili.invoice_id = aii.invoice_id)
19798: AND EXISTS (SELECT 'Y'
19799: FROM ap_invoice_lines_interface ail2

Line 19799: FROM ap_invoice_lines_interface ail2

19795: FROM ap_invoice_lines_interface aili
19796: WHERE aili.line_type_lookup_code <> 'TAX'
19797: AND aili.invoice_id = aii.invoice_id)
19798: AND EXISTS (SELECT 'Y'
19799: FROM ap_invoice_lines_interface ail2
19800: WHERE ail2.invoice_id = aii.invoice_id
19801: AND ail2.line_type_lookup_code = 'TAX'
19802: AND ail2.line_group_number IS NULL
19803: AND NVL(ail2.incl_in_taxable_line_flag, 'N') = 'Y');

Line 19842: FROM ap_invoice_lines_interface ail2

19838: INTO l_tax_found_in_nontax_line
19839: FROM ap_invoices_interface aii
19840: WHERE aii.invoice_id = p_invoice_rec.invoice_id
19841: AND EXISTS (SELECT 'Y'
19842: FROM ap_invoice_lines_interface ail2
19843: WHERE ail2.invoice_id = aii.invoice_id
19844: AND ail2.line_type_lookup_code <> 'TAX'
19845: AND (ail2.tax_regime_code IS NOT NULL OR
19846: ail2.tax IS NOT NULL OR

Line 19898: FROM ap_invoice_lines_interface ail2

19894: INTO l_tax_lines_cannot_coexist
19895: FROM ap_invoices_interface aii
19896: WHERE aii.invoice_id = p_invoice_rec.invoice_id
19897: AND EXISTS (SELECT 'Y'
19898: FROM ap_invoice_lines_interface ail2
19899: WHERE ail2.invoice_id = aii.invoice_id
19900: AND ail2.line_type_lookup_code = 'TAX'
19901: AND ail2.rcv_transaction_id IS NOT NULL)
19902: AND EXISTS (SELECT 'Y'

Line 19903: FROM ap_invoice_lines_interface ail3

19899: WHERE ail2.invoice_id = aii.invoice_id
19900: AND ail2.line_type_lookup_code = 'TAX'
19901: AND ail2.rcv_transaction_id IS NOT NULL)
19902: AND EXISTS (SELECT 'Y'
19903: FROM ap_invoice_lines_interface ail3
19904: WHERE ail3.invoice_id = aii.invoice_id
19905: AND ail3.line_type_lookup_code = 'TAX'
19906: AND ail3.rcv_transaction_id IS NULL);
19907: EXCEPTION

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

Line 19996: l_po_line_location_id ap_invoice_lines_interface.po_line_location_id%TYPE;

19992: current_calling_sequence VARCHAR2(2000);
19993: debug_info VARCHAR2(500);
19994:
19995: --6412397
19996: l_po_line_location_id ap_invoice_lines_interface.po_line_location_id%TYPE;
19997: l_location_id zx_transaction_lines_gt.ship_from_location_id%type;
19998: l_ship_to_location_id ap_supplier_sites_all.ship_to_location_id%type;
19999: l_bill_to_location_id zx_transaction_lines_gt.bill_to_location_id%TYPE;
20000: l_fob_point po_vendor_sites_all.fob_lookup_code%TYPE;

Line 20081: ap_invoice_lines_interface aili

20077: BEGIN
20078: SELECT aii.invoice_type_lookup_code
20079: INTO l_inv_hdr_inv_type
20080: FROM ap_invoices_interface aii,
20081: ap_invoice_lines_interface aili
20082: WHERE aii.invoice_id = aili.invoice_id
20083: AND aili.ROWID = p_invoice_lines_rec.row_id;
20084:
20085: IF (AP_IMPORT_INVOICES_PKG.g_debug_switch = 'Y') THEN

Line 20202: ap_invoice_lines_interface aili

20198: l_inv_hdr_vendor_id,
20199: l_inv_hdr_vendor_site_id,
20200: l_inv_hdr_inv_type
20201: FROM ap_invoices_interface aii,
20202: ap_invoice_lines_interface aili
20203: WHERE aii.invoice_id = aili.invoice_id
20204: AND aili.ROWID = p_invoice_lines_rec.row_id;
20205:
20206: IF (AP_IMPORT_INVOICES_PKG.g_debug_switch = 'Y') THEN

Line 20409: l_purchasing_category_id AP_INVOICE_LINES_ALL.PURCHASING_CATEGORY_ID%TYPE;

20405: p_calling_sequence IN VARCHAR2) RETURN BOOLEAN
20406:
20407: IS
20408: purch_category_check_failure EXCEPTION;
20409: l_purchasing_category_id AP_INVOICE_LINES_ALL.PURCHASING_CATEGORY_ID%TYPE;
20410: l_current_invoice_status VARCHAR2(1) := 'Y';
20411: current_calling_sequence VARCHAR2(2000);
20412: debug_info VARCHAR2(500);
20413:

Line 20625: l_cost_factor_id AP_INVOICE_LINES_ALL.COST_FACTOR_ID%TYPE;

20621: p_calling_sequence IN VARCHAR2) RETURN BOOLEAN
20622:
20623: IS
20624: cost_factor_check_failure EXCEPTION;
20625: l_cost_factor_id AP_INVOICE_LINES_ALL.COST_FACTOR_ID%TYPE;
20626: l_valid_cost_factor VARCHAR2(1);
20627: l_current_invoice_status VARCHAR2(1) := 'Y';
20628: current_calling_sequence VARCHAR2(2000);
20629: debug_info VARCHAR2(500);

Line 20836: l_retained_amount := ap_invoice_lines_utility_pkg.get_retained_amount

20832: AP_IMPORT_UTILITIES_PKG.Print(
20833: AP_IMPORT_INVOICES_PKG.g_debug_switch, debug_info);
20834: END IF;
20835:
20836: l_retained_amount := ap_invoice_lines_utility_pkg.get_retained_amount
20837: (p_invoice_lines_rec.po_line_location_id,
20838: p_invoice_lines_rec.amount);
20839:
20840: --------------------------------------------------------------------------