DBA Data[Home] [Help]

APPS.INV_CR_ASN_DETAILS dependencies on MTL_TXN_REQUEST_LINES

Line 711: from mtl_txn_request_lines

707: END IF;
708:
709: select quantity
710: into p_lot_quantity
711: from mtl_txn_request_lines
712: where organization_id = l_create_asn_details_rec.organization_id
713: and inventory_item_id = l_create_asn_details_rec.ITEM_ID
714: and lot_number = l_create_asn_details_rec.LOT_NUMBER_ACTUAL
715: and reference = 'SHIPMENT_LINE_ID'