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.INVPULI2 dependencies on MTL_SYSTEM_ITEMS_B

Line 47: from mtl_system_items_b

43:
44: CURSOR get_icc_id ( cp_inventory_item_id NUMBER, cp_organization_id NUMBER) /* 8808831 FP added cursor */
45: IS
46: select item_catalog_group_id
47: from mtl_system_items_b
48: where inventory_item_id = cp_inventory_item_id
49: and organization_id = cp_organization_id;
50:
51:

Line 131: AttRec MTL_SYSTEM_ITEMS_B%ROWTYPE;

127: WHERE mp.master_organization_id = cp_orgid
128: AND rownum = 1;
129:
130: l_isMasterOrg NUMBER;
131: AttRec MTL_SYSTEM_ITEMS_B%ROWTYPE;
132: context_orgid mtl_item_templates.context_organization_id%TYPE;
133: l_template_id mtl_item_templates.template_id%TYPE := NULL;
134: rtn_status number := 0;
135: dumm_status number := 0;

Line 141: l_icc_id mtl_system_items_b.item_catalog_group_id%TYPE := NULL;

137: l_error_exists BOOLEAN := FALSE;
138: l_column_name VARCHAR2(200);
139: l_message_name VARCHAR2(200);
140: l_cat_templ_count NUMBER := 0;
141: l_icc_id mtl_system_items_b.item_catalog_group_id%TYPE := NULL;
142:
143: l_inv_debug_level NUMBER := INVPUTLI.get_debug_level; --Bug: 4667452
144:
145: TYPE template_id_type IS TABLE OF

Line 212: FROM MTL_SYSTEM_ITEMS_B

208: FROM EGO_CAT_GRP_TEMPLATES
209: WHERE CATALOG_GROUP_ID IN (SELECT ITEM_CATALOG_GROUP_ID
210: FROM MTL_ITEM_CATALOG_GROUPS_B
211: START WITH ITEM_CATALOG_GROUP_ID = (SELECT NVL(ITEM_CATALOG_GROUP_ID,0)
212: FROM MTL_SYSTEM_ITEMS_B
213: WHERE INVENTORY_ITEM_ID = CUR.INVENTORY_ITEM_ID
214: AND ORGANIZATION_ID = CUR.ORGANIZATION_ID)
215: CONNECT BY PRIOR PARENT_CATALOG_GROUP_ID = ITEM_CATALOG_GROUP_ID);
216: END IF;

Line 470: elsif cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.BOM_ENABLED_FLAG' then AttRec.BOM_ENABLED_FLAG := nvl(cr.ATTRIBUTE_VALUE, '!');

466: elsif cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.ATP_RULE_ID' then AttRec.ATP_RULE_ID := nvl(cr.ATTRIBUTE_VALUE, -999999);
467: elsif cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.AUTO_LOT_ALPHA_PREFIX' then AttRec.AUTO_LOT_ALPHA_PREFIX := nvl(cr.ATTRIBUTE_VALUE, '!');
468: elsif cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.AUTO_REDUCE_MPS' then AttRec.AUTO_REDUCE_MPS := nvl(cr.ATTRIBUTE_VALUE, -999999);
469: elsif cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.AUTO_SERIAL_ALPHA_PREFIX' then AttRec.AUTO_SERIAL_ALPHA_PREFIX := nvl(cr.ATTRIBUTE_VALUE, '!');
470: elsif cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.BOM_ENABLED_FLAG' then AttRec.BOM_ENABLED_FLAG := nvl(cr.ATTRIBUTE_VALUE, '!');
471: elsif cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.BOM_ITEM_TYPE' then AttRec.BOM_ITEM_TYPE := nvl(cr.ATTRIBUTE_VALUE, -999999);
472: elsif cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.BUILD_IN_WIP_FLAG' then AttRec.BUILD_IN_WIP_FLAG := nvl(cr.ATTRIBUTE_VALUE, '!');
473: elsif cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.BUYER_ID' then AttRec.BUYER_ID := nvl(cr.ATTRIBUTE_VALUE, -999999);
474: elsif cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.CARRYING_COST' then AttRec.CARRYING_COST := nvl(cr.ATTRIBUTE_VALUE, -999999);

Line 471: elsif cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.BOM_ITEM_TYPE' then AttRec.BOM_ITEM_TYPE := nvl(cr.ATTRIBUTE_VALUE, -999999);

467: elsif cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.AUTO_LOT_ALPHA_PREFIX' then AttRec.AUTO_LOT_ALPHA_PREFIX := nvl(cr.ATTRIBUTE_VALUE, '!');
468: elsif cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.AUTO_REDUCE_MPS' then AttRec.AUTO_REDUCE_MPS := nvl(cr.ATTRIBUTE_VALUE, -999999);
469: elsif cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.AUTO_SERIAL_ALPHA_PREFIX' then AttRec.AUTO_SERIAL_ALPHA_PREFIX := nvl(cr.ATTRIBUTE_VALUE, '!');
470: elsif cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.BOM_ENABLED_FLAG' then AttRec.BOM_ENABLED_FLAG := nvl(cr.ATTRIBUTE_VALUE, '!');
471: elsif cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.BOM_ITEM_TYPE' then AttRec.BOM_ITEM_TYPE := nvl(cr.ATTRIBUTE_VALUE, -999999);
472: elsif cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.BUILD_IN_WIP_FLAG' then AttRec.BUILD_IN_WIP_FLAG := nvl(cr.ATTRIBUTE_VALUE, '!');
473: elsif cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.BUYER_ID' then AttRec.BUYER_ID := nvl(cr.ATTRIBUTE_VALUE, -999999);
474: elsif cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.CARRYING_COST' then AttRec.CARRYING_COST := nvl(cr.ATTRIBUTE_VALUE, -999999);
475: elsif cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.COLLATERAL_FLAG' then AttRec.COLLATERAL_FLAG := nvl(cr.ATTRIBUTE_VALUE, '!');

Line 472: elsif cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.BUILD_IN_WIP_FLAG' then AttRec.BUILD_IN_WIP_FLAG := nvl(cr.ATTRIBUTE_VALUE, '!');

468: elsif cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.AUTO_REDUCE_MPS' then AttRec.AUTO_REDUCE_MPS := nvl(cr.ATTRIBUTE_VALUE, -999999);
469: elsif cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.AUTO_SERIAL_ALPHA_PREFIX' then AttRec.AUTO_SERIAL_ALPHA_PREFIX := nvl(cr.ATTRIBUTE_VALUE, '!');
470: elsif cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.BOM_ENABLED_FLAG' then AttRec.BOM_ENABLED_FLAG := nvl(cr.ATTRIBUTE_VALUE, '!');
471: elsif cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.BOM_ITEM_TYPE' then AttRec.BOM_ITEM_TYPE := nvl(cr.ATTRIBUTE_VALUE, -999999);
472: elsif cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.BUILD_IN_WIP_FLAG' then AttRec.BUILD_IN_WIP_FLAG := nvl(cr.ATTRIBUTE_VALUE, '!');
473: elsif cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.BUYER_ID' then AttRec.BUYER_ID := nvl(cr.ATTRIBUTE_VALUE, -999999);
474: elsif cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.CARRYING_COST' then AttRec.CARRYING_COST := nvl(cr.ATTRIBUTE_VALUE, -999999);
475: elsif cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.COLLATERAL_FLAG' then AttRec.COLLATERAL_FLAG := nvl(cr.ATTRIBUTE_VALUE, '!');
476: elsif cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.COSTING_ENABLED_FLAG' then AttRec.COSTING_ENABLED_FLAG := nvl(cr.ATTRIBUTE_VALUE, '!');

Line 473: elsif cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.BUYER_ID' then AttRec.BUYER_ID := nvl(cr.ATTRIBUTE_VALUE, -999999);

469: elsif cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.AUTO_SERIAL_ALPHA_PREFIX' then AttRec.AUTO_SERIAL_ALPHA_PREFIX := nvl(cr.ATTRIBUTE_VALUE, '!');
470: elsif cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.BOM_ENABLED_FLAG' then AttRec.BOM_ENABLED_FLAG := nvl(cr.ATTRIBUTE_VALUE, '!');
471: elsif cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.BOM_ITEM_TYPE' then AttRec.BOM_ITEM_TYPE := nvl(cr.ATTRIBUTE_VALUE, -999999);
472: elsif cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.BUILD_IN_WIP_FLAG' then AttRec.BUILD_IN_WIP_FLAG := nvl(cr.ATTRIBUTE_VALUE, '!');
473: elsif cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.BUYER_ID' then AttRec.BUYER_ID := nvl(cr.ATTRIBUTE_VALUE, -999999);
474: elsif cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.CARRYING_COST' then AttRec.CARRYING_COST := nvl(cr.ATTRIBUTE_VALUE, -999999);
475: elsif cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.COLLATERAL_FLAG' then AttRec.COLLATERAL_FLAG := nvl(cr.ATTRIBUTE_VALUE, '!');
476: elsif cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.COSTING_ENABLED_FLAG' then AttRec.COSTING_ENABLED_FLAG := nvl(cr.ATTRIBUTE_VALUE, '!');
477: elsif cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.COVERAGE_SCHEDULE_ID' then AttRec.COVERAGE_SCHEDULE_ID := nvl(cr.ATTRIBUTE_VALUE, -999999);

Line 633: elsif cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.BACK_ORDERABLE_FLAG' then AttRec.BACK_ORDERABLE_FLAG := nvl(cr.ATTRIBUTE_VALUE, '!');

629: elsif cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.COMMS_NL_TRACKABLE_FLAG' then AttRec.COMMS_NL_TRACKABLE_FLAG := nvl(cr.ATTRIBUTE_VALUE, '!');
630: elsif cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.ASSET_CREATION_CODE' then AttRec.ASSET_CREATION_CODE := nvl(cr.ATTRIBUTE_VALUE, '!');
631: elsif cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.COMMS_ACTIVATION_REQD_FLAG' then AttRec.COMMS_ACTIVATION_REQD_FLAG := nvl(cr.ATTRIBUTE_VALUE, '!');
632: elsif cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.ORDERABLE_ON_WEB_FLAG' then AttRec.ORDERABLE_ON_WEB_FLAG := nvl(cr.ATTRIBUTE_VALUE, '!');
633: elsif cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.BACK_ORDERABLE_FLAG' then AttRec.BACK_ORDERABLE_FLAG := nvl(cr.ATTRIBUTE_VALUE, '!');
634: elsif cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.WEB_STATUS' then AttRec.WEB_STATUS := nvl(cr.ATTRIBUTE_VALUE, '!');
635: elsif cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.INDIVISIBLE_FLAG' then AttRec.INDIVISIBLE_FLAG := nvl(cr.ATTRIBUTE_VALUE, '!');
636: elsif cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.DIMENSION_UOM_CODE' then AttRec.DIMENSION_UOM_CODE := nvl(cr.ATTRIBUTE_VALUE, '!');
637: elsif cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.UNIT_LENGTH' then AttRec.UNIT_LENGTH := nvl(cr.ATTRIBUTE_VALUE, -999999);

Line 640: elsif cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.BULK_PICKED_FLAG' then AttRec.BULK_PICKED_FLAG := nvl(cr.ATTRIBUTE_VALUE, '!');

636: elsif cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.DIMENSION_UOM_CODE' then AttRec.DIMENSION_UOM_CODE := nvl(cr.ATTRIBUTE_VALUE, '!');
637: elsif cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.UNIT_LENGTH' then AttRec.UNIT_LENGTH := nvl(cr.ATTRIBUTE_VALUE, -999999);
638: elsif cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.UNIT_WIDTH' then AttRec.UNIT_WIDTH := nvl(cr.ATTRIBUTE_VALUE, -999999);
639: elsif cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.UNIT_HEIGHT' then AttRec.UNIT_HEIGHT := nvl(cr.ATTRIBUTE_VALUE, -999999);
640: elsif cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.BULK_PICKED_FLAG' then AttRec.BULK_PICKED_FLAG := nvl(cr.ATTRIBUTE_VALUE, '!');
641: elsif cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.LOT_STATUS_ENABLED' then AttRec.LOT_STATUS_ENABLED := nvl(cr.ATTRIBUTE_VALUE, '!');
642: elsif cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.DEFAULT_LOT_STATUS_ID' then AttRec.DEFAULT_LOT_STATUS_ID := nvl(cr.ATTRIBUTE_VALUE, -999999);
643: elsif cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.SERIAL_STATUS_ENABLED' then AttRec.SERIAL_STATUS_ENABLED := nvl(cr.ATTRIBUTE_VALUE, '!');
644: elsif cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.DEFAULT_SERIAL_STATUS_ID' then AttRec.DEFAULT_SERIAL_STATUS_ID := nvl(cr.ATTRIBUTE_VALUE, -999999);

Line 731: elsif cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.BASE_ITEM_ID' then AttRec.BASE_ITEM_ID := nvl(cr.ATTRIBUTE_VALUE, -999999);

727: elsif cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.MATURITY_DAYS' then AttRec.MATURITY_DAYS := nvl(cr.ATTRIBUTE_VALUE, -999999);
728: elsif cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.HOLD_DAYS' then AttRec.HOLD_DAYS := nvl(cr.ATTRIBUTE_VALUE, -999999);
729: /* End Bug 3713912 */
730: --Org specific attributes
731: elsif cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.BASE_ITEM_ID' then AttRec.BASE_ITEM_ID := nvl(cr.ATTRIBUTE_VALUE, -999999);
732: elsif cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.BASE_WARRANTY_SERVICE_ID' then AttRec.BASE_WARRANTY_SERVICE_ID := nvl(cr.ATTRIBUTE_VALUE, -999999);
733: elsif cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.COST_OF_SALES_ACCOUNT' then AttRec.COST_OF_SALES_ACCOUNT := nvl(cr.ATTRIBUTE_VALUE, -999999);
734: elsif cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.ENCUMBRANCE_ACCOUNT' then AttRec.ENCUMBRANCE_ACCOUNT := nvl(cr.ATTRIBUTE_VALUE, -999999);
735: elsif cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.EXPENSE_ACCOUNT' then AttRec.EXPENSE_ACCOUNT := nvl(cr.ATTRIBUTE_VALUE, -999999);

Line 732: elsif cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.BASE_WARRANTY_SERVICE_ID' then AttRec.BASE_WARRANTY_SERVICE_ID := nvl(cr.ATTRIBUTE_VALUE, -999999);

728: elsif cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.HOLD_DAYS' then AttRec.HOLD_DAYS := nvl(cr.ATTRIBUTE_VALUE, -999999);
729: /* End Bug 3713912 */
730: --Org specific attributes
731: elsif cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.BASE_ITEM_ID' then AttRec.BASE_ITEM_ID := nvl(cr.ATTRIBUTE_VALUE, -999999);
732: elsif cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.BASE_WARRANTY_SERVICE_ID' then AttRec.BASE_WARRANTY_SERVICE_ID := nvl(cr.ATTRIBUTE_VALUE, -999999);
733: elsif cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.COST_OF_SALES_ACCOUNT' then AttRec.COST_OF_SALES_ACCOUNT := nvl(cr.ATTRIBUTE_VALUE, -999999);
734: elsif cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.ENCUMBRANCE_ACCOUNT' then AttRec.ENCUMBRANCE_ACCOUNT := nvl(cr.ATTRIBUTE_VALUE, -999999);
735: elsif cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.EXPENSE_ACCOUNT' then AttRec.EXPENSE_ACCOUNT := nvl(cr.ATTRIBUTE_VALUE, -999999);
736: elsif cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.PLANNER_CODE' then AttRec.PLANNER_CODE := nvl(cr.ATTRIBUTE_VALUE, '!');

Line 767: elsif cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.BOM_ENABLED_FLAG' then AttRec.BOM_ENABLED_FLAG := cr.ATTRIBUTE_VALUE;

763: elsif cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.ATP_RULE_ID' then AttRec.ATP_RULE_ID := cr.ATTRIBUTE_VALUE;
764: elsif cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.AUTO_LOT_ALPHA_PREFIX' then AttRec.AUTO_LOT_ALPHA_PREFIX := cr.ATTRIBUTE_VALUE;
765: elsif cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.AUTO_REDUCE_MPS' then AttRec.AUTO_REDUCE_MPS := cr.ATTRIBUTE_VALUE;
766: elsif cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.AUTO_SERIAL_ALPHA_PREFIX' then AttRec.AUTO_SERIAL_ALPHA_PREFIX := cr.ATTRIBUTE_VALUE;
767: elsif cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.BOM_ENABLED_FLAG' then AttRec.BOM_ENABLED_FLAG := cr.ATTRIBUTE_VALUE;
768: elsif cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.BOM_ITEM_TYPE' then AttRec.BOM_ITEM_TYPE := cr.ATTRIBUTE_VALUE;
769: elsif cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.BUILD_IN_WIP_FLAG' then AttRec.BUILD_IN_WIP_FLAG := cr.ATTRIBUTE_VALUE;
770: elsif cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.BUYER_ID' then AttRec.BUYER_ID := cr.ATTRIBUTE_VALUE;
771: elsif cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.CARRYING_COST' then AttRec.CARRYING_COST := cr.ATTRIBUTE_VALUE;

Line 768: elsif cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.BOM_ITEM_TYPE' then AttRec.BOM_ITEM_TYPE := cr.ATTRIBUTE_VALUE;

764: elsif cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.AUTO_LOT_ALPHA_PREFIX' then AttRec.AUTO_LOT_ALPHA_PREFIX := cr.ATTRIBUTE_VALUE;
765: elsif cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.AUTO_REDUCE_MPS' then AttRec.AUTO_REDUCE_MPS := cr.ATTRIBUTE_VALUE;
766: elsif cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.AUTO_SERIAL_ALPHA_PREFIX' then AttRec.AUTO_SERIAL_ALPHA_PREFIX := cr.ATTRIBUTE_VALUE;
767: elsif cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.BOM_ENABLED_FLAG' then AttRec.BOM_ENABLED_FLAG := cr.ATTRIBUTE_VALUE;
768: elsif cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.BOM_ITEM_TYPE' then AttRec.BOM_ITEM_TYPE := cr.ATTRIBUTE_VALUE;
769: elsif cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.BUILD_IN_WIP_FLAG' then AttRec.BUILD_IN_WIP_FLAG := cr.ATTRIBUTE_VALUE;
770: elsif cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.BUYER_ID' then AttRec.BUYER_ID := cr.ATTRIBUTE_VALUE;
771: elsif cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.CARRYING_COST' then AttRec.CARRYING_COST := cr.ATTRIBUTE_VALUE;
772: elsif cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.COLLATERAL_FLAG' then AttRec.COLLATERAL_FLAG := cr.ATTRIBUTE_VALUE;

Line 769: elsif cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.BUILD_IN_WIP_FLAG' then AttRec.BUILD_IN_WIP_FLAG := cr.ATTRIBUTE_VALUE;

765: elsif cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.AUTO_REDUCE_MPS' then AttRec.AUTO_REDUCE_MPS := cr.ATTRIBUTE_VALUE;
766: elsif cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.AUTO_SERIAL_ALPHA_PREFIX' then AttRec.AUTO_SERIAL_ALPHA_PREFIX := cr.ATTRIBUTE_VALUE;
767: elsif cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.BOM_ENABLED_FLAG' then AttRec.BOM_ENABLED_FLAG := cr.ATTRIBUTE_VALUE;
768: elsif cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.BOM_ITEM_TYPE' then AttRec.BOM_ITEM_TYPE := cr.ATTRIBUTE_VALUE;
769: elsif cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.BUILD_IN_WIP_FLAG' then AttRec.BUILD_IN_WIP_FLAG := cr.ATTRIBUTE_VALUE;
770: elsif cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.BUYER_ID' then AttRec.BUYER_ID := cr.ATTRIBUTE_VALUE;
771: elsif cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.CARRYING_COST' then AttRec.CARRYING_COST := cr.ATTRIBUTE_VALUE;
772: elsif cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.COLLATERAL_FLAG' then AttRec.COLLATERAL_FLAG := cr.ATTRIBUTE_VALUE;
773: elsif cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.COSTING_ENABLED_FLAG' then AttRec.COSTING_ENABLED_FLAG := cr.ATTRIBUTE_VALUE;

Line 770: elsif cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.BUYER_ID' then AttRec.BUYER_ID := cr.ATTRIBUTE_VALUE;

766: elsif cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.AUTO_SERIAL_ALPHA_PREFIX' then AttRec.AUTO_SERIAL_ALPHA_PREFIX := cr.ATTRIBUTE_VALUE;
767: elsif cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.BOM_ENABLED_FLAG' then AttRec.BOM_ENABLED_FLAG := cr.ATTRIBUTE_VALUE;
768: elsif cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.BOM_ITEM_TYPE' then AttRec.BOM_ITEM_TYPE := cr.ATTRIBUTE_VALUE;
769: elsif cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.BUILD_IN_WIP_FLAG' then AttRec.BUILD_IN_WIP_FLAG := cr.ATTRIBUTE_VALUE;
770: elsif cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.BUYER_ID' then AttRec.BUYER_ID := cr.ATTRIBUTE_VALUE;
771: elsif cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.CARRYING_COST' then AttRec.CARRYING_COST := cr.ATTRIBUTE_VALUE;
772: elsif cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.COLLATERAL_FLAG' then AttRec.COLLATERAL_FLAG := cr.ATTRIBUTE_VALUE;
773: elsif cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.COSTING_ENABLED_FLAG' then AttRec.COSTING_ENABLED_FLAG := cr.ATTRIBUTE_VALUE;
774: elsif cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.COVERAGE_SCHEDULE_ID' then AttRec.COVERAGE_SCHEDULE_ID := cr.ATTRIBUTE_VALUE;

Line 930: elsif cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.BACK_ORDERABLE_FLAG' then AttRec.BACK_ORDERABLE_FLAG := cr.ATTRIBUTE_VALUE;

926: elsif cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.COMMS_NL_TRACKABLE_FLAG' then AttRec.COMMS_NL_TRACKABLE_FLAG := cr.ATTRIBUTE_VALUE;
927: elsif cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.ASSET_CREATION_CODE' then AttRec.ASSET_CREATION_CODE := cr.ATTRIBUTE_VALUE;
928: elsif cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.COMMS_ACTIVATION_REQD_FLAG' then AttRec.COMMS_ACTIVATION_REQD_FLAG := cr.ATTRIBUTE_VALUE;
929: elsif cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.ORDERABLE_ON_WEB_FLAG' then AttRec.ORDERABLE_ON_WEB_FLAG := cr.ATTRIBUTE_VALUE;
930: elsif cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.BACK_ORDERABLE_FLAG' then AttRec.BACK_ORDERABLE_FLAG := cr.ATTRIBUTE_VALUE;
931: elsif cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.WEB_STATUS' then AttRec.WEB_STATUS := cr.ATTRIBUTE_VALUE;
932: elsif cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.INDIVISIBLE_FLAG' then AttRec.INDIVISIBLE_FLAG := cr.ATTRIBUTE_VALUE;
933: elsif cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.DIMENSION_UOM_CODE' then AttRec.DIMENSION_UOM_CODE := cr.ATTRIBUTE_VALUE;
934: elsif cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.UNIT_LENGTH' then AttRec.UNIT_LENGTH := cr.ATTRIBUTE_VALUE;

Line 937: elsif cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.BULK_PICKED_FLAG' then AttRec.BULK_PICKED_FLAG := cr.ATTRIBUTE_VALUE;

933: elsif cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.DIMENSION_UOM_CODE' then AttRec.DIMENSION_UOM_CODE := cr.ATTRIBUTE_VALUE;
934: elsif cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.UNIT_LENGTH' then AttRec.UNIT_LENGTH := cr.ATTRIBUTE_VALUE;
935: elsif cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.UNIT_WIDTH' then AttRec.UNIT_WIDTH := cr.ATTRIBUTE_VALUE;
936: elsif cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.UNIT_HEIGHT' then AttRec.UNIT_HEIGHT := cr.ATTRIBUTE_VALUE;
937: elsif cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.BULK_PICKED_FLAG' then AttRec.BULK_PICKED_FLAG := cr.ATTRIBUTE_VALUE;
938: elsif cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.LOT_STATUS_ENABLED' then AttRec.LOT_STATUS_ENABLED := cr.ATTRIBUTE_VALUE;
939: elsif cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.DEFAULT_LOT_STATUS_ID' then AttRec.DEFAULT_LOT_STATUS_ID := cr.ATTRIBUTE_VALUE;
940: elsif cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.SERIAL_STATUS_ENABLED' then AttRec.SERIAL_STATUS_ENABLED := cr.ATTRIBUTE_VALUE;
941: elsif cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.DEFAULT_SERIAL_STATUS_ID' then AttRec.DEFAULT_SERIAL_STATUS_ID := cr.ATTRIBUTE_VALUE;

Line 1028: elsif cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.BASE_ITEM_ID' then AttRec.BASE_ITEM_ID := cr.ATTRIBUTE_VALUE;

1024: elsif cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.MATURITY_DAYS' then AttRec.MATURITY_DAYS := cr.ATTRIBUTE_VALUE;
1025: elsif cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.HOLD_DAYS' then AttRec.HOLD_DAYS := cr.ATTRIBUTE_VALUE;
1026: -- End Bug 3713912
1027: --Org specific attributes
1028: elsif cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.BASE_ITEM_ID' then AttRec.BASE_ITEM_ID := cr.ATTRIBUTE_VALUE;
1029: elsif cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.BASE_WARRANTY_SERVICE_ID' then AttRec.BASE_WARRANTY_SERVICE_ID := cr.ATTRIBUTE_VALUE;
1030: elsif cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.COST_OF_SALES_ACCOUNT' then AttRec.COST_OF_SALES_ACCOUNT := cr.ATTRIBUTE_VALUE;
1031: elsif cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.ENCUMBRANCE_ACCOUNT' then AttRec.ENCUMBRANCE_ACCOUNT := cr.ATTRIBUTE_VALUE;
1032: elsif cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.EXPENSE_ACCOUNT' then AttRec.EXPENSE_ACCOUNT := cr.ATTRIBUTE_VALUE;

Line 1029: elsif cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.BASE_WARRANTY_SERVICE_ID' then AttRec.BASE_WARRANTY_SERVICE_ID := cr.ATTRIBUTE_VALUE;

1025: elsif cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.HOLD_DAYS' then AttRec.HOLD_DAYS := cr.ATTRIBUTE_VALUE;
1026: -- End Bug 3713912
1027: --Org specific attributes
1028: elsif cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.BASE_ITEM_ID' then AttRec.BASE_ITEM_ID := cr.ATTRIBUTE_VALUE;
1029: elsif cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.BASE_WARRANTY_SERVICE_ID' then AttRec.BASE_WARRANTY_SERVICE_ID := cr.ATTRIBUTE_VALUE;
1030: elsif cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.COST_OF_SALES_ACCOUNT' then AttRec.COST_OF_SALES_ACCOUNT := cr.ATTRIBUTE_VALUE;
1031: elsif cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.ENCUMBRANCE_ACCOUNT' then AttRec.ENCUMBRANCE_ACCOUNT := cr.ATTRIBUTE_VALUE;
1032: elsif cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.EXPENSE_ACCOUNT' then AttRec.EXPENSE_ACCOUNT := cr.ATTRIBUTE_VALUE;
1033: elsif cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.PLANNER_CODE' then AttRec.PLANNER_CODE := cr.ATTRIBUTE_VALUE;