eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.INV_ITEM_PVT dependencies on MTL_SYSTEM_ITEMS

Line 601: IF l_status_attr = 'MTL_SYSTEM_ITEMS.BOM_ENABLED_FLAG' THEN

597: LOOP
598: FETCH status_attr_control INTO l_status_attr, l_status_ctrl;
599: EXIT when status_attr_control%NOTFOUND;
600:
601: IF l_status_attr = 'MTL_SYSTEM_ITEMS.BOM_ENABLED_FLAG' THEN
602: l_bom_enabled_status := l_status_ctrl;
603: ELSIF l_status_attr = 'MTL_SYSTEM_ITEMS.PURCHASING_ENABLED_FLAG' THEN
604: l_purchasable_status := l_status_ctrl;
605: ELSIF l_status_attr = 'MTL_SYSTEM_ITEMS.MTL_TRANSACTIONS_ENABLED_FLAG' THEN

Line 603: ELSIF l_status_attr = 'MTL_SYSTEM_ITEMS.PURCHASING_ENABLED_FLAG' THEN

599: EXIT when status_attr_control%NOTFOUND;
600:
601: IF l_status_attr = 'MTL_SYSTEM_ITEMS.BOM_ENABLED_FLAG' THEN
602: l_bom_enabled_status := l_status_ctrl;
603: ELSIF l_status_attr = 'MTL_SYSTEM_ITEMS.PURCHASING_ENABLED_FLAG' THEN
604: l_purchasable_status := l_status_ctrl;
605: ELSIF l_status_attr = 'MTL_SYSTEM_ITEMS.MTL_TRANSACTIONS_ENABLED_FLAG' THEN
606: l_transactable_status := l_status_ctrl;
607: ELSIF l_status_attr = 'MTL_SYSTEM_ITEMS.STOCK_ENABLED_FLAG' THEN

Line 605: ELSIF l_status_attr = 'MTL_SYSTEM_ITEMS.MTL_TRANSACTIONS_ENABLED_FLAG' THEN

601: IF l_status_attr = 'MTL_SYSTEM_ITEMS.BOM_ENABLED_FLAG' THEN
602: l_bom_enabled_status := l_status_ctrl;
603: ELSIF l_status_attr = 'MTL_SYSTEM_ITEMS.PURCHASING_ENABLED_FLAG' THEN
604: l_purchasable_status := l_status_ctrl;
605: ELSIF l_status_attr = 'MTL_SYSTEM_ITEMS.MTL_TRANSACTIONS_ENABLED_FLAG' THEN
606: l_transactable_status := l_status_ctrl;
607: ELSIF l_status_attr = 'MTL_SYSTEM_ITEMS.STOCK_ENABLED_FLAG' THEN
608: l_stockable_status := l_status_ctrl;
609: ELSIF l_status_attr = 'MTL_SYSTEM_ITEMS.BUILD_IN_WIP_FLAG' THEN

Line 607: ELSIF l_status_attr = 'MTL_SYSTEM_ITEMS.STOCK_ENABLED_FLAG' THEN

603: ELSIF l_status_attr = 'MTL_SYSTEM_ITEMS.PURCHASING_ENABLED_FLAG' THEN
604: l_purchasable_status := l_status_ctrl;
605: ELSIF l_status_attr = 'MTL_SYSTEM_ITEMS.MTL_TRANSACTIONS_ENABLED_FLAG' THEN
606: l_transactable_status := l_status_ctrl;
607: ELSIF l_status_attr = 'MTL_SYSTEM_ITEMS.STOCK_ENABLED_FLAG' THEN
608: l_stockable_status := l_status_ctrl;
609: ELSIF l_status_attr = 'MTL_SYSTEM_ITEMS.BUILD_IN_WIP_FLAG' THEN
610: l_wip_status := l_status_ctrl;
611: ELSIF l_status_attr = 'MTL_SYSTEM_ITEMS.CUSTOMER_ORDER_ENABLED_FLAG' THEN

Line 609: ELSIF l_status_attr = 'MTL_SYSTEM_ITEMS.BUILD_IN_WIP_FLAG' THEN

605: ELSIF l_status_attr = 'MTL_SYSTEM_ITEMS.MTL_TRANSACTIONS_ENABLED_FLAG' THEN
606: l_transactable_status := l_status_ctrl;
607: ELSIF l_status_attr = 'MTL_SYSTEM_ITEMS.STOCK_ENABLED_FLAG' THEN
608: l_stockable_status := l_status_ctrl;
609: ELSIF l_status_attr = 'MTL_SYSTEM_ITEMS.BUILD_IN_WIP_FLAG' THEN
610: l_wip_status := l_status_ctrl;
611: ELSIF l_status_attr = 'MTL_SYSTEM_ITEMS.CUSTOMER_ORDER_ENABLED_FLAG' THEN
612: l_cust_ord_status := l_status_ctrl;
613: ELSIF l_status_attr = 'MTL_SYSTEM_ITEMS.INTERNAL_ORDER_ENABLED_FLAG' THEN

Line 611: ELSIF l_status_attr = 'MTL_SYSTEM_ITEMS.CUSTOMER_ORDER_ENABLED_FLAG' THEN

607: ELSIF l_status_attr = 'MTL_SYSTEM_ITEMS.STOCK_ENABLED_FLAG' THEN
608: l_stockable_status := l_status_ctrl;
609: ELSIF l_status_attr = 'MTL_SYSTEM_ITEMS.BUILD_IN_WIP_FLAG' THEN
610: l_wip_status := l_status_ctrl;
611: ELSIF l_status_attr = 'MTL_SYSTEM_ITEMS.CUSTOMER_ORDER_ENABLED_FLAG' THEN
612: l_cust_ord_status := l_status_ctrl;
613: ELSIF l_status_attr = 'MTL_SYSTEM_ITEMS.INTERNAL_ORDER_ENABLED_FLAG' THEN
614: l_int_ord_status := l_status_ctrl;
615: ELSIF l_status_attr = 'MTL_SYSTEM_ITEMS.INVOICE_ENABLED_FLAG' THEN

Line 613: ELSIF l_status_attr = 'MTL_SYSTEM_ITEMS.INTERNAL_ORDER_ENABLED_FLAG' THEN

609: ELSIF l_status_attr = 'MTL_SYSTEM_ITEMS.BUILD_IN_WIP_FLAG' THEN
610: l_wip_status := l_status_ctrl;
611: ELSIF l_status_attr = 'MTL_SYSTEM_ITEMS.CUSTOMER_ORDER_ENABLED_FLAG' THEN
612: l_cust_ord_status := l_status_ctrl;
613: ELSIF l_status_attr = 'MTL_SYSTEM_ITEMS.INTERNAL_ORDER_ENABLED_FLAG' THEN
614: l_int_ord_status := l_status_ctrl;
615: ELSIF l_status_attr = 'MTL_SYSTEM_ITEMS.INVOICE_ENABLED_FLAG' THEN
616: l_invoiceable_status := l_status_ctrl;
617: END IF;

Line 615: ELSIF l_status_attr = 'MTL_SYSTEM_ITEMS.INVOICE_ENABLED_FLAG' THEN

611: ELSIF l_status_attr = 'MTL_SYSTEM_ITEMS.CUSTOMER_ORDER_ENABLED_FLAG' THEN
612: l_cust_ord_status := l_status_ctrl;
613: ELSIF l_status_attr = 'MTL_SYSTEM_ITEMS.INTERNAL_ORDER_ENABLED_FLAG' THEN
614: l_int_ord_status := l_status_ctrl;
615: ELSIF l_status_attr = 'MTL_SYSTEM_ITEMS.INVOICE_ENABLED_FLAG' THEN
616: l_invoiceable_status := l_status_ctrl;
617: END IF;
618:
619: END LOOP;

Line 629: IF l_attr_name = 'MTL_SYSTEM_ITEMS.BOM_ENABLED_FLAG' THEN

625: LOOP
626: FETCH status_attr_values INTO l_attr_name, l_attr_value;
627: EXIT when status_attr_values%NOTFOUND;
628:
629: IF l_attr_name = 'MTL_SYSTEM_ITEMS.BOM_ENABLED_FLAG' THEN
630: l_bom_enabled_value := l_attr_value;
631: ELSIF l_attr_name = 'MTL_SYSTEM_ITEMS.PURCHASING_ENABLED_FLAG' THEN
632: l_purchasable_value := l_attr_value;
633: ELSIF l_attr_name = 'MTL_SYSTEM_ITEMS.MTL_TRANSACTIONS_ENABLED_FLAG' THEN

Line 631: ELSIF l_attr_name = 'MTL_SYSTEM_ITEMS.PURCHASING_ENABLED_FLAG' THEN

627: EXIT when status_attr_values%NOTFOUND;
628:
629: IF l_attr_name = 'MTL_SYSTEM_ITEMS.BOM_ENABLED_FLAG' THEN
630: l_bom_enabled_value := l_attr_value;
631: ELSIF l_attr_name = 'MTL_SYSTEM_ITEMS.PURCHASING_ENABLED_FLAG' THEN
632: l_purchasable_value := l_attr_value;
633: ELSIF l_attr_name = 'MTL_SYSTEM_ITEMS.MTL_TRANSACTIONS_ENABLED_FLAG' THEN
634: l_transactable_value := l_attr_value;
635: ELSIF l_attr_name = 'MTL_SYSTEM_ITEMS.STOCK_ENABLED_FLAG' THEN

Line 633: ELSIF l_attr_name = 'MTL_SYSTEM_ITEMS.MTL_TRANSACTIONS_ENABLED_FLAG' THEN

629: IF l_attr_name = 'MTL_SYSTEM_ITEMS.BOM_ENABLED_FLAG' THEN
630: l_bom_enabled_value := l_attr_value;
631: ELSIF l_attr_name = 'MTL_SYSTEM_ITEMS.PURCHASING_ENABLED_FLAG' THEN
632: l_purchasable_value := l_attr_value;
633: ELSIF l_attr_name = 'MTL_SYSTEM_ITEMS.MTL_TRANSACTIONS_ENABLED_FLAG' THEN
634: l_transactable_value := l_attr_value;
635: ELSIF l_attr_name = 'MTL_SYSTEM_ITEMS.STOCK_ENABLED_FLAG' THEN
636: l_stockable_value := l_attr_value;
637: ELSIF l_attr_name = 'MTL_SYSTEM_ITEMS.BUILD_IN_WIP_FLAG' THEN

Line 635: ELSIF l_attr_name = 'MTL_SYSTEM_ITEMS.STOCK_ENABLED_FLAG' THEN

631: ELSIF l_attr_name = 'MTL_SYSTEM_ITEMS.PURCHASING_ENABLED_FLAG' THEN
632: l_purchasable_value := l_attr_value;
633: ELSIF l_attr_name = 'MTL_SYSTEM_ITEMS.MTL_TRANSACTIONS_ENABLED_FLAG' THEN
634: l_transactable_value := l_attr_value;
635: ELSIF l_attr_name = 'MTL_SYSTEM_ITEMS.STOCK_ENABLED_FLAG' THEN
636: l_stockable_value := l_attr_value;
637: ELSIF l_attr_name = 'MTL_SYSTEM_ITEMS.BUILD_IN_WIP_FLAG' THEN
638: l_wip_value := l_attr_value;
639: ELSIF l_attr_name = 'MTL_SYSTEM_ITEMS.CUSTOMER_ORDER_ENABLED_FLAG' THEN

Line 637: ELSIF l_attr_name = 'MTL_SYSTEM_ITEMS.BUILD_IN_WIP_FLAG' THEN

633: ELSIF l_attr_name = 'MTL_SYSTEM_ITEMS.MTL_TRANSACTIONS_ENABLED_FLAG' THEN
634: l_transactable_value := l_attr_value;
635: ELSIF l_attr_name = 'MTL_SYSTEM_ITEMS.STOCK_ENABLED_FLAG' THEN
636: l_stockable_value := l_attr_value;
637: ELSIF l_attr_name = 'MTL_SYSTEM_ITEMS.BUILD_IN_WIP_FLAG' THEN
638: l_wip_value := l_attr_value;
639: ELSIF l_attr_name = 'MTL_SYSTEM_ITEMS.CUSTOMER_ORDER_ENABLED_FLAG' THEN
640: l_cust_ord_value := l_attr_value;
641: ELSIF l_attr_name = 'MTL_SYSTEM_ITEMS.INTERNAL_ORDER_ENABLED_FLAG' THEN

Line 639: ELSIF l_attr_name = 'MTL_SYSTEM_ITEMS.CUSTOMER_ORDER_ENABLED_FLAG' THEN

635: ELSIF l_attr_name = 'MTL_SYSTEM_ITEMS.STOCK_ENABLED_FLAG' THEN
636: l_stockable_value := l_attr_value;
637: ELSIF l_attr_name = 'MTL_SYSTEM_ITEMS.BUILD_IN_WIP_FLAG' THEN
638: l_wip_value := l_attr_value;
639: ELSIF l_attr_name = 'MTL_SYSTEM_ITEMS.CUSTOMER_ORDER_ENABLED_FLAG' THEN
640: l_cust_ord_value := l_attr_value;
641: ELSIF l_attr_name = 'MTL_SYSTEM_ITEMS.INTERNAL_ORDER_ENABLED_FLAG' THEN
642: l_int_ord_value := l_attr_value;
643: ELSIF l_attr_name = 'MTL_SYSTEM_ITEMS.INVOICE_ENABLED_FLAG' THEN

Line 641: ELSIF l_attr_name = 'MTL_SYSTEM_ITEMS.INTERNAL_ORDER_ENABLED_FLAG' THEN

637: ELSIF l_attr_name = 'MTL_SYSTEM_ITEMS.BUILD_IN_WIP_FLAG' THEN
638: l_wip_value := l_attr_value;
639: ELSIF l_attr_name = 'MTL_SYSTEM_ITEMS.CUSTOMER_ORDER_ENABLED_FLAG' THEN
640: l_cust_ord_value := l_attr_value;
641: ELSIF l_attr_name = 'MTL_SYSTEM_ITEMS.INTERNAL_ORDER_ENABLED_FLAG' THEN
642: l_int_ord_value := l_attr_value;
643: ELSIF l_attr_name = 'MTL_SYSTEM_ITEMS.INVOICE_ENABLED_FLAG' THEN
644: l_invoiceable_value := l_attr_value;
645: END IF;

Line 643: ELSIF l_attr_name = 'MTL_SYSTEM_ITEMS.INVOICE_ENABLED_FLAG' THEN

639: ELSIF l_attr_name = 'MTL_SYSTEM_ITEMS.CUSTOMER_ORDER_ENABLED_FLAG' THEN
640: l_cust_ord_value := l_attr_value;
641: ELSIF l_attr_name = 'MTL_SYSTEM_ITEMS.INTERNAL_ORDER_ENABLED_FLAG' THEN
642: l_int_ord_value := l_attr_value;
643: ELSIF l_attr_name = 'MTL_SYSTEM_ITEMS.INVOICE_ENABLED_FLAG' THEN
644: l_invoiceable_value := l_attr_value;
645: END IF;
646:
647: END LOOP;

Line 659: IF l_attr_name = 'MTL_SYSTEM_ITEMS.BOM_ENABLED_FLAG' THEN

655: LOOP
656: FETCH status_attr_values INTO l_attr_name, l_attr_value;
657: EXIT when status_attr_values%NOTFOUND;
658:
659: IF l_attr_name = 'MTL_SYSTEM_ITEMS.BOM_ENABLED_FLAG' THEN
660: l_bom_enabled_value := l_attr_value;
661: l_bom_enabled_status_ctrl := l_status_ctrl_lvl;
662: ELSIF l_attr_name = 'MTL_SYSTEM_ITEMS.PURCHASING_ENABLED_FLAG' THEN
663: l_purchasable_value := l_attr_value;

Line 662: ELSIF l_attr_name = 'MTL_SYSTEM_ITEMS.PURCHASING_ENABLED_FLAG' THEN

658:
659: IF l_attr_name = 'MTL_SYSTEM_ITEMS.BOM_ENABLED_FLAG' THEN
660: l_bom_enabled_value := l_attr_value;
661: l_bom_enabled_status_ctrl := l_status_ctrl_lvl;
662: ELSIF l_attr_name = 'MTL_SYSTEM_ITEMS.PURCHASING_ENABLED_FLAG' THEN
663: l_purchasable_value := l_attr_value;
664: l_purchasable_status_ctrl := l_status_ctrl_lvl;
665: ELSIF l_attr_name = 'MTL_SYSTEM_ITEMS.MTL_TRANSACTIONS_ENABLED_FLAG' THEN
666: l_transactable_value := l_attr_value;

Line 665: ELSIF l_attr_name = 'MTL_SYSTEM_ITEMS.MTL_TRANSACTIONS_ENABLED_FLAG' THEN

661: l_bom_enabled_status_ctrl := l_status_ctrl_lvl;
662: ELSIF l_attr_name = 'MTL_SYSTEM_ITEMS.PURCHASING_ENABLED_FLAG' THEN
663: l_purchasable_value := l_attr_value;
664: l_purchasable_status_ctrl := l_status_ctrl_lvl;
665: ELSIF l_attr_name = 'MTL_SYSTEM_ITEMS.MTL_TRANSACTIONS_ENABLED_FLAG' THEN
666: l_transactable_value := l_attr_value;
667: l_transactable_status_ctrl := l_status_ctrl_lvl;
668: ELSIF l_attr_name = 'MTL_SYSTEM_ITEMS.STOCK_ENABLED_FLAG' THEN
669: l_stockable_value := l_attr_value;

Line 668: ELSIF l_attr_name = 'MTL_SYSTEM_ITEMS.STOCK_ENABLED_FLAG' THEN

664: l_purchasable_status_ctrl := l_status_ctrl_lvl;
665: ELSIF l_attr_name = 'MTL_SYSTEM_ITEMS.MTL_TRANSACTIONS_ENABLED_FLAG' THEN
666: l_transactable_value := l_attr_value;
667: l_transactable_status_ctrl := l_status_ctrl_lvl;
668: ELSIF l_attr_name = 'MTL_SYSTEM_ITEMS.STOCK_ENABLED_FLAG' THEN
669: l_stockable_value := l_attr_value;
670: l_stockable_status_ctrl := l_status_ctrl_lvl;
671: ELSIF l_attr_name = 'MTL_SYSTEM_ITEMS.BUILD_IN_WIP_FLAG' THEN
672: l_wip_value := l_attr_value;

Line 671: ELSIF l_attr_name = 'MTL_SYSTEM_ITEMS.BUILD_IN_WIP_FLAG' THEN

667: l_transactable_status_ctrl := l_status_ctrl_lvl;
668: ELSIF l_attr_name = 'MTL_SYSTEM_ITEMS.STOCK_ENABLED_FLAG' THEN
669: l_stockable_value := l_attr_value;
670: l_stockable_status_ctrl := l_status_ctrl_lvl;
671: ELSIF l_attr_name = 'MTL_SYSTEM_ITEMS.BUILD_IN_WIP_FLAG' THEN
672: l_wip_value := l_attr_value;
673: l_wip_status_ctrl := l_status_ctrl_lvl;
674: ELSIF l_attr_name = 'MTL_SYSTEM_ITEMS.CUSTOMER_ORDER_ENABLED_FLAG' THEN
675: l_cust_ord_value := l_attr_value;

Line 674: ELSIF l_attr_name = 'MTL_SYSTEM_ITEMS.CUSTOMER_ORDER_ENABLED_FLAG' THEN

670: l_stockable_status_ctrl := l_status_ctrl_lvl;
671: ELSIF l_attr_name = 'MTL_SYSTEM_ITEMS.BUILD_IN_WIP_FLAG' THEN
672: l_wip_value := l_attr_value;
673: l_wip_status_ctrl := l_status_ctrl_lvl;
674: ELSIF l_attr_name = 'MTL_SYSTEM_ITEMS.CUSTOMER_ORDER_ENABLED_FLAG' THEN
675: l_cust_ord_value := l_attr_value;
676: l_cust_ord_status_ctrl := l_status_ctrl_lvl;
677: ELSIF l_attr_name = 'MTL_SYSTEM_ITEMS.INTERNAL_ORDER_ENABLED_FLAG' THEN
678: l_int_ord_value := l_attr_value;

Line 677: ELSIF l_attr_name = 'MTL_SYSTEM_ITEMS.INTERNAL_ORDER_ENABLED_FLAG' THEN

673: l_wip_status_ctrl := l_status_ctrl_lvl;
674: ELSIF l_attr_name = 'MTL_SYSTEM_ITEMS.CUSTOMER_ORDER_ENABLED_FLAG' THEN
675: l_cust_ord_value := l_attr_value;
676: l_cust_ord_status_ctrl := l_status_ctrl_lvl;
677: ELSIF l_attr_name = 'MTL_SYSTEM_ITEMS.INTERNAL_ORDER_ENABLED_FLAG' THEN
678: l_int_ord_value := l_attr_value;
679: l_int_ord_status_ctrl := l_status_ctrl_lvl;
680: ELSIF l_attr_name = 'MTL_SYSTEM_ITEMS.INVOICE_ENABLED_FLAG' THEN
681: l_invoiceable_value := l_attr_value;

Line 680: ELSIF l_attr_name = 'MTL_SYSTEM_ITEMS.INVOICE_ENABLED_FLAG' THEN

676: l_cust_ord_status_ctrl := l_status_ctrl_lvl;
677: ELSIF l_attr_name = 'MTL_SYSTEM_ITEMS.INTERNAL_ORDER_ENABLED_FLAG' THEN
678: l_int_ord_value := l_attr_value;
679: l_int_ord_status_ctrl := l_status_ctrl_lvl;
680: ELSIF l_attr_name = 'MTL_SYSTEM_ITEMS.INVOICE_ENABLED_FLAG' THEN
681: l_invoiceable_value := l_attr_value;
682: l_invoiceable_status_ctrl := l_status_ctrl_lvl;
683: END IF;
684:

Line 693: WHERE attribute_name = 'MTL_SYSTEM_ITEMS.INVENTORY_ITEM_STATUS_CODE';

689: -- bug 9944329, get status code attribute control level
690: SELECT control_level
691: INTO l_status_code_control_level
692: FROM mtl_item_attributes
693: WHERE attribute_name = 'MTL_SYSTEM_ITEMS.INVENTORY_ITEM_STATUS_CODE';
694: --------------------------------
695: LOOP -- loop through org items
696:
697: FETCH INV_ITEM_API.Item_csr INTO l_Item_rec;

Line 710: FROM mtl_system_items_tl

706: l_update_child_rec := FALSE; --Bug: 5220205
707: -- Bug 4388141. Populate long description in l_item_rec.long_description
708: SELECT description , long_description
709: INTO l_item_rec.description , l_item_rec.long_description
710: FROM mtl_system_items_tl
711: WHERE inventory_item_id = l_item_rec.inventory_item_id
712: AND organization_id = l_item_rec.organization_id
713: AND language = userenv('LANG');
714: --bug 9944329, check if status has been changed in master org

Line 2447: if l_org_status_attribute_name = 'MTL_SYSTEM_ITEMS.RECIPE_ENABLED_FLAG' and l_org_status_attribute_control <> 3 then

2443: LOOP
2444: FETCH org_status_attr_values_csr INTO l_org_status_attribute_name, l_org_status_attribute_value, l_org_status_attribute_control;
2445: EXIT when org_status_attr_values_csr%NOTFOUND;
2446:
2447: if l_org_status_attribute_name = 'MTL_SYSTEM_ITEMS.RECIPE_ENABLED_FLAG' and l_org_status_attribute_control <> 3 then
2448: l_Item_rec.RECIPE_ENABLED_FLAG := l_org_status_attribute_value;
2449: end if;
2450: if l_org_status_attribute_name = 'MTL_SYSTEM_ITEMS.PROCESS_EXECUTION_ENABLED_FLAG' and l_org_status_attribute_control <> 3 then
2451: if l_Item_rec.inventory_item_flag = 'N' or l_Item_rec.RECIPE_ENABLED_FLAG = 'N' then

Line 2450: if l_org_status_attribute_name = 'MTL_SYSTEM_ITEMS.PROCESS_EXECUTION_ENABLED_FLAG' and l_org_status_attribute_control <> 3 then

2446:
2447: if l_org_status_attribute_name = 'MTL_SYSTEM_ITEMS.RECIPE_ENABLED_FLAG' and l_org_status_attribute_control <> 3 then
2448: l_Item_rec.RECIPE_ENABLED_FLAG := l_org_status_attribute_value;
2449: end if;
2450: if l_org_status_attribute_name = 'MTL_SYSTEM_ITEMS.PROCESS_EXECUTION_ENABLED_FLAG' and l_org_status_attribute_control <> 3 then
2451: if l_Item_rec.inventory_item_flag = 'N' or l_Item_rec.RECIPE_ENABLED_FLAG = 'N' then
2452: l_Item_rec.PROCESS_EXECUTION_ENABLED_FLAG := 'N';
2453: ELSE
2454: l_Item_rec.PROCESS_EXECUTION_ENABLED_FLAG := l_org_status_attribute_value;

Line 3350: ,P_Item_Id IN OUT NOCOPY MTL_SYSTEM_ITEMS.INVENTORY_ITEM_ID%TYPE

3346:
3347:
3348: PROCEDURE Check_Item_Number (
3349: P_Segment_Rec IN INV_ITEM_API.Item_rec_type
3350: ,P_Item_Id IN OUT NOCOPY MTL_SYSTEM_ITEMS.INVENTORY_ITEM_ID%TYPE
3351: ,P_Description IN OUT NOCOPY MTL_SYSTEM_ITEMS.DESCRIPTION%TYPE
3352: ,P_unit_of_measure IN OUT NOCOPY MTL_SYSTEM_ITEMS.PRIMARY_UNIT_OF_MEASURE%TYPE
3353: ,P_Item_Catalog_Group_Id IN OUT NOCOPY MTL_SYSTEM_ITEMS.ITEM_CATALOG_GROUP_ID%TYPE)
3354: IS

Line 3351: ,P_Description IN OUT NOCOPY MTL_SYSTEM_ITEMS.DESCRIPTION%TYPE

3347:
3348: PROCEDURE Check_Item_Number (
3349: P_Segment_Rec IN INV_ITEM_API.Item_rec_type
3350: ,P_Item_Id IN OUT NOCOPY MTL_SYSTEM_ITEMS.INVENTORY_ITEM_ID%TYPE
3351: ,P_Description IN OUT NOCOPY MTL_SYSTEM_ITEMS.DESCRIPTION%TYPE
3352: ,P_unit_of_measure IN OUT NOCOPY MTL_SYSTEM_ITEMS.PRIMARY_UNIT_OF_MEASURE%TYPE
3353: ,P_Item_Catalog_Group_Id IN OUT NOCOPY MTL_SYSTEM_ITEMS.ITEM_CATALOG_GROUP_ID%TYPE)
3354: IS
3355:

Line 3352: ,P_unit_of_measure IN OUT NOCOPY MTL_SYSTEM_ITEMS.PRIMARY_UNIT_OF_MEASURE%TYPE

3348: PROCEDURE Check_Item_Number (
3349: P_Segment_Rec IN INV_ITEM_API.Item_rec_type
3350: ,P_Item_Id IN OUT NOCOPY MTL_SYSTEM_ITEMS.INVENTORY_ITEM_ID%TYPE
3351: ,P_Description IN OUT NOCOPY MTL_SYSTEM_ITEMS.DESCRIPTION%TYPE
3352: ,P_unit_of_measure IN OUT NOCOPY MTL_SYSTEM_ITEMS.PRIMARY_UNIT_OF_MEASURE%TYPE
3353: ,P_Item_Catalog_Group_Id IN OUT NOCOPY MTL_SYSTEM_ITEMS.ITEM_CATALOG_GROUP_ID%TYPE)
3354: IS
3355:
3356: l_sql_stmt VARCHAR2(3200);

Line 3353: ,P_Item_Catalog_Group_Id IN OUT NOCOPY MTL_SYSTEM_ITEMS.ITEM_CATALOG_GROUP_ID%TYPE)

3349: P_Segment_Rec IN INV_ITEM_API.Item_rec_type
3350: ,P_Item_Id IN OUT NOCOPY MTL_SYSTEM_ITEMS.INVENTORY_ITEM_ID%TYPE
3351: ,P_Description IN OUT NOCOPY MTL_SYSTEM_ITEMS.DESCRIPTION%TYPE
3352: ,P_unit_of_measure IN OUT NOCOPY MTL_SYSTEM_ITEMS.PRIMARY_UNIT_OF_MEASURE%TYPE
3353: ,P_Item_Catalog_Group_Id IN OUT NOCOPY MTL_SYSTEM_ITEMS.ITEM_CATALOG_GROUP_ID%TYPE)
3354: IS
3355:
3356: l_sql_stmt VARCHAR2(3200);
3357: l_segments_string VARCHAR2(1000);

Line 3367: FROM MTL_SYSTEM_ITEMS_B_KFV MSI,

3363: l_sql_stmt := 'SELECT INVENTORY_ITEM_ID,
3364: ITEM_CATALOG_GROUP_ID,
3365: PRIMARY_UNIT_OF_MEASURE,
3366: DESCRIPTION
3367: FROM MTL_SYSTEM_ITEMS_B_KFV MSI,
3368: MTL_PARAMETERS P
3369: WHERE MSI.ORGANIZATION_ID = P.ORGANIZATION_ID ';
3370:
3371: get_segments_string(P_Segment_Rec => P_Segment_Rec

Line 3438: l_mast_organization_id MTL_SYSTEM_ITEMS.ORGANIZATION_ID%TYPE;

3434: l_party_id FND_USER.CUSTOMER_ID%TYPE;
3435: l_grant_guid fnd_grants.grant_guid%TYPE;
3436: l_ego_exists VARCHAR2(1) := 'N';
3437: l_master_org VARCHAR2(1); --R12: Business Events
3438: l_mast_organization_id MTL_SYSTEM_ITEMS.ORGANIZATION_ID%TYPE;
3439:
3440: BEGIN
3441: -- Primary_Unit_of_Measure lookup
3442:

Line 3470: INSERT INTO MTL_SYSTEM_ITEMS_B(

3466: l_VENDOR_WARRANTY_FLAG := 'N';
3467: l_USAGE_ITEM_FLAG := NULL;
3468: END IF;
3469:
3470: INSERT INTO MTL_SYSTEM_ITEMS_B(
3471: DESCRIPTION,
3472: INVENTORY_ITEM_ID,
3473: ORGANIZATION_ID,
3474: SUMMARY_FLAG,

Line 4249: INSERT INTO MTL_SYSTEM_ITEMS_TL(

4245: IF (P_Item_Rec.organization_id = Get_Master_Org_ID (P_Item_Rec.organization_id) ) THEN
4246: -- If the Org is master, insert the source language translated columns
4247: -- for child organizations.
4248:
4249: INSERT INTO MTL_SYSTEM_ITEMS_TL(
4250: INVENTORY_ITEM_ID,
4251: ORGANIZATION_ID,
4252: LANGUAGE,
4253: SOURCE_LANG,

Line 4277: FROM MTL_SYSTEM_ITEMS_TL T

4273: FROM FND_LANGUAGES L
4274: WHERE L.INSTALLED_FLAG in ('I', 'B')
4275: AND NOT EXISTS
4276: ( SELECT NULL
4277: FROM MTL_SYSTEM_ITEMS_TL T
4278: WHERE T.INVENTORY_ITEM_ID = P_Item_Rec.INVENTORY_ITEM_ID
4279: AND T.ORGANIZATION_ID = P_Item_Rec.ORGANIZATION_ID
4280: AND T.LANGUAGE = L.LANGUAGE_CODE);
4281: ELSE

Line 4284: INSERT INTO MTL_SYSTEM_ITEMS_TL (

4280: AND T.LANGUAGE = L.LANGUAGE_CODE);
4281: ELSE
4282: -- If the Org is not master, then while creating new child items,
4283: -- copy translated columns from the master item record.
4284: INSERT INTO MTL_SYSTEM_ITEMS_TL (
4285: INVENTORY_ITEM_ID,
4286: ORGANIZATION_ID,
4287: LANGUAGE,
4288: SOURCE_LANG,

Line 4309: MTL_SYSTEM_ITEMS_TL MSI,

4305: P_Item_Rec.CREATION_DATE,
4306: P_Item_Rec.CREATED_BY,
4307: P_Item_Rec.LAST_UPDATE_LOGIN
4308: FROM
4309: MTL_SYSTEM_ITEMS_TL MSI,
4310: MTL_PARAMETERS MP
4311: WHERE
4312: MSI.INVENTORY_ITEM_ID = P_Item_Rec.INVENTORY_ITEM_ID
4313: AND MSI.ORGANIZATION_ID = MP.MASTER_ORGANIZATION_ID

Line 4467: Cursor c_check_sec_uom_class(Vinventory_item_id mtl_system_items_b.inventory_item_id%TYPE) IS

4463: PROCEDURE check_mismatch_of_secuom_class(
4464: p_inventory_item_id IN NUMBER
4465: ,p_secondary_uom_class IN MTL_UNITS_OF_MEASURE.UOM_CLASS%TYPE)
4466: IS
4467: Cursor c_check_sec_uom_class(Vinventory_item_id mtl_system_items_b.inventory_item_id%TYPE) IS
4468: SELECT muomv.UOM_CLASS
4469: FROM MTL_UNITS_OF_MEASURE_VL muomv, mtl_system_items_b msib
4470: WHERE muomv.uom_code = msib.secondary_uom_code
4471: AND msib.inventory_item_id = Vinventory_item_id

Line 4469: FROM MTL_UNITS_OF_MEASURE_VL muomv, mtl_system_items_b msib

4465: ,p_secondary_uom_class IN MTL_UNITS_OF_MEASURE.UOM_CLASS%TYPE)
4466: IS
4467: Cursor c_check_sec_uom_class(Vinventory_item_id mtl_system_items_b.inventory_item_id%TYPE) IS
4468: SELECT muomv.UOM_CLASS
4469: FROM MTL_UNITS_OF_MEASURE_VL muomv, mtl_system_items_b msib
4470: WHERE muomv.uom_code = msib.secondary_uom_code
4471: AND msib.inventory_item_id = Vinventory_item_id
4472: AND msib.secondary_uom_code IS NOT NULL
4473: AND ROWNUM = 1;

Line 4496: ,P_Master_Org_Id IN MTL_SYSTEM_ITEMS.ORGANIZATION_ID%TYPE

4492: PROCEDURE Create_Item(
4493: P_Item_Rec IN INV_ITEM_API.Item_rec_type
4494: ,P_Item_Category_Struct_Id IN NUMBER
4495: ,P_Inv_Install IN NUMBER
4496: ,P_Master_Org_Id IN MTL_SYSTEM_ITEMS.ORGANIZATION_ID%TYPE
4497: ,P_Category_Set_Id IN NUMBER
4498: ,P_Item_Category_Id IN NUMBER
4499: ,P_Event IN VARCHAR2 DEFAULT 'INSERT'
4500: ,x_row_Id OUT NOCOPY ROWID

Line 4513: Cursor c_get_item_count(cp_Org_Id MTL_SYSTEM_ITEMS.ORGANIZATION_ID%TYPE

4509: FROM MTL_UNITS_OF_MEASURE_VL
4510: WHERE UNIT_OF_MEASURE = cp_uom
4511: OR uom_code = cp_uom_code;
4512:
4513: Cursor c_get_item_count(cp_Org_Id MTL_SYSTEM_ITEMS.ORGANIZATION_ID%TYPE
4514: ,cp_Item_Id MTL_SYSTEM_ITEMS.INVENTORY_ITEM_ID%TYPE)
4515: IS
4516: SELECT COUNT(1)
4517: FROM MTL_SYSTEM_ITEMS

Line 4514: ,cp_Item_Id MTL_SYSTEM_ITEMS.INVENTORY_ITEM_ID%TYPE)

4510: WHERE UNIT_OF_MEASURE = cp_uom
4511: OR uom_code = cp_uom_code;
4512:
4513: Cursor c_get_item_count(cp_Org_Id MTL_SYSTEM_ITEMS.ORGANIZATION_ID%TYPE
4514: ,cp_Item_Id MTL_SYSTEM_ITEMS.INVENTORY_ITEM_ID%TYPE)
4515: IS
4516: SELECT COUNT(1)
4517: FROM MTL_SYSTEM_ITEMS
4518: WHERE INVENTORY_ITEM_ID = cp_Item_Id

Line 4517: FROM MTL_SYSTEM_ITEMS

4513: Cursor c_get_item_count(cp_Org_Id MTL_SYSTEM_ITEMS.ORGANIZATION_ID%TYPE
4514: ,cp_Item_Id MTL_SYSTEM_ITEMS.INVENTORY_ITEM_ID%TYPE)
4515: IS
4516: SELECT COUNT(1)
4517: FROM MTL_SYSTEM_ITEMS
4518: WHERE INVENTORY_ITEM_ID = cp_Item_Id
4519: AND ORGANIZATION_ID = cp_org_id;
4520:
4521: l_item_count NUMBER :=0;

Line 4522: l_primary_uom MTL_SYSTEM_ITEMS.PRIMARY_UNIT_OF_MEASURE%TYPE;

4518: WHERE INVENTORY_ITEM_ID = cp_Item_Id
4519: AND ORGANIZATION_ID = cp_org_id;
4520:
4521: l_item_count NUMBER :=0;
4522: l_primary_uom MTL_SYSTEM_ITEMS.PRIMARY_UNIT_OF_MEASURE%TYPE;
4523: l_primary_uom_code MTL_UNITS_OF_MEASURE_VL.UOM_CODE%TYPE;
4524: l_new_item_id MTL_SYSTEM_ITEMS.INVENTORY_ITEM_ID%TYPE;
4525: l_unit_of_measure MTL_SYSTEM_ITEMS.PRIMARY_UNIT_OF_MEASURE%TYPE;
4526: l_uom_class MTL_UNITS_OF_MEASURE.UOM_CLASS%TYPE := NULL;

Line 4524: l_new_item_id MTL_SYSTEM_ITEMS.INVENTORY_ITEM_ID%TYPE;

4520:
4521: l_item_count NUMBER :=0;
4522: l_primary_uom MTL_SYSTEM_ITEMS.PRIMARY_UNIT_OF_MEASURE%TYPE;
4523: l_primary_uom_code MTL_UNITS_OF_MEASURE_VL.UOM_CODE%TYPE;
4524: l_new_item_id MTL_SYSTEM_ITEMS.INVENTORY_ITEM_ID%TYPE;
4525: l_unit_of_measure MTL_SYSTEM_ITEMS.PRIMARY_UNIT_OF_MEASURE%TYPE;
4526: l_uom_class MTL_UNITS_OF_MEASURE.UOM_CLASS%TYPE := NULL;
4527: l_rec_uom_class MTL_UNITS_OF_MEASURE.UOM_CLASS%TYPE;
4528: l_description MTL_SYSTEM_ITEMS.DESCRIPTION%TYPE;

Line 4525: l_unit_of_measure MTL_SYSTEM_ITEMS.PRIMARY_UNIT_OF_MEASURE%TYPE;

4521: l_item_count NUMBER :=0;
4522: l_primary_uom MTL_SYSTEM_ITEMS.PRIMARY_UNIT_OF_MEASURE%TYPE;
4523: l_primary_uom_code MTL_UNITS_OF_MEASURE_VL.UOM_CODE%TYPE;
4524: l_new_item_id MTL_SYSTEM_ITEMS.INVENTORY_ITEM_ID%TYPE;
4525: l_unit_of_measure MTL_SYSTEM_ITEMS.PRIMARY_UNIT_OF_MEASURE%TYPE;
4526: l_uom_class MTL_UNITS_OF_MEASURE.UOM_CLASS%TYPE := NULL;
4527: l_rec_uom_class MTL_UNITS_OF_MEASURE.UOM_CLASS%TYPE;
4528: l_description MTL_SYSTEM_ITEMS.DESCRIPTION%TYPE;
4529: l_catalog_grp_id NUMBER;

Line 4528: l_description MTL_SYSTEM_ITEMS.DESCRIPTION%TYPE;

4524: l_new_item_id MTL_SYSTEM_ITEMS.INVENTORY_ITEM_ID%TYPE;
4525: l_unit_of_measure MTL_SYSTEM_ITEMS.PRIMARY_UNIT_OF_MEASURE%TYPE;
4526: l_uom_class MTL_UNITS_OF_MEASURE.UOM_CLASS%TYPE := NULL;
4527: l_rec_uom_class MTL_UNITS_OF_MEASURE.UOM_CLASS%TYPE;
4528: l_description MTL_SYSTEM_ITEMS.DESCRIPTION%TYPE;
4529: l_catalog_grp_id NUMBER;
4530: l_folder_item_cat_id NUMBER := NULL;
4531: /* Bug 3713912 */
4532: l_rec_sec_uom_class MTL_UNITS_OF_MEASURE.UOM_CLASS%TYPE;

Line 4699: P_Item_Id IN MTL_SYSTEM_ITEMS_B.INVENTORY_ITEM_ID%TYPE

4695: END Create_Item;
4696:
4697:
4698: PROCEDURE Delete_Cost_Details(
4699: P_Item_Id IN MTL_SYSTEM_ITEMS_B.INVENTORY_ITEM_ID%TYPE
4700: ,P_Org_Id IN MTL_SYSTEM_ITEMS_B.ORGANIZATION_ID%TYPE
4701: ,P_Asset_Flag IN MTL_SYSTEM_ITEMS_B.INVENTORY_ASSET_FLAG%TYPE
4702: ,P_Cost_Txn IN NUMBER
4703: ,P_Last_Updated_By IN MTL_SYSTEM_ITEMS_B.LAST_UPDATED_BY%TYPE

Line 4700: ,P_Org_Id IN MTL_SYSTEM_ITEMS_B.ORGANIZATION_ID%TYPE

4696:
4697:
4698: PROCEDURE Delete_Cost_Details(
4699: P_Item_Id IN MTL_SYSTEM_ITEMS_B.INVENTORY_ITEM_ID%TYPE
4700: ,P_Org_Id IN MTL_SYSTEM_ITEMS_B.ORGANIZATION_ID%TYPE
4701: ,P_Asset_Flag IN MTL_SYSTEM_ITEMS_B.INVENTORY_ASSET_FLAG%TYPE
4702: ,P_Cost_Txn IN NUMBER
4703: ,P_Last_Updated_By IN MTL_SYSTEM_ITEMS_B.LAST_UPDATED_BY%TYPE
4704: ,P_Last_Updated_Login IN MTL_SYSTEM_ITEMS_B.LAST_UPDATE_LOGIN%TYPE)

Line 4701: ,P_Asset_Flag IN MTL_SYSTEM_ITEMS_B.INVENTORY_ASSET_FLAG%TYPE

4697:
4698: PROCEDURE Delete_Cost_Details(
4699: P_Item_Id IN MTL_SYSTEM_ITEMS_B.INVENTORY_ITEM_ID%TYPE
4700: ,P_Org_Id IN MTL_SYSTEM_ITEMS_B.ORGANIZATION_ID%TYPE
4701: ,P_Asset_Flag IN MTL_SYSTEM_ITEMS_B.INVENTORY_ASSET_FLAG%TYPE
4702: ,P_Cost_Txn IN NUMBER
4703: ,P_Last_Updated_By IN MTL_SYSTEM_ITEMS_B.LAST_UPDATED_BY%TYPE
4704: ,P_Last_Updated_Login IN MTL_SYSTEM_ITEMS_B.LAST_UPDATE_LOGIN%TYPE)
4705: IS

Line 4703: ,P_Last_Updated_By IN MTL_SYSTEM_ITEMS_B.LAST_UPDATED_BY%TYPE

4699: P_Item_Id IN MTL_SYSTEM_ITEMS_B.INVENTORY_ITEM_ID%TYPE
4700: ,P_Org_Id IN MTL_SYSTEM_ITEMS_B.ORGANIZATION_ID%TYPE
4701: ,P_Asset_Flag IN MTL_SYSTEM_ITEMS_B.INVENTORY_ASSET_FLAG%TYPE
4702: ,P_Cost_Txn IN NUMBER
4703: ,P_Last_Updated_By IN MTL_SYSTEM_ITEMS_B.LAST_UPDATED_BY%TYPE
4704: ,P_Last_Updated_Login IN MTL_SYSTEM_ITEMS_B.LAST_UPDATE_LOGIN%TYPE)
4705: IS
4706:
4707: l_prim_cost_method MTL_PARAMETERS.PRIMARY_COST_METHOD%TYPE;

Line 4704: ,P_Last_Updated_Login IN MTL_SYSTEM_ITEMS_B.LAST_UPDATE_LOGIN%TYPE)

4700: ,P_Org_Id IN MTL_SYSTEM_ITEMS_B.ORGANIZATION_ID%TYPE
4701: ,P_Asset_Flag IN MTL_SYSTEM_ITEMS_B.INVENTORY_ASSET_FLAG%TYPE
4702: ,P_Cost_Txn IN NUMBER
4703: ,P_Last_Updated_By IN MTL_SYSTEM_ITEMS_B.LAST_UPDATED_BY%TYPE
4704: ,P_Last_Updated_Login IN MTL_SYSTEM_ITEMS_B.LAST_UPDATE_LOGIN%TYPE)
4705: IS
4706:
4707: l_prim_cost_method MTL_PARAMETERS.PRIMARY_COST_METHOD%TYPE;
4708: /* l_profile_exists BOOLEAN;

Line 4813: ,P_Master_Org_Id IN MTL_SYSTEM_ITEMS.ORGANIZATION_ID%TYPE

4809: PROCEDURE Update_Item(
4810: P_Item_Rec IN INV_ITEM_API.Item_rec_type
4811: ,P_Item_Category_Struct_Id IN NUMBER
4812: ,P_Inv_Install IN NUMBER
4813: ,P_Master_Org_Id IN MTL_SYSTEM_ITEMS.ORGANIZATION_ID%TYPE
4814: ,P_Category_Set_Id IN NUMBER
4815: ,P_Item_Category_Id IN NUMBER
4816: ,P_Mode IN VARCHAR2
4817: ,P_Updateble_Item IN VARCHAR2

Line 4820: ,P_Inv_Item_status_old IN MTL_SYSTEM_ITEMS_FVL.INVENTORY_ITEM_STATUS_CODE%TYPE

4816: ,P_Mode IN VARCHAR2
4817: ,P_Updateble_Item IN VARCHAR2
4818: ,P_Cost_Txn IN VARCHAR2
4819: ,P_Item_Cost_Details IN VARCHAR2
4820: ,P_Inv_Item_status_old IN MTL_SYSTEM_ITEMS_FVL.INVENTORY_ITEM_STATUS_CODE%TYPE
4821: ,P_Default_Move_Order_Sub_Inv IN VARCHAR2 -- Item Transaction Defaults for 11.5.9
4822: ,P_Default_Receiving_Sub_Inv IN VARCHAR2
4823: ,P_Default_Shipping_Sub_Inv IN VARCHAR2
4824: ) IS

Line 4833: l_cst_item_type MTL_SYSTEM_ITEMS_FVL.PLANNING_MAKE_BUY_CODE%TYPE;

4829: WHERE UNIT_OF_MEASURE = cp_uom;
4830:
4831: l_rec_uom_class MTL_UNITS_OF_MEASURE.UOM_CLASS%TYPE;
4832: l_folder_item_cat_id NUMBER := NULL;
4833: l_cst_item_type MTL_SYSTEM_ITEMS_FVL.PLANNING_MAKE_BUY_CODE%TYPE;
4834: l_Inventory_Item_status MTL_SYSTEM_ITEMS_FVL.INVENTORY_ITEM_STATUS_CODE%TYPE;
4835: l_event VARCHAR2(10);
4836: l_return_status VARCHAR2(1);
4837: l_msg_count NUMBER;

Line 4834: l_Inventory_Item_status MTL_SYSTEM_ITEMS_FVL.INVENTORY_ITEM_STATUS_CODE%TYPE;

4830:
4831: l_rec_uom_class MTL_UNITS_OF_MEASURE.UOM_CLASS%TYPE;
4832: l_folder_item_cat_id NUMBER := NULL;
4833: l_cst_item_type MTL_SYSTEM_ITEMS_FVL.PLANNING_MAKE_BUY_CODE%TYPE;
4834: l_Inventory_Item_status MTL_SYSTEM_ITEMS_FVL.INVENTORY_ITEM_STATUS_CODE%TYPE;
4835: l_event VARCHAR2(10);
4836: l_return_status VARCHAR2(1);
4837: l_msg_count NUMBER;
4838: l_msg_data VARCHAR2(2000);

Line 4860: where attribute_name= 'MTL_SYSTEM_ITEMS.INVENTORY_ASSET_FLAG')

4856: (SELECT ORGANIZATION_ID FROM MTL_PARAMETERS
4857: WHERE MASTER_ORGANIZATION_ID = org_id
4858: AND PRIMARY_COST_METHOD in (2,5,6)
4859: AND (1=(select control_level from mtl_item_attributes
4860: where attribute_name= 'MTL_SYSTEM_ITEMS.INVENTORY_ASSET_FLAG')
4861: )
4862: );
4863: -- Bug 8512945 with base bug 8417326 : End
4864:

Line 4870: where attribute_name= 'MTL_SYSTEM_ITEMS.PLANNING_MAKE_BUY_CODE';

4866:
4867: -- Bug 8512945 with base bug 8417326 : Start
4868: select control_level INTO l_control_level
4869: from mtl_item_attributes
4870: where attribute_name= 'MTL_SYSTEM_ITEMS.PLANNING_MAKE_BUY_CODE';
4871:
4872: -- Loop through the child orgs if the inv asset flag are controlled at master level
4873: OPEN c_get_child_costing_orgs(org_id => P_Item_rec.organization_id);
4874: LOOP

Line 4901: FROM mtl_system_items_b

4897:
4898: /* Bug 8512945 with base bug 8417326 : Below BEGIN Block is added */
4899: BEGIN
4900: SELECT 'Y' INTO l_exists
4901: FROM mtl_system_items_b
4902: WHERE inventory_item_id = P_Item_Rec.inventory_item_id
4903: AND organization_id = l_org_id;
4904:
4905: IF (P_Item_rec.organization_id = l_org_id) THEN

Line 4920: FROM mtl_system_items_b

4916: l_cst_item_type := 2;
4917: END IF;
4918: ELSE
4919: SELECT planning_make_buy_code INTO l_cst_item_type
4920: FROM mtl_system_items_b
4921: WHERE inventory_item_id = P_Item_Rec.inventory_item_id
4922: AND organization_id = l_org_id;
4923: END IF;
4924: END IF;

Line 4961: mtl_system_items_b WHERE inventory_item_id=P_Item_rec.inventory_item_id

4957:
4958: SELECT last_updated_by,last_update_date,LAST_UPDATE_LOGIN
4959: INTO l_last_updated_by ,l_last_update_date,l_last_update_login
4960: FROM
4961: mtl_system_items_b WHERE inventory_item_id=P_Item_rec.inventory_item_id
4962: AND organization_id= P_Master_Org_Id;
4963: */
4964:
4965:

Line 4968: UPDATE mtl_system_items_b

4964:
4965:
4966: IF P_mode = 'DEFINE' THEN
4967: IF P_Updateble_Item = 'ALL' THEN
4968: UPDATE mtl_system_items_b
4969: SET segment1 = P_Item_rec.segment1
4970: ,segment2 = P_Item_rec.segment2
4971: ,segment3 = P_Item_rec.segment3
4972: ,segment4 = P_Item_rec.segment4

Line 5502: from MTL_SYSTEM_ITEMS_B

5498: -- Fix for Bug#6644711
5499: , DEFAULT_MATERIAL_STATUS_ID
5500: -- Serial_Tagging Enh -- bug 9913552
5501: , SERIAL_TAGGING_FLAG
5502: from MTL_SYSTEM_ITEMS_B
5503: where INVENTORY_ITEM_ID = P_Item_Rec.inventory_item_id
5504: and ORGANIZATION_ID = P_Item_rec.organization_id
5505: for update of INVENTORY_ITEM_ID nowait;
5506:

Line 5512: FROM MTL_SYSTEM_ITEMS_TL

5508: SELECT
5509: DESCRIPTION,
5510: LONG_DESCRIPTION,
5511: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
5512: FROM MTL_SYSTEM_ITEMS_TL
5513: WHERE INVENTORY_ITEM_ID = P_Item_Rec.inventory_item_id
5514: AND ORGANIZATION_ID = P_Item_rec.organization_id
5515: for update of INVENTORY_ITEM_ID nowait;
5516:

Line 6243: RAISE_APPLICATION_ERROR (-20000, 'Cannot delete Item using MTL_SYSTEM_ITEMS_PKG.DELETE_ROW');

6239:
6240: PROCEDURE DELETE_ROW IS
6241: BEGIN
6242: -- DELETE_ROW cannot be used to delete Item records.
6243: RAISE_APPLICATION_ERROR (-20000, 'Cannot delete Item using MTL_SYSTEM_ITEMS_PKG.DELETE_ROW');
6244: END DELETE_ROW;
6245:
6246: -- ------------------- ADD_LANGUAGE --------------------
6247:

Line 6256: /* DELETE FROM MTL_SYSTEM_ITEMS_TL T

6252: l_installed BOOLEAN;
6253: l_index_name VARCHAR2(30);
6254: BEGIN
6255:
6256: /* DELETE FROM MTL_SYSTEM_ITEMS_TL T
6257: WHERE NOT EXISTS ( SELECT NULL
6258: FROM MTL_SYSTEM_ITEMS_B B
6259: WHERE B.INVENTORY_ITEM_ID = T.INVENTORY_ITEM_ID
6260: AND B.ORGANIZATION_ID = T.ORGANIZATION_ID);

Line 6258: FROM MTL_SYSTEM_ITEMS_B B

6254: BEGIN
6255:
6256: /* DELETE FROM MTL_SYSTEM_ITEMS_TL T
6257: WHERE NOT EXISTS ( SELECT NULL
6258: FROM MTL_SYSTEM_ITEMS_B B
6259: WHERE B.INVENTORY_ITEM_ID = T.INVENTORY_ITEM_ID
6260: AND B.ORGANIZATION_ID = T.ORGANIZATION_ID);
6261:
6262: UPDATE MTL_SYSTEM_ITEMS_TL T

Line 6262: UPDATE MTL_SYSTEM_ITEMS_TL T

6258: FROM MTL_SYSTEM_ITEMS_B B
6259: WHERE B.INVENTORY_ITEM_ID = T.INVENTORY_ITEM_ID
6260: AND B.ORGANIZATION_ID = T.ORGANIZATION_ID);
6261:
6262: UPDATE MTL_SYSTEM_ITEMS_TL T
6263: SET( DESCRIPTION
6264: , LONG_DESCRIPTION) = (SELECT ltrim(rtrim(B.DESCRIPTION))
6265: , ltrim(rtrim(B.LONG_DESCRIPTION))
6266: FROM MTL_SYSTEM_ITEMS_TL B

Line 6266: FROM MTL_SYSTEM_ITEMS_TL B

6262: UPDATE MTL_SYSTEM_ITEMS_TL T
6263: SET( DESCRIPTION
6264: , LONG_DESCRIPTION) = (SELECT ltrim(rtrim(B.DESCRIPTION))
6265: , ltrim(rtrim(B.LONG_DESCRIPTION))
6266: FROM MTL_SYSTEM_ITEMS_TL B
6267: WHERE B.INVENTORY_ITEM_ID = T.INVENTORY_ITEM_ID
6268: AND B.ORGANIZATION_ID = T.ORGANIZATION_ID
6269: AND B.LANGUAGE = T.SOURCE_LANG)
6270: WHERE(T.INVENTORY_ITEM_ID

Line 6275: FROM MTL_SYSTEM_ITEMS_TL SUBB,

6271: , T.ORGANIZATION_ID
6272: , T.LANGUAGE) IN (SELECT SUBT.INVENTORY_ITEM_ID,
6273: SUBT.ORGANIZATION_ID,
6274: SUBT.LANGUAGE
6275: FROM MTL_SYSTEM_ITEMS_TL SUBB,
6276: MTL_SYSTEM_ITEMS_TL SUBT
6277: WHERE SUBB.INVENTORY_ITEM_ID = SUBT.INVENTORY_ITEM_ID
6278: AND SUBB.ORGANIZATION_ID = SUBT.ORGANIZATION_ID
6279: AND SUBB.LANGUAGE = SUBT.SOURCE_LANG

Line 6276: MTL_SYSTEM_ITEMS_TL SUBT

6272: , T.LANGUAGE) IN (SELECT SUBT.INVENTORY_ITEM_ID,
6273: SUBT.ORGANIZATION_ID,
6274: SUBT.LANGUAGE
6275: FROM MTL_SYSTEM_ITEMS_TL SUBB,
6276: MTL_SYSTEM_ITEMS_TL SUBT
6277: WHERE SUBB.INVENTORY_ITEM_ID = SUBT.INVENTORY_ITEM_ID
6278: AND SUBB.ORGANIZATION_ID = SUBT.ORGANIZATION_ID
6279: AND SUBB.LANGUAGE = SUBT.SOURCE_LANG
6280: AND (( SUBB.DESCRIPTION <> SUBT.DESCRIPTION

Line 6290: MTL_SYSTEM_ITEMS_TL has a row level trigger: EGO_MTL_SYSTEM_ITEMS_TL_TR1

6286:
6287: */
6288:
6289: /* Fix for bug 12922572 : FP of Bug 5701472-
6290: MTL_SYSTEM_ITEMS_TL has a row level trigger: EGO_MTL_SYSTEM_ITEMS_TL_TR1
6291: This Trigger causes a insert into EGO_ITEM_TEXT_TL for each row inserted into
6292: MTL_SYSTEM_ITEMS_TL, which causes performance issues. As part of bug 5701472,
6293: we will drop the intermedia index, disable trigger EGO_MTL_SYSTEM_ITEMS_TL_TR1
6294: batch insert into MTL_SYSTEM_ITEMS_TL and EGO_ITEM_TEXT_TL, enable the trigger

Line 6292: MTL_SYSTEM_ITEMS_TL, which causes performance issues. As part of bug 5701472,

6288:
6289: /* Fix for bug 12922572 : FP of Bug 5701472-
6290: MTL_SYSTEM_ITEMS_TL has a row level trigger: EGO_MTL_SYSTEM_ITEMS_TL_TR1
6291: This Trigger causes a insert into EGO_ITEM_TEXT_TL for each row inserted into
6292: MTL_SYSTEM_ITEMS_TL, which causes performance issues. As part of bug 5701472,
6293: we will drop the intermedia index, disable trigger EGO_MTL_SYSTEM_ITEMS_TL_TR1
6294: batch insert into MTL_SYSTEM_ITEMS_TL and EGO_ITEM_TEXT_TL, enable the trigger
6295: and ask customer to launch the concurrent request to build the intermedia index
6296: (Item Catalog Text Index Build with CREATE option).*/

Line 6293: we will drop the intermedia index, disable trigger EGO_MTL_SYSTEM_ITEMS_TL_TR1

6289: /* Fix for bug 12922572 : FP of Bug 5701472-
6290: MTL_SYSTEM_ITEMS_TL has a row level trigger: EGO_MTL_SYSTEM_ITEMS_TL_TR1
6291: This Trigger causes a insert into EGO_ITEM_TEXT_TL for each row inserted into
6292: MTL_SYSTEM_ITEMS_TL, which causes performance issues. As part of bug 5701472,
6293: we will drop the intermedia index, disable trigger EGO_MTL_SYSTEM_ITEMS_TL_TR1
6294: batch insert into MTL_SYSTEM_ITEMS_TL and EGO_ITEM_TEXT_TL, enable the trigger
6295: and ask customer to launch the concurrent request to build the intermedia index
6296: (Item Catalog Text Index Build with CREATE option).*/
6297:

Line 6294: batch insert into MTL_SYSTEM_ITEMS_TL and EGO_ITEM_TEXT_TL, enable the trigger

6290: MTL_SYSTEM_ITEMS_TL has a row level trigger: EGO_MTL_SYSTEM_ITEMS_TL_TR1
6291: This Trigger causes a insert into EGO_ITEM_TEXT_TL for each row inserted into
6292: MTL_SYSTEM_ITEMS_TL, which causes performance issues. As part of bug 5701472,
6293: we will drop the intermedia index, disable trigger EGO_MTL_SYSTEM_ITEMS_TL_TR1
6294: batch insert into MTL_SYSTEM_ITEMS_TL and EGO_ITEM_TEXT_TL, enable the trigger
6295: and ask customer to launch the concurrent request to build the intermedia index
6296: (Item Catalog Text Index Build with CREATE option).*/
6297:
6298:

Line 6318: /Disable Trigger EGO_MTL_SYSTEM_ITEMS_TL_TR1, and we will bulk insert into EGO_ITEM_TEXT_TL /

6314: IF(l_index_name = 'EGO_ITEM_TEXT_TL_CTX1') THEN
6315: EXECUTE IMMEDIATE 'DROP INDEX ' || l_Prod_Schema || '.EGO_ITEM_TEXT_TL_CTX1 FORCE;';
6316: END IF;
6317:
6318: /*Disable Trigger EGO_MTL_SYSTEM_ITEMS_TL_TR1, and we will bulk insert into EGO_ITEM_TEXT_TL */
6319: EXECUTE IMMEDIATE
6320: 'ALTER TRIGGER EGO_MTL_SYSTEM_ITEMS_TL_TR1 DISABLE';
6321:
6322: /*

Line 6320: 'ALTER TRIGGER EGO_MTL_SYSTEM_ITEMS_TL_TR1 DISABLE';

6316: END IF;
6317:
6318: /*Disable Trigger EGO_MTL_SYSTEM_ITEMS_TL_TR1, and we will bulk insert into EGO_ITEM_TEXT_TL */
6319: EXECUTE IMMEDIATE
6320: 'ALTER TRIGGER EGO_MTL_SYSTEM_ITEMS_TL_TR1 DISABLE';
6321:
6322: /*
6323: Fix for bug 12922572 : FP of Bug 5701472-
6324: Disable the trigger MTL_SYSTEM_ITEMS_TL_TA_IBE based on the suggestions from IBE team

Line 6324: Disable the trigger MTL_SYSTEM_ITEMS_TL_TA_IBE based on the suggestions from IBE team

6320: 'ALTER TRIGGER EGO_MTL_SYSTEM_ITEMS_TL_TR1 DISABLE';
6321:
6322: /*
6323: Fix for bug 12922572 : FP of Bug 5701472-
6324: Disable the trigger MTL_SYSTEM_ITEMS_TL_TA_IBE based on the suggestions from IBE team
6325: in bug 5725517. Users need to run iStore Search concurrent programs for inserting
6326: into IBE_CT_IMEDIA_SEARCH
6327: */
6328: EXECUTE IMMEDIATE

Line 6329: 'ALTER TRIGGER MTL_SYSTEM_ITEMS_TL_TA_IBE DISABLE';

6325: in bug 5725517. Users need to run iStore Search concurrent programs for inserting
6326: into IBE_CT_IMEDIA_SEARCH
6327: */
6328: EXECUTE IMMEDIATE
6329: 'ALTER TRIGGER MTL_SYSTEM_ITEMS_TL_TA_IBE DISABLE';
6330:
6331: /*First insert missing language records into MTL_SYSTEM_ITEMS_TL*/
6332:
6333: INSERT

Line 6331: /First insert missing language records into MTL_SYSTEM_ITEMS_TL/

6327: */
6328: EXECUTE IMMEDIATE
6329: 'ALTER TRIGGER MTL_SYSTEM_ITEMS_TL_TA_IBE DISABLE';
6330:
6331: /*First insert missing language records into MTL_SYSTEM_ITEMS_TL*/
6332:
6333: INSERT
6334: /*+ APPEND PARALLEL(tt) */
6335: INTO MTL_SYSTEM_ITEMS_TL tt

Line 6335: INTO MTL_SYSTEM_ITEMS_TL tt

6331: /*First insert missing language records into MTL_SYSTEM_ITEMS_TL*/
6332:
6333: INSERT
6334: /*+ APPEND PARALLEL(tt) */
6335: INTO MTL_SYSTEM_ITEMS_TL tt
6336: (
6337: INVENTORY_ITEM_ID
6338: ,ORGANIZATION_ID
6339: ,DESCRIPTION

Line 6362: FROM MTL_SYSTEM_ITEMS_TL B ,

6358: ,B.CREATED_BY
6359: ,B.LAST_UPDATE_LOGIN
6360: ,L.LANGUAGE_CODE
6361: ,B.SOURCE_LANG
6362: FROM MTL_SYSTEM_ITEMS_TL B ,
6363: FND_LANGUAGES L
6364: WHERE L.INSTALLED_FLAG IN ( 'I','B' )
6365: AND B.LANGUAGE = USERENV ( 'LANG' )
6366: AND NOT EXISTS( SELECT /*+ parallel(t) */ NULL

Line 6367: FROM MTL_SYSTEM_ITEMS_TL T

6363: FND_LANGUAGES L
6364: WHERE L.INSTALLED_FLAG IN ( 'I','B' )
6365: AND B.LANGUAGE = USERENV ( 'LANG' )
6366: AND NOT EXISTS( SELECT /*+ parallel(t) */ NULL
6367: FROM MTL_SYSTEM_ITEMS_TL T
6368: WHERE T.INVENTORY_ITEM_ID = B.INVENTORY_ITEM_ID
6369: AND T.ORGANIZATION_ID = B.ORGANIZATION_ID
6370: AND T.LANGUAGE = L.LANGUAGE_CODE);
6371:

Line 6413: FROM MTL_SYSTEM_ITEMS_B_KFV MSIK,

6409: MSIK.CREATED_BY ,
6410: SYSDATE ,
6411: MSIK.LAST_UPDATED_BY,
6412: MSIK.LAST_UPDATE_LOGIN
6413: FROM MTL_SYSTEM_ITEMS_B_KFV MSIK,
6414: FND_LANGUAGES L
6415: WHERE L.INSTALLED_FLAG in ('I', 'B')
6416: AND MSIK.CONCATENATED_SEGMENTS IS NOT NULL
6417: AND MSIK.INVENTORY_ITEM_ID IS NOT NULL

Line 6431: /* Enable Trigger EGO_MTL_SYSTEM_ITEMS_TL_TR1. This will be required to keep

6427: WHERE EITL1.ID_TYPE = '$$INTERNAL$$'
6428: AND EITL1.LANGUAGE = L.LANGUAGE_CODE
6429: );
6430:
6431: /* Enable Trigger EGO_MTL_SYSTEM_ITEMS_TL_TR1. This will be required to keep
6432: EGO_ITEM_TEXT_TL table in sync during normal apps operations.
6433: */
6434:
6435: EXECUTE IMMEDIATE

Line 6436: 'ALTER TRIGGER EGO_MTL_SYSTEM_ITEMS_TL_TR1 ENABLE';

6432: EGO_ITEM_TEXT_TL table in sync during normal apps operations.
6433: */
6434:
6435: EXECUTE IMMEDIATE
6436: 'ALTER TRIGGER EGO_MTL_SYSTEM_ITEMS_TL_TR1 ENABLE';
6437:
6438: /* Enable the trigger MTL_SYSTEM_ITEMS_TL_TA_IBE. This will be required to keep
6439: IBE_CT_IMEDIA_SEARCH in sync during normal apps operations.
6440: */

Line 6438: /* Enable the trigger MTL_SYSTEM_ITEMS_TL_TA_IBE. This will be required to keep

6434:
6435: EXECUTE IMMEDIATE
6436: 'ALTER TRIGGER EGO_MTL_SYSTEM_ITEMS_TL_TR1 ENABLE';
6437:
6438: /* Enable the trigger MTL_SYSTEM_ITEMS_TL_TA_IBE. This will be required to keep
6439: IBE_CT_IMEDIA_SEARCH in sync during normal apps operations.
6440: */
6441: EXECUTE IMMEDIATE
6442: 'ALTER TRIGGER MTL_SYSTEM_ITEMS_TL_TA_IBE ENABLE';

Line 6442: 'ALTER TRIGGER MTL_SYSTEM_ITEMS_TL_TA_IBE ENABLE';

6438: /* Enable the trigger MTL_SYSTEM_ITEMS_TL_TA_IBE. This will be required to keep
6439: IBE_CT_IMEDIA_SEARCH in sync during normal apps operations.
6440: */
6441: EXECUTE IMMEDIATE
6442: 'ALTER TRIGGER MTL_SYSTEM_ITEMS_TL_TA_IBE ENABLE';
6443:
6444: /*Commit and call sync index so that iM index is in sync.*/
6445: COMMIT;
6446:

Line 6471: FROM MTL_SYSTEM_ITEMS_TL

6467: ,LANGUAGE
6468: ,SOURCE_LANG
6469: ,DESCRIPTION
6470: ,LONG_DESCRIPTION
6471: FROM MTL_SYSTEM_ITEMS_TL
6472: WHERE INVENTORY_ITEM_ID = X_INVENTORY_ITEM_ID
6473: AND ORGANIZATION_ID IN ( SELECT ORGANIZATION_ID
6474: FROM MTL_PARAMETERS
6475: WHERE MASTER_ORGANIZATION_ID = X_ORGANIZATION_ID

Line 6489: where attribute_name = 'MTL_SYSTEM_ITEMS.DESCRIPTION';

6485: begin
6486: select control_level
6487: into l_desc_control
6488: from mtl_item_attributes
6489: where attribute_name = 'MTL_SYSTEM_ITEMS.DESCRIPTION';
6490: exception
6491: when no_data_found then
6492: l_desc_control := 0;
6493: end;

Line 6499: where attribute_name = 'MTL_SYSTEM_ITEMS.LONG_DESCRIPTION';

6495: begin
6496: select control_level
6497: into l_longdesc_control
6498: from mtl_item_attributes
6499: where attribute_name = 'MTL_SYSTEM_ITEMS.LONG_DESCRIPTION';
6500: exception
6501: when no_data_found then
6502: l_longdesc_control := 0;
6503: end;

Line 6530: update mtl_system_items_tl

6526: end if;
6527: --- bug 8717482 vggarg end changes
6528:
6529: /*
6530: update mtl_system_items_tl
6531: set description = ltrim(rtrim(x_description)),
6532: long_description = ltrim(rtrim(x_long_description)),
6533: source_lang = x_language,
6534: last_updated_by = fnd_profile.value('USER_ID'),

Line 6543: update mtl_system_items_tl

6539: */
6540: for c1 in Item_csr
6541: loop
6542: if (l_desc_control = 1) and c1.description <> ltrim(rtrim(x_description)) then -- bug 14599786 for second issue
6543: update mtl_system_items_tl
6544: set description = ltrim(rtrim(x_description)),
6545: source_lang = x_language,
6546: last_update_date = sysdate,
6547: last_updated_by = fnd_profile.value('USER_ID'),

Line 6554: update mtl_system_items_tl

6550:
6551: end if;
6552:
6553: if (l_longdesc_control = 1) and c1.long_description <> ltrim(rtrim(x_long_description)) then -- bug 14599786 for second issue
6554: update mtl_system_items_tl
6555: set long_description = ltrim(rtrim(x_long_description)),
6556: source_lang = x_language,
6557: last_update_date = sysdate,
6558: last_updated_by = fnd_profile.value('USER_ID'),

Line 6616: from MTL_SYSTEM_ITEMS_B

6612:
6613: CURSOR c_item_name IS
6614: SELECT
6615: SEGMENT1
6616: from MTL_SYSTEM_ITEMS_B
6617: where INVENTORY_ITEM_ID = P_Item_Rec.inventory_item_id
6618: and ORGANIZATION_ID = P_Item_rec.organization_id
6619: for update of INVENTORY_ITEM_ID nowait;
6620: