DBA Data[Home] [Help]

APPS.INV_CR_ASN_DETAILS dependencies on MTL_SERIAL_NUMBERS

Line 753: from mtl_serial_numbers msn

749: -- Insert The Related Serial Rows
750:
751: For c_Serial in
752: (select msn.serial_number serial_number
753: from mtl_serial_numbers msn
754: where msn.inventory_item_id = p_rcv_rcpt_rec.item_id
755: and ( l_create_asn_details_rec.lot_number_actual is not null
756: and msn.lot_number = l_create_asn_details_rec.lot_number_actual)
757: and msn.lpn_id = c_lpn_actual.lpn_id

Line 780: from mtl_serial_numbers msn

776: else
777: -- Insert The Related Serial Rows
778: For c_Serial in
779: (select msn.serial_number serial_number
780: from mtl_serial_numbers msn
781: where msn.inventory_item_id = p_rcv_rcpt_rec.item_id
782: and msn.lpn_id = c_lpn_actual.lpn_id
783: )
784: loop

Line 1029: from mtl_serial_numbers

1025:
1026: For c_Serial in
1027: (select serial_number,
1028: lot_number
1029: from mtl_serial_numbers
1030: where inventory_item_id = p_interface_transaction_rec.item_id
1031: and lpn_id = c_lpn.lpn_id
1032: )
1033: loop