APPS.CTO_CONFIG_BOM_PK dependencies on MTL_DESCR_ELEMENT_VALUES

Line 3469: Update MTL_DESCR_ELEMENT_VALUES table

3465: -- end 3674833
3466:
3467:
3468: /*-----------------------------------------------------------+
3469: Update MTL_DESCR_ELEMENT_VALUES table
3470: +------------------------------------------------------------*/
3471:
3472: xTableName := 'MTL_DESCR_ELEMENT_VALUES';
3473: lStmtNum := 330;

Line 3472: xTableName := 'MTL_DESCR_ELEMENT_VALUES';

3468: /*-----------------------------------------------------------+
3469: Update MTL_DESCR_ELEMENT_VALUES table
3470: +------------------------------------------------------------*/
3471:
3472: xTableName := 'MTL_DESCR_ELEMENT_VALUES';
3473: lStmtNum := 330;
3474:
3475: -- bugfix 2765635: This is a round-about fix for this issue by calling a custom-hook.
3476: -- Refer bug for details.

Line 3489: from mtl_descr_element_values

3485:
3486: DECLARE
3487: cursor ctg is
3488: select ELEMENT_NAME
3489: from mtl_descr_element_values
3490: where inventory_item_id = pConfigId;
3491:
3492: l_catalog_dtls CTO_CUSTOM_CATALOG_DESC.CATALOG_DTLS_TBL_TYPE;
3493: l_params CTO_CUSTOM_CATALOG_DESC.INPARAMS;

Line 3565: update MTL_DESCR_ELEMENT_VALUES i

3561: END IF;
3562:
3563: lStmtNum := 331;
3564:
3565: update MTL_DESCR_ELEMENT_VALUES i
3566: set i.element_value = l_catalog_dtls(k).cat_element_value
3567: where i.inventory_item_id = pConfigId
3568: and i.element_name = l_catalog_dtls(k).cat_element_name;
3569: IF PG_DEBUG <> 0 THEN

Line 3585: update MTL_DESCR_ELEMENT_VALUES i

3581: lStmtNum := 332;
3582: IF PG_DEBUG <> 0 THEN
3583: oe_debug_pub.add ('Std feature : Rollup lower level model catalog desc to top level');
3584: END IF;
3585: update MTL_DESCR_ELEMENT_VALUES i
3586: set i.element_value =
3587: ( select /*+ ORDERED */
3588: NVL(max(v.element_value),i.element_value)
3589: from

Line 3594: mtl_descr_element_values v

3590: bom_bill_of_materials bi,
3591: bom_inventory_components bc1,
3592: bom_inventory_components bc2,
3593: bom_dependent_desc_elements be,
3594: mtl_descr_element_values v
3595: where bi.assembly_item_id = pConfigId
3596: and bi.organization_id = pOrgId
3597: and bi.alternate_bom_Designator is null
3598: and bc1.bill_sequence_id = bi.bill_sequence_id

Line 3615: update MTL_DESCR_ELEMENT_VALUES i

3611: lStmtNum := 333;
3612: IF PG_DEBUG <> 0 THEN
3613: oe_debug_pub.add ('Std feature : DO NOT Rollup lower level model catalog desc to top level');
3614: END IF;
3615: update MTL_DESCR_ELEMENT_VALUES i
3616: set i.element_value =
3617: ( select /*+ ORDERED */
3618: NVL(max(v.element_value),i.element_value)
3619: from

Line 3624: mtl_descr_element_values v

3620: bom_bill_of_materials bi,
3621: bom_inventory_components bc1,
3622: bom_inventory_components bc2,
3623: bom_dependent_desc_elements be,
3624: mtl_descr_element_values v
3625: where bi.assembly_item_id = pConfigId
3626: and bi.organization_id = pOrgId
3627: and bi.alternate_bom_Designator is null
3628: and bc1.bill_sequence_id = bi.bill_sequence_id

Line 5079: from mtl_descr_element_values

5075: ** Create cursor to retrieve all descriptive element values for the item
5076: */
5077: CURSOR cc is
5078: select element_value
5079: from mtl_descr_element_values
5080: where inventory_item_id = item_id
5081: and element_value is not NULL
5082: and default_element_flag = 'Y'
5083: order by element_sequence;