DBA Data[Home] [Help]

APPS.CTO_CONFIG_BOM_PK dependencies on MTL_DESCR_ELEMENT_VALUES

Line 3561: Update MTL_DESCR_ELEMENT_VALUES table

3557: -- end 3674833
3558:
3559:
3560: /*-----------------------------------------------------------+
3561: Update MTL_DESCR_ELEMENT_VALUES table
3562: +------------------------------------------------------------*/
3563:
3564: xTableName := 'MTL_DESCR_ELEMENT_VALUES';
3565: lStmtNum := 330;

Line 3564: xTableName := 'MTL_DESCR_ELEMENT_VALUES';

3560: /*-----------------------------------------------------------+
3561: Update MTL_DESCR_ELEMENT_VALUES table
3562: +------------------------------------------------------------*/
3563:
3564: xTableName := 'MTL_DESCR_ELEMENT_VALUES';
3565: lStmtNum := 330;
3566:
3567: -- bugfix 2765635: This is a round-about fix for this issue by calling a custom-hook.
3568: -- Refer bug for details.

Line 3581: from mtl_descr_element_values

3577:
3578: DECLARE
3579: cursor ctg is
3580: select ELEMENT_NAME
3581: from mtl_descr_element_values
3582: where inventory_item_id = pConfigId;
3583:
3584: l_catalog_dtls CTO_CUSTOM_CATALOG_DESC.CATALOG_DTLS_TBL_TYPE;
3585: l_params CTO_CUSTOM_CATALOG_DESC.INPARAMS;

Line 3657: update MTL_DESCR_ELEMENT_VALUES i

3653: END IF;
3654:
3655: lStmtNum := 331;
3656:
3657: update MTL_DESCR_ELEMENT_VALUES i
3658: set i.element_value = l_catalog_dtls(k).cat_element_value
3659: where i.inventory_item_id = pConfigId
3660: and i.element_name = l_catalog_dtls(k).cat_element_name;
3661: IF PG_DEBUG <> 0 THEN

Line 3677: update MTL_DESCR_ELEMENT_VALUES i

3673: lStmtNum := 332;
3674: IF PG_DEBUG <> 0 THEN
3675: oe_debug_pub.add ('Std feature : Rollup lower level model catalog desc to top level');
3676: END IF;
3677: update MTL_DESCR_ELEMENT_VALUES i
3678: set i.element_value =
3679: ( select /*+ ORDERED */
3680: NVL(max(v.element_value),i.element_value)
3681: from

Line 3687: mtl_descr_element_values v

3683: bom_inventory_components bc1,
3684: bom_inventory_components bc2,
3685: bom_bill_of_materials bi2, -- for model -- BUG 13693029 -- moved for pref
3686: bom_dependent_desc_elements be,
3687: mtl_descr_element_values v
3688: where bi.assembly_item_id = pConfigId
3689: and bi.organization_id = pOrgId
3690: and bi.alternate_bom_Designator is null
3691: and bi.organization_id = bi2.organization_id -- added for pref

Line 3711: update MTL_DESCR_ELEMENT_VALUES i

3707: lStmtNum := 333;
3708: IF PG_DEBUG <> 0 THEN
3709: oe_debug_pub.add ('Std feature : DO NOT Rollup lower level model catalog desc to top level');
3710: END IF;
3711: update MTL_DESCR_ELEMENT_VALUES i
3712: set i.element_value =
3713: ( select /*+ ORDERED */
3714: NVL(max(v.element_value),i.element_value)
3715: from

Line 3721: mtl_descr_element_values v

3717: bom_inventory_components bc1,
3718: bom_inventory_components bc2,
3719: bom_bill_of_materials bi2, -- for model -- BUG 13693029 -- moved for pref
3720: bom_dependent_desc_elements be,
3721: mtl_descr_element_values v
3722: where bi.assembly_item_id = pConfigId
3723: and bi.organization_id = pOrgId
3724: and bi.alternate_bom_Designator is null
3725: and bi.organization_id = bi2.organization_id -- added for pref

Line 5391: from mtl_descr_element_values

5387: ** Create cursor to retrieve all descriptive element values for the item
5388: */
5389: CURSOR cc is
5390: select element_value
5391: from mtl_descr_element_values
5392: where inventory_item_id = item_id
5393: and element_value is not NULL
5394: and default_element_flag = 'Y'
5395: order by element_sequence;