APPS.INV_LOT_SERIAL_DATE_EVENT_PKG dependencies on MTL_SYSTEM_ITEMS_KFV

Line 37: , mtl_system_items_kfv msi

33: , ohd.secondary_transaction_quantity
34: , expiration_date date_column
35: FROM mtl_lot_numbers mln
36: , mtl_parameters mtp
37: , mtl_system_items_kfv msi
38: , mtl_onhand_quantities_detail ohd;
39:
40: CURSOR cur_serial_template IS
41: SELECT mtp.organization_code

Line 54: , mtl_system_items_kfv msi

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:
57: CURSOR cur_category (
58: p_org_id NUMBER

Line 188: ' mtl_lot_numbers mln, mtl_parameters mtp, mtl_system_items_kfv msi, '

184: || ' sum(ohd.secondary_transaction_quantity) secondary_transaction_quantity, '
185: || p_date_type
186: || ' date_column ';
187: l_lot_table_list :=
188: ' mtl_lot_numbers mln, mtl_parameters mtp, mtl_system_items_kfv msi, '
189: || ' mtl_onhand_quantities_detail ohd ';
190: l_lot_where_clause :=
191: ' mtp.organization_id = :b_organization_id '
192: || ' and mtp.organization_id = msi.organization_id '

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 '