APPS.CTO_UPDATE_BOM_RTG_PK dependencies on MTL_DESCR_ELEMENT_VALUES

Line 4864: Update MTL_DESCR_ELEMENT_VALUES table

4860:
4861: xRtgId := lCfgRtgId;
4862:
4863: /*-----------------------------------------------------------+
4864: Update MTL_DESCR_ELEMENT_VALUES table
4865: +------------------------------------------------------------*/
4866:
4867: xTableName := 'MTL_DESCR_ELEMENT_VALUES';
4868: lStmtNum := 330;

Line 4867: xTableName := 'MTL_DESCR_ELEMENT_VALUES';

4863: /*-----------------------------------------------------------+
4864: Update MTL_DESCR_ELEMENT_VALUES table
4865: +------------------------------------------------------------*/
4866:
4867: xTableName := 'MTL_DESCR_ELEMENT_VALUES';
4868: lStmtNum := 330;
4869:
4870:
4871: if CTO_CUSTOM_CATALOG_DESC.catalog_desc_method = 'C' then

Line 4879: from mtl_descr_element_values

4875:
4876: DECLARE
4877: cursor ctg is
4878: select ELEMENT_NAME
4879: from mtl_descr_element_values
4880: where inventory_item_id = pConfigId;
4881:
4882: l_catalog_dtls CTO_CUSTOM_CATALOG_DESC.CATALOG_DTLS_TBL_TYPE;
4883: l_params CTO_CUSTOM_CATALOG_DESC.INPARAMS;

Line 4941: update MTL_DESCR_ELEMENT_VALUES i

4937: '; l_catalog_dtls('||k||').cat_element_value = '||
4938: l_catalog_dtls(k).cat_element_value, 5);
4939: lStmtNum := 331;
4940:
4941: update MTL_DESCR_ELEMENT_VALUES i
4942: set i.element_value = l_catalog_dtls(k).cat_element_value
4943: where i.inventory_item_id = pConfigId
4944: and i.element_name = l_catalog_dtls(k).cat_element_name;
4945:

Line 4956: update MTL_DESCR_ELEMENT_VALUES i

4952:
4953: elsif CTO_CUSTOM_CATALOG_DESC.catalog_desc_method = 'Y' then
4954: lStmtNum := 332;
4955: WriteToLog ('Std feature : Rollup lower level model catalog desc to top level', 4);
4956: update MTL_DESCR_ELEMENT_VALUES i
4957: set i.element_value =
4958: ( select /*+ ORDERED */
4959: NVL(max(v.element_value),i.element_value)
4960: from

Line 4965: mtl_descr_element_values v

4961: bom_bill_of_materials bi,
4962: bom_inventory_components bc1,
4963: bom_inventory_components bc2,
4964: bom_dependent_desc_elements be,
4965: mtl_descr_element_values v
4966: where bi.assembly_item_id = pConfigId
4967: and bi.organization_id = pOrgId
4968: and bi.alternate_bom_Designator is null
4969: and bc1.bill_sequence_id = bi.bill_sequence_id

Line 4984: update MTL_DESCR_ELEMENT_VALUES i

4980:
4981: lStmtNum := 333;
4982: WriteToLog ('Std feature : DO NOT Rollup lower level model catalog desc to top level', 4);
4983:
4984: update MTL_DESCR_ELEMENT_VALUES i
4985: set i.element_value =
4986: ( select /*+ ORDERED */
4987: NVL(max(v.element_value),i.element_value)
4988: from

Line 4993: mtl_descr_element_values v

4989: bom_bill_of_materials bi,
4990: bom_inventory_components bc1,
4991: bom_inventory_components bc2,
4992: bom_dependent_desc_elements be,
4993: mtl_descr_element_values v
4994: where bi.assembly_item_id = pConfigId
4995: and bi.organization_id = pOrgId
4996: and bi.alternate_bom_Designator is null
4997: and bc1.bill_sequence_id = bi.bill_sequence_id

Line 6781: from mtl_descr_element_values

6777: ** Create cursor to retrieve all descriptive element values for the item
6778: */
6779: CURSOR cc is
6780: select element_value
6781: from mtl_descr_element_values
6782: where inventory_item_id = item_id
6783: and element_value is not NULL
6784: and default_element_flag = 'Y'
6785: order by element_sequence;