APPS.CTO_UPDATE_BOM_RTG_PK dependencies on MTL_DESCR_ELEMENT_VALUES

Line 5063: Update MTL_DESCR_ELEMENT_VALUES table

5059:
5060: xRtgId := lCfgRtgId;
5061:
5062: /*-----------------------------------------------------------+
5063: Update MTL_DESCR_ELEMENT_VALUES table
5064: +------------------------------------------------------------*/
5065:
5066: xTableName := 'MTL_DESCR_ELEMENT_VALUES';
5067: lStmtNum := 330;

Line 5066: xTableName := 'MTL_DESCR_ELEMENT_VALUES';

5062: /*-----------------------------------------------------------+
5063: Update MTL_DESCR_ELEMENT_VALUES table
5064: +------------------------------------------------------------*/
5065:
5066: xTableName := 'MTL_DESCR_ELEMENT_VALUES';
5067: lStmtNum := 330;
5068:
5069:
5070: if CTO_CUSTOM_CATALOG_DESC.catalog_desc_method = 'C' then

Line 5078: from mtl_descr_element_values

5074:
5075: DECLARE
5076: cursor ctg is
5077: select ELEMENT_NAME
5078: from mtl_descr_element_values
5079: where inventory_item_id = pConfigId;
5080:
5081: l_catalog_dtls CTO_CUSTOM_CATALOG_DESC.CATALOG_DTLS_TBL_TYPE;
5082: l_params CTO_CUSTOM_CATALOG_DESC.INPARAMS;

Line 5140: update MTL_DESCR_ELEMENT_VALUES i

5136: '; l_catalog_dtls('||k||').cat_element_value = '||
5137: l_catalog_dtls(k).cat_element_value, 5);
5138: lStmtNum := 331;
5139:
5140: update MTL_DESCR_ELEMENT_VALUES i
5141: set i.element_value = l_catalog_dtls(k).cat_element_value
5142: where i.inventory_item_id = pConfigId
5143: and i.element_name = l_catalog_dtls(k).cat_element_name;
5144:

Line 5155: update MTL_DESCR_ELEMENT_VALUES i

5151:
5152: elsif CTO_CUSTOM_CATALOG_DESC.catalog_desc_method = 'Y' then
5153: lStmtNum := 332;
5154: WriteToLog ('Std feature : Rollup lower level model catalog desc to top level', 4);
5155: update MTL_DESCR_ELEMENT_VALUES i
5156: set i.element_value =
5157: ( select /*+ ORDERED */
5158: NVL(max(v.element_value),i.element_value)
5159: from

Line 5164: mtl_descr_element_values v

5160: bom_bill_of_materials bi,
5161: bom_inventory_components bc1,
5162: bom_inventory_components bc2,
5163: bom_dependent_desc_elements be,
5164: mtl_descr_element_values v
5165: where bi.assembly_item_id = pConfigId
5166: and bi.organization_id = pOrgId
5167: and bi.alternate_bom_Designator is null
5168: and bc1.bill_sequence_id = bi.bill_sequence_id

Line 5183: update MTL_DESCR_ELEMENT_VALUES i

5179:
5180: lStmtNum := 333;
5181: WriteToLog ('Std feature : DO NOT Rollup lower level model catalog desc to top level', 4);
5182:
5183: update MTL_DESCR_ELEMENT_VALUES i
5184: set i.element_value =
5185: ( select /*+ ORDERED */
5186: NVL(max(v.element_value),i.element_value)
5187: from

Line 5192: mtl_descr_element_values v

5188: bom_bill_of_materials bi,
5189: bom_inventory_components bc1,
5190: bom_inventory_components bc2,
5191: bom_dependent_desc_elements be,
5192: mtl_descr_element_values v
5193: where bi.assembly_item_id = pConfigId
5194: and bi.organization_id = pOrgId
5195: and bi.alternate_bom_Designator is null
5196: and bc1.bill_sequence_id = bi.bill_sequence_id

Line 6993: from mtl_descr_element_values

6989: ** Create cursor to retrieve all descriptive element values for the item
6990: */
6991: CURSOR cc is
6992: select element_value
6993: from mtl_descr_element_values
6994: where inventory_item_id = item_id
6995: and element_value is not NULL
6996: and default_element_flag = 'Y'
6997: order by element_sequence;