DBA Data[Home] [Help]

APPS.INV_MGD_MVT_FIN_MDTR dependencies on AP_INVOICE_LINES_ALL

Line 691: , AP_INVOICE_LINES_ALL aila

687: SELECT
688: SUM(NVL(aila.amount,rctla.extended_amount))
689: FROM
690: AP_INVOICES_ALL aia
691: , AP_INVOICE_LINES_ALL aila
692: , RA_CUSTOMER_TRX_LINES_ALL rctla
693: , ra_customer_trx_all rcta
694: , oe_order_lines_all oola
695: WHERE aia.invoice_id = aila.invoice_id

Line 1111: AP_INVOICE_LINES_ALL aila

1107: SUM(aila.amount)
1108: , SUM(aila.quantity_invoiced)
1109: FROM
1110: AP_INVOICES_ALL aia,
1111: AP_INVOICE_LINES_ALL aila
1112: WHERE aia.invoice_id = aila.invoice_id
1113: AND aia.invoice_type_lookup_code in ('CREDIT','DEBIT')
1114: AND aila.rcv_transaction_id = l_parent_transaction_id
1115: AND aila.line_type_lookup_code = 'ITEM'

Line 1160: , AP_INVOICE_LINES_ALL aila

1156: FROM
1157: PO_HEADERS_ALL pha
1158: , PO_DISTRIBUTIONS_ALL pda
1159: , AP_INVOICES_ALL aia
1160: , AP_INVOICE_LINES_ALL aila
1161: WHERE pha.po_header_id = pda.po_header_id
1162: AND aia.invoice_id = aila.invoice_id
1163: AND pda.po_header_id = aila.po_header_id /*Bug 7446311 Joined to imporve performance*/
1164: AND pda.po_distribution_id = aila.po_distribution_id

Line 2220: , AP_INVOICE_LINES_ALL aila

2216: , SUM(NVL(aila.amount, 0))
2217: , SUM(NVL(aila.quantity_invoiced,0))
2218: FROM
2219: AP_INVOICES_ALL aia
2220: , AP_INVOICE_LINES_ALL aila
2221: , RA_CUSTOMER_TRX_LINES_ALL rctla
2222: , ra_customer_trx_all rcta
2223: WHERE aia.invoice_id = aila.invoice_id
2224: AND aia.cancelled_date IS NULL

Line 2331: , ap_invoice_lines_all aila

2327: , MAX(aia.invoice_id)
2328: , SUM(aila.quantity_invoiced)
2329: FROM
2330: ap_invoices_all aia
2331: , ap_invoice_lines_all aila
2332: WHERE aia.invoice_id = aila.invoice_id
2333: AND aia.invoice_type_lookup_code in ('STANDARD','MIXED')
2334: AND aia.cancelled_date IS NULL
2335: AND aila.line_type_lookup_code = 'ITEM'

Line 2367: , ap_invoice_lines_all aila

2363: SELECT
2364: SUM(aila.amount)
2365: FROM
2366: ap_invoices_all aia
2367: , ap_invoice_lines_all aila
2368: WHERE aia.invoice_id = aila.invoice_id
2369: AND aia.cancelled_date IS NULL
2370: AND aila.line_type_lookup_code = 'ITEM'
2371: AND aila.match_type = 'PRICE_CORRECTION'

Line 2397: , ap_invoice_lines_all aila

2393: SUM(aila.quantity_invoiced)
2394: , SUM(aila.amount)
2395: FROM
2396: ap_invoices_all aia
2397: , ap_invoice_lines_all aila
2398: WHERE aia.invoice_id = aila.invoice_id
2399: AND aia.cancelled_date IS NULL
2400: AND aila.line_type_lookup_code = 'ITEM'
2401: AND aila.match_type = 'QTY_CORRECTION'

Line 2431: , ap_invoice_lines_all aila

2427: , MAX(aia.invoice_id)
2428: , SUM(aila.quantity_invoiced)
2429: FROM
2430: ap_invoices_all aia
2431: , ap_invoice_lines_all aila
2432: WHERE aia.invoice_id = aila.invoice_id
2433: AND aia.invoice_type_lookup_code in ('CREDIT','DEBIT')
2434: AND aia.cancelled_date IS NULL
2435: AND aila.line_type_lookup_code = 'ITEM'

Line 2466: , ap_invoice_lines_all aila

2462: , MAX(aia.invoice_id)
2463: , sum(aila.quantity_invoiced)
2464: FROM
2465: ap_invoices_all aia
2466: , ap_invoice_lines_all aila
2467: WHERE aia.invoice_id = aila.invoice_id
2468: AND aia.invoice_type_lookup_code in ('STANDARD','MIXED')
2469: AND aia.cancelled_date IS NULL
2470: AND aila.line_type_lookup_code = 'ITEM'

Line 2502: , ap_invoice_lines_all aila

2498: SELECT
2499: SUM(aila.amount)
2500: FROM
2501: ap_invoices_all aia
2502: , ap_invoice_lines_all aila
2503: WHERE aia.invoice_id = aila.invoice_id
2504: AND aia.cancelled_date IS NULL
2505: AND aila.line_type_lookup_code = 'ITEM'
2506: AND aila.match_type = 'PRICE_CORRECTION'

Line 2533: , ap_invoice_lines_all aila

2529: SUM(aila.quantity_invoiced)
2530: , SUM(aila.amount)
2531: FROM
2532: ap_invoices_all aia
2533: , ap_invoice_lines_all aila
2534: WHERE aia.invoice_id = aila.invoice_id
2535: AND aia.cancelled_date IS NULL
2536: AND aila.line_type_lookup_code = 'ITEM'
2537: AND aila.match_type = 'QTY_CORRECTION'

Line 2567: , ap_invoice_lines_all aila

2563: , MAX(aia.invoice_id)
2564: , sum(aila.quantity_invoiced)
2565: FROM
2566: ap_invoices_all aia
2567: , ap_invoice_lines_all aila
2568: WHERE aia.invoice_id = aila.invoice_id
2569: AND aia.invoice_type_lookup_code in ('CREDIT','DEBIT')
2570: AND aia.cancelled_date IS NULL
2571: AND aila.line_type_lookup_code = 'ITEM'