DBA Data[Home] [Help]

APPS.INV_MGD_MVT_FIN_MDTR dependencies on RCV_SHIPMENT_LINES

Line 2451: , rcv_shipment_lines rsl

2447: , AP_INVOICE_LINES_ALL aila
2448: , RA_CUSTOMER_TRX_LINES_ALL rctla
2449: , ra_customer_trx_all rcta
2450: , rcv_transactions rcv
2451: , rcv_shipment_lines rsl
2452: , mtl_material_transactions mmt
2453: WHERE aia.invoice_id = aila.invoice_id
2454: AND aia.cancelled_date IS NULL
2455: AND aila.line_type_lookup_code = 'ITEM'

Line 2560: --RMA information is not available in wdd. Also, the field rcv_shipment_lines.mmt_transaction_id

2556: AND mmt_logical.transaction_type_id = 11 -- to identify logical
2557: );
2558:
2559: --Bugfix 12949295: AP Invoice cursor for RMA transactions.
2560: --RMA information is not available in wdd. Also, the field rcv_shipment_lines.mmt_transaction_id
2561: --is null for RMA. SO the first two AP Intercompany cursors cannot be used.
2562: CURSOR l_ap_intercompany_rma IS
2563: SELECT
2564: aia.invoice_id

Line 2621: , rcv_shipment_lines rsl

2617: FROM
2618: AP_INVOICES_ALL aia
2619: , RA_CUSTOMER_TRX_LINES_ALL rctla
2620: , rcv_transactions rcv
2621: , rcv_shipment_lines rsl
2622: , mtl_material_transactions mmt
2623: WHERE aia.invoice_id = x_movement_transaction.invoice_id
2624: AND aia.reference_1 = TO_CHAR(rctla.customer_trx_id)
2625: AND rctla.sales_order = to_char(l_movement_transaction.order_number)