APPS.BOMPLDCB dependencies on MTL_DESC_ELEM_VAL_INTERFACE

Line 92: from mtl_desc_elem_val_interface

88: ** Create cursor to retrieve all descriptive element values for the item
89: */
90: CURSOR cc is
91: select element_value
92: from mtl_desc_elem_val_interface
93: where inventory_item_id = item_id
94: and element_value is not NULL
95: and default_element_flag = 'Y'
96: order by element_sequence;

Line 2336: ** Update MTL_DESC_ELEM_VAL_INTERFACE table

2332: and r.component_sequence_id = ic.model_comp_seq_id
2333: and nvl(r.acd_type,0) <> 3;
2334:
2335: /*
2336: ** Update MTL_DESC_ELEM_VAL_INTERFACE table
2337: */
2338: table_name := 'MTL_DESC_ELEM_VAL_INTERFACE';
2339: stmt_num := 210;
2340: update MTL_DESC_ELEM_VAL_INTERFACE i

Line 2338: table_name := 'MTL_DESC_ELEM_VAL_INTERFACE';

2334:
2335: /*
2336: ** Update MTL_DESC_ELEM_VAL_INTERFACE table
2337: */
2338: table_name := 'MTL_DESC_ELEM_VAL_INTERFACE';
2339: stmt_num := 210;
2340: update MTL_DESC_ELEM_VAL_INTERFACE i
2341: set i.element_value =
2342: ( select /*+ ORDERED */

Line 2340: update MTL_DESC_ELEM_VAL_INTERFACE i

2336: ** Update MTL_DESC_ELEM_VAL_INTERFACE table
2337: */
2338: table_name := 'MTL_DESC_ELEM_VAL_INTERFACE';
2339: stmt_num := 210;
2340: update MTL_DESC_ELEM_VAL_INTERFACE i
2341: set i.element_value =
2342: ( select /*+ ORDERED */
2343: NVL(max(v.element_value),i.element_value)
2344: from