DBA Data[Home] [Help]

APPS.POS_ASN_CREATE_PVT dependencies on MTL_TRANSACTION_LOTS_INTERFACE

Line 212: * Effects: This procedure inserts the record into MTL_TRANSACTION_LOTS_INTERFACE

208: * Public Procedure: insert_mtli
209: * Requires: p_api_version, p_transaction_interface_id, p_lot_number
210: * p_transaction_quantity, p_transaction_uom, p_po_line_loc_id,
211: * p_product_transaction_id
212: * Effects: This procedure inserts the record into MTL_TRANSACTION_LOTS_INTERFACE
213: * table during the creation of ASN.
214: * Returns: x_return_status, x_msg_count, x_msg_data, p_transaction_interface_id,
215: * x_serial_transaction_temp_id, p_product_transaction_id
216: *

Line 1365: mtl_transaction_lots_interface mtli

1361:
1362: select count(*)
1363: into l_rows
1364: from rcv_transactions_interface rti,
1365: mtl_transaction_lots_interface mtli
1366: where rti.INTERFACE_TRANSACTION_ID = mtli.PRODUCT_TRANSACTION_ID
1367: and mtli.PRODUCT_CODE = 'RCV'
1368: and rti.INTERFACE_TRANSACTION_ID = p_asn_line_id
1369: and mtli.LOT_NUMBER is not null;