DBA Data[Home] [Help]

APPS.INV_LOT_SERIAL_DATE_EVENT_PKG dependencies on MTL_SERIAL_NUMBERS

Line 52: FROM mtl_serial_numbers msn

48: , msn.gen_object_id
49: , msn.current_status
50: , mfgl.meaning serial_status
51: , msn.initialization_date date_column
52: FROM mtl_serial_numbers msn
53: , mtl_parameters mtp
54: , mtl_system_items_kfv msi
55: , mfg_lookups mfgl;
56:

Line 485: ' mtl_serial_numbers msn, mtl_parameters mtp, mtl_system_items_kfv msi, '

481: || ' msn.current_status, mfgl.meaning serial_status, '
482: || p_date_type
483: || ' date_column ';
484: l_serial_table_list :=
485: ' mtl_serial_numbers msn, mtl_parameters mtp, mtl_system_items_kfv msi, '
486: || ' mfg_lookups mfgl ';
487: l_serial_where_clause :=
488: ' mtp.organization_id = :b_organization_id '
489: || ' and mtp.organization_id = msi.organization_id '