eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.INV_LOT_SERIAL_DATE_EVENT_PKG dependencies on MFG_LOOKUPS

Line 55: , mfg_lookups mfgl;

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
59: , p_inv_item_id NUMBER

Line 129: l_lookup_type mfg_lookups.lookup_type%TYPE := 'SERIAL_NUM_STATUS';

125: l_attr_context fnd_descr_flex_col_usage_vl.descriptive_flex_context_code%TYPE;
126: l_attr_ctxt fnd_descr_flex_col_usage_vl.descriptive_flex_context_code%TYPE;
127: l_user_column_name fnd_descr_flex_col_usage_vl.end_user_column_name%TYPE;
128: l_expiration_action_code mtl_lot_numbers.expiration_action_code%TYPE;
129: l_lookup_type mfg_lookups.lookup_type%TYPE := 'SERIAL_NUM_STATUS';
130: l_parameter_list wf_parameter_list_t := wf_parameter_list_t();
131: l_transaction_id NUMBER;
132: l_user_id NUMBER;
133: l_ame_transaction_id VARCHAR2(4000);

Line 486: || ' mfg_lookups mfgl ';

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 '
490: || ' and msn.current_organization_id = msi.organization_id '