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 FND_DESCR_FLEX_COL_USAGE_VL

Line 125: l_attr_context fnd_descr_flex_col_usage_vl.descriptive_flex_context_code%TYPE;

121: l_serial_column_list VARCHAR2 (2000);
122: l_serial_table_list VARCHAR2 (2000);
123: l_serial_where_clause VARCHAR2 (2000);
124: l_onhand_qty_uom VARCHAR2 (100);
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';

Line 126: l_attr_ctxt fnd_descr_flex_col_usage_vl.descriptive_flex_context_code%TYPE;

122: l_serial_table_list VARCHAR2 (2000);
123: l_serial_where_clause VARCHAR2 (2000);
124: l_onhand_qty_uom VARCHAR2 (100);
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();

Line 127: l_user_column_name fnd_descr_flex_col_usage_vl.end_user_column_name%TYPE;

123: l_serial_where_clause VARCHAR2 (2000);
124: l_onhand_qty_uom VARCHAR2 (100);
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;

Line 165: FROM fnd_descr_flex_col_usage_vl

161:
162: IF l_attr_ctxt <> ' ' THEN
163: SELECT end_user_column_name
164: INTO l_user_column_name
165: FROM fnd_descr_flex_col_usage_vl
166: WHERE application_id = 401
167: AND descriptive_flexfield_name =
168: DECODE (p_query_for
169: , 'LOT', 'Lot Attributes'