DBA Data[Home] [Help]

APPS.PO_MULTI_MOD_VALIDATIONS dependencies on AP_INVOICE_LINES_ALL

Line 3331: l_invoice_id AP_INVOICE_LINES_ALL.invoice_id%TYPE;

3327: l_receipt_required_flag PO_LINE_LOCATIONS_ALL.receipt_required_flag%TYPE;
3328: l_shipment_line_id_tbl PO_TBL_NUMBER;
3329: l_shipment_header_id RCV_SHIPMENT_HEADERS.shipment_header_id%TYPE;
3330: l_receipt_num RCV_SHIPMENT_HEADERS.receipt_num%TYPE;
3331: l_invoice_id AP_INVOICE_LINES_ALL.invoice_id%TYPE;
3332: l_match_exists VARCHAR2(1);
3333: l_unpaid_invoices_exists VARCHAR2(1);
3334: l_unval_invoice_exists VARCHAR2(1);
3335: l_receipt_date DATE;

Line 3736: FROM ap_invoice_lines_all apl

3732: --getting the matched invoices
3733: BEGIN
3734: SELECT apl.invoice_id, ap.invoice_num, ap.invoice_date, ap.invoice_amount
3735: BULK COLLECT INTO l_invoice_id_tbl, l_invoice_num_tbl,l_invoice_date_tbl, l_invoice_amount_tbl
3736: FROM ap_invoice_lines_all apl
3737: ,ap_invoices_all ap
3738: WHERE apl.invoice_id = ap.invoice_id
3739: AND apl.match_type = 'ITEM_TO_PO'
3740: AND apl.po_header_id = p_document_id_tbl(i);

Line 4095: FROM ap_invoice_lines_all inv,

4091:
4092: BEGIN
4093: SELECT 'Y'
4094: INTO l_match_exists
4095: FROM ap_invoice_lines_all inv,
4096: rcv_transactions rcvt
4097: WHERE inv.rcv_transaction_id = rcvt.transaction_id
4098: AND inv.match_type = 'ITEM_TO_RECEIPT'
4099: AND rcvt.shipment_line_id = p_shipment_line_id;

Line 4160: FROM ap_invoice_lines_all inv,

4156: d_position := 20;
4157: BEGIN
4158: SELECT inv.invoice_id
4159: INTO l_invoice_id
4160: FROM ap_invoice_lines_all inv,
4161: rcv_transactions rcvt
4162: WHERE inv.rcv_transaction_id = rcvt.transaction_id
4163: AND inv.match_type = 'ITEM_TO_RECEIPT'
4164: AND rcvt.shipment_line_id = p_doc_id;

Line 4176: FROM ap_invoice_lines_all

4172: d_position := 30;
4173: BEGIN
4174: SELECT invoice_id
4175: INTO l_invoice_id
4176: FROM ap_invoice_lines_all
4177: WHERE match_type = 'ITEM_TO_PO'
4178: AND po_header_id = p_doc_id;
4179: EXCEPTION
4180: WHEN no_data_found THEN

Line 4234: , ap_invoice_lines_all apl

4230: --bug13084712. Selecting the invoice id,invoice num and invoice date as they have to be displayed in the exceptions report.
4231: SELECT ap.invoice_id,ap.invoice_num, ap.invoice_date
4232: BULK COLLECT INTO x_invoice_id_tbl, x_invoice_num_tbl, x_invoice_date_tbl
4233: FROM ap_invoices_all ap
4234: , ap_invoice_lines_all apl
4235: WHERE ap.invoice_id = apl.invoice_id
4236: AND ap.vendor_id = p_vendor_id
4237: AND NVL(apl.match_type, 'NOT_MATCHED') = 'NOT_MATCHED';
4238: EXCEPTION

Line 4288: FROM ap_invoice_lines_all apl

4284: BEGIN
4285:
4286: SELECT ap.invoice_id,ap.invoice_num, ap.invoice_date
4287: BULK COLLECT INTO x_invoice_id_tbl, x_invoice_num_tbl, x_invoice_date_tbl
4288: FROM ap_invoice_lines_all apl
4289: ,ap_invoices_all ap
4290: WHERE apl.prepay_invoice_id = ap.invoice_id
4291: AND NVL(apl.match_type, 'NOT_MATCHED') = 'NOT_MATCHED'
4292: AND ap.invoice_type_lookup_code = 'PREPAYMENT'