DBA Data[Home] [Help]

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 190: ' mtl_lot_numbers mln, mtl_parameters mtp, mtl_system_items_kfv msi, '

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

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

496: || ' msn.current_status, mfgl.meaning serial_status, '
497: || p_date_type
498: || ' date_column ';
499: l_serial_table_list :=
500: ' mtl_serial_numbers msn, mtl_parameters mtp, mtl_system_items_kfv msi, '
501: || ' mfg_lookups mfgl ';
502: l_serial_where_clause :=
503: ' mtp.organization_id = :b_organization_id '
504: || ' and mtp.organization_id = msi.organization_id '