DBA Data[Home] [Help]

APPS.INVPULI2 dependencies on MTL_SYSTEM_ITEMS_B

Line 91: AttRec MTL_SYSTEM_ITEMS_B%ROWTYPE;

87: WHERE mp.master_organization_id = cp_orgid
88: AND rownum = 1;
89:
90: l_isMasterOrg NUMBER;
91: AttRec MTL_SYSTEM_ITEMS_B%ROWTYPE;
92: context_orgid mtl_item_templates.context_organization_id%TYPE;
93: l_template_id mtl_item_templates.template_id%TYPE := NULL;
94: rtn_status number := 0;
95: dumm_status number := 0;

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

285: elsif cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.ATP_RULE_ID' then AttRec.ATP_RULE_ID := nvl(cr.ATTRIBUTE_VALUE, -999999);
286: elsif cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.AUTO_LOT_ALPHA_PREFIX' then AttRec.AUTO_LOT_ALPHA_PREFIX := nvl(cr.ATTRIBUTE_VALUE, '!');
287: elsif cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.AUTO_REDUCE_MPS' then AttRec.AUTO_REDUCE_MPS := nvl(cr.ATTRIBUTE_VALUE, -999999);
288: elsif cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.AUTO_SERIAL_ALPHA_PREFIX' then AttRec.AUTO_SERIAL_ALPHA_PREFIX := nvl(cr.ATTRIBUTE_VALUE, '!');
289: elsif cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.BOM_ENABLED_FLAG' then AttRec.BOM_ENABLED_FLAG := nvl(cr.ATTRIBUTE_VALUE, '!');
290: elsif cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.BOM_ITEM_TYPE' then AttRec.BOM_ITEM_TYPE := nvl(cr.ATTRIBUTE_VALUE, -999999);
291: elsif cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.BUILD_IN_WIP_FLAG' then AttRec.BUILD_IN_WIP_FLAG := nvl(cr.ATTRIBUTE_VALUE, '!');
292: elsif cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.BUYER_ID' then AttRec.BUYER_ID := nvl(cr.ATTRIBUTE_VALUE, -999999);
293: elsif cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.CARRYING_COST' then AttRec.CARRYING_COST := nvl(cr.ATTRIBUTE_VALUE, -999999);

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

286: elsif cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.AUTO_LOT_ALPHA_PREFIX' then AttRec.AUTO_LOT_ALPHA_PREFIX := nvl(cr.ATTRIBUTE_VALUE, '!');
287: elsif cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.AUTO_REDUCE_MPS' then AttRec.AUTO_REDUCE_MPS := nvl(cr.ATTRIBUTE_VALUE, -999999);
288: elsif cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.AUTO_SERIAL_ALPHA_PREFIX' then AttRec.AUTO_SERIAL_ALPHA_PREFIX := nvl(cr.ATTRIBUTE_VALUE, '!');
289: elsif cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.BOM_ENABLED_FLAG' then AttRec.BOM_ENABLED_FLAG := nvl(cr.ATTRIBUTE_VALUE, '!');
290: elsif cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.BOM_ITEM_TYPE' then AttRec.BOM_ITEM_TYPE := nvl(cr.ATTRIBUTE_VALUE, -999999);
291: elsif cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.BUILD_IN_WIP_FLAG' then AttRec.BUILD_IN_WIP_FLAG := nvl(cr.ATTRIBUTE_VALUE, '!');
292: elsif cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.BUYER_ID' then AttRec.BUYER_ID := nvl(cr.ATTRIBUTE_VALUE, -999999);
293: elsif cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.CARRYING_COST' then AttRec.CARRYING_COST := nvl(cr.ATTRIBUTE_VALUE, -999999);
294: elsif cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.COLLATERAL_FLAG' then AttRec.COLLATERAL_FLAG := nvl(cr.ATTRIBUTE_VALUE, '!');

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

287: elsif cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.AUTO_REDUCE_MPS' then AttRec.AUTO_REDUCE_MPS := nvl(cr.ATTRIBUTE_VALUE, -999999);
288: elsif cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.AUTO_SERIAL_ALPHA_PREFIX' then AttRec.AUTO_SERIAL_ALPHA_PREFIX := nvl(cr.ATTRIBUTE_VALUE, '!');
289: elsif cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.BOM_ENABLED_FLAG' then AttRec.BOM_ENABLED_FLAG := nvl(cr.ATTRIBUTE_VALUE, '!');
290: elsif cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.BOM_ITEM_TYPE' then AttRec.BOM_ITEM_TYPE := nvl(cr.ATTRIBUTE_VALUE, -999999);
291: elsif cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.BUILD_IN_WIP_FLAG' then AttRec.BUILD_IN_WIP_FLAG := nvl(cr.ATTRIBUTE_VALUE, '!');
292: elsif cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.BUYER_ID' then AttRec.BUYER_ID := nvl(cr.ATTRIBUTE_VALUE, -999999);
293: elsif cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.CARRYING_COST' then AttRec.CARRYING_COST := nvl(cr.ATTRIBUTE_VALUE, -999999);
294: elsif cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.COLLATERAL_FLAG' then AttRec.COLLATERAL_FLAG := nvl(cr.ATTRIBUTE_VALUE, '!');
295: elsif cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.COSTING_ENABLED_FLAG' then AttRec.COSTING_ENABLED_FLAG := nvl(cr.ATTRIBUTE_VALUE, '!');

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

288: elsif cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.AUTO_SERIAL_ALPHA_PREFIX' then AttRec.AUTO_SERIAL_ALPHA_PREFIX := nvl(cr.ATTRIBUTE_VALUE, '!');
289: elsif cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.BOM_ENABLED_FLAG' then AttRec.BOM_ENABLED_FLAG := nvl(cr.ATTRIBUTE_VALUE, '!');
290: elsif cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.BOM_ITEM_TYPE' then AttRec.BOM_ITEM_TYPE := nvl(cr.ATTRIBUTE_VALUE, -999999);
291: elsif cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.BUILD_IN_WIP_FLAG' then AttRec.BUILD_IN_WIP_FLAG := nvl(cr.ATTRIBUTE_VALUE, '!');
292: elsif cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.BUYER_ID' then AttRec.BUYER_ID := nvl(cr.ATTRIBUTE_VALUE, -999999);
293: elsif cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.CARRYING_COST' then AttRec.CARRYING_COST := nvl(cr.ATTRIBUTE_VALUE, -999999);
294: elsif cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.COLLATERAL_FLAG' then AttRec.COLLATERAL_FLAG := nvl(cr.ATTRIBUTE_VALUE, '!');
295: elsif cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.COSTING_ENABLED_FLAG' then AttRec.COSTING_ENABLED_FLAG := nvl(cr.ATTRIBUTE_VALUE, '!');
296: elsif cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.COVERAGE_SCHEDULE_ID' then AttRec.COVERAGE_SCHEDULE_ID := nvl(cr.ATTRIBUTE_VALUE, -999999);

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

448: elsif cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.COMMS_NL_TRACKABLE_FLAG' then AttRec.COMMS_NL_TRACKABLE_FLAG := nvl(cr.ATTRIBUTE_VALUE, '!');
449: elsif cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.ASSET_CREATION_CODE' then AttRec.ASSET_CREATION_CODE := nvl(cr.ATTRIBUTE_VALUE, '!');
450: elsif cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.COMMS_ACTIVATION_REQD_FLAG' then AttRec.COMMS_ACTIVATION_REQD_FLAG := nvl(cr.ATTRIBUTE_VALUE, '!');
451: elsif cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.ORDERABLE_ON_WEB_FLAG' then AttRec.ORDERABLE_ON_WEB_FLAG := nvl(cr.ATTRIBUTE_VALUE, '!');
452: elsif cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.BACK_ORDERABLE_FLAG' then AttRec.BACK_ORDERABLE_FLAG := nvl(cr.ATTRIBUTE_VALUE, '!');
453: elsif cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.WEB_STATUS' then AttRec.WEB_STATUS := nvl(cr.ATTRIBUTE_VALUE, '!');
454: elsif cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.INDIVISIBLE_FLAG' then AttRec.INDIVISIBLE_FLAG := nvl(cr.ATTRIBUTE_VALUE, '!');
455: elsif cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.DIMENSION_UOM_CODE' then AttRec.DIMENSION_UOM_CODE := nvl(cr.ATTRIBUTE_VALUE, '!');
456: elsif cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.UNIT_LENGTH' then AttRec.UNIT_LENGTH := nvl(cr.ATTRIBUTE_VALUE, -999999);

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

455: elsif cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.DIMENSION_UOM_CODE' then AttRec.DIMENSION_UOM_CODE := nvl(cr.ATTRIBUTE_VALUE, '!');
456: elsif cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.UNIT_LENGTH' then AttRec.UNIT_LENGTH := nvl(cr.ATTRIBUTE_VALUE, -999999);
457: elsif cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.UNIT_WIDTH' then AttRec.UNIT_WIDTH := nvl(cr.ATTRIBUTE_VALUE, -999999);
458: elsif cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.UNIT_HEIGHT' then AttRec.UNIT_HEIGHT := nvl(cr.ATTRIBUTE_VALUE, -999999);
459: elsif cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.BULK_PICKED_FLAG' then AttRec.BULK_PICKED_FLAG := nvl(cr.ATTRIBUTE_VALUE, '!');
460: elsif cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.LOT_STATUS_ENABLED' then AttRec.LOT_STATUS_ENABLED := nvl(cr.ATTRIBUTE_VALUE, '!');
461: elsif cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.DEFAULT_LOT_STATUS_ID' then AttRec.DEFAULT_LOT_STATUS_ID := nvl(cr.ATTRIBUTE_VALUE, -999999);
462: elsif cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.SERIAL_STATUS_ENABLED' then AttRec.SERIAL_STATUS_ENABLED := nvl(cr.ATTRIBUTE_VALUE, '!');
463: elsif cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.DEFAULT_SERIAL_STATUS_ID' then AttRec.DEFAULT_SERIAL_STATUS_ID := nvl(cr.ATTRIBUTE_VALUE, -999999);

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

546: elsif cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.MATURITY_DAYS' then AttRec.MATURITY_DAYS := nvl(cr.ATTRIBUTE_VALUE, -999999);
547: elsif cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.HOLD_DAYS' then AttRec.HOLD_DAYS := nvl(cr.ATTRIBUTE_VALUE, -999999);
548: /* End Bug 3713912 */
549: --Org specific attributes
550: elsif cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.BASE_ITEM_ID' then AttRec.BASE_ITEM_ID := nvl(cr.ATTRIBUTE_VALUE, -999999);
551: elsif cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.BASE_WARRANTY_SERVICE_ID' then AttRec.BASE_WARRANTY_SERVICE_ID := nvl(cr.ATTRIBUTE_VALUE, -999999);
552: elsif cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.COST_OF_SALES_ACCOUNT' then AttRec.COST_OF_SALES_ACCOUNT := nvl(cr.ATTRIBUTE_VALUE, -999999);
553: elsif cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.ENCUMBRANCE_ACCOUNT' then AttRec.ENCUMBRANCE_ACCOUNT := nvl(cr.ATTRIBUTE_VALUE, -999999);
554: elsif cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.EXPENSE_ACCOUNT' then AttRec.EXPENSE_ACCOUNT := nvl(cr.ATTRIBUTE_VALUE, -999999);

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

547: elsif cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.HOLD_DAYS' then AttRec.HOLD_DAYS := nvl(cr.ATTRIBUTE_VALUE, -999999);
548: /* End Bug 3713912 */
549: --Org specific attributes
550: elsif cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.BASE_ITEM_ID' then AttRec.BASE_ITEM_ID := nvl(cr.ATTRIBUTE_VALUE, -999999);
551: elsif cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.BASE_WARRANTY_SERVICE_ID' then AttRec.BASE_WARRANTY_SERVICE_ID := nvl(cr.ATTRIBUTE_VALUE, -999999);
552: elsif cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.COST_OF_SALES_ACCOUNT' then AttRec.COST_OF_SALES_ACCOUNT := nvl(cr.ATTRIBUTE_VALUE, -999999);
553: elsif cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.ENCUMBRANCE_ACCOUNT' then AttRec.ENCUMBRANCE_ACCOUNT := nvl(cr.ATTRIBUTE_VALUE, -999999);
554: elsif cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.EXPENSE_ACCOUNT' then AttRec.EXPENSE_ACCOUNT := nvl(cr.ATTRIBUTE_VALUE, -999999);
555: elsif cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.PLANNER_CODE' then AttRec.PLANNER_CODE := nvl(cr.ATTRIBUTE_VALUE, '!');

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

582: elsif cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.ATP_RULE_ID' then AttRec.ATP_RULE_ID := cr.ATTRIBUTE_VALUE;
583: elsif cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.AUTO_LOT_ALPHA_PREFIX' then AttRec.AUTO_LOT_ALPHA_PREFIX := cr.ATTRIBUTE_VALUE;
584: elsif cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.AUTO_REDUCE_MPS' then AttRec.AUTO_REDUCE_MPS := cr.ATTRIBUTE_VALUE;
585: elsif cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.AUTO_SERIAL_ALPHA_PREFIX' then AttRec.AUTO_SERIAL_ALPHA_PREFIX := cr.ATTRIBUTE_VALUE;
586: elsif cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.BOM_ENABLED_FLAG' then AttRec.BOM_ENABLED_FLAG := cr.ATTRIBUTE_VALUE;
587: elsif cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.BOM_ITEM_TYPE' then AttRec.BOM_ITEM_TYPE := cr.ATTRIBUTE_VALUE;
588: elsif cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.BUILD_IN_WIP_FLAG' then AttRec.BUILD_IN_WIP_FLAG := cr.ATTRIBUTE_VALUE;
589: elsif cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.BUYER_ID' then AttRec.BUYER_ID := cr.ATTRIBUTE_VALUE;
590: elsif cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.CARRYING_COST' then AttRec.CARRYING_COST := cr.ATTRIBUTE_VALUE;

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

583: elsif cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.AUTO_LOT_ALPHA_PREFIX' then AttRec.AUTO_LOT_ALPHA_PREFIX := cr.ATTRIBUTE_VALUE;
584: elsif cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.AUTO_REDUCE_MPS' then AttRec.AUTO_REDUCE_MPS := cr.ATTRIBUTE_VALUE;
585: elsif cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.AUTO_SERIAL_ALPHA_PREFIX' then AttRec.AUTO_SERIAL_ALPHA_PREFIX := cr.ATTRIBUTE_VALUE;
586: elsif cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.BOM_ENABLED_FLAG' then AttRec.BOM_ENABLED_FLAG := cr.ATTRIBUTE_VALUE;
587: elsif cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.BOM_ITEM_TYPE' then AttRec.BOM_ITEM_TYPE := cr.ATTRIBUTE_VALUE;
588: elsif cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.BUILD_IN_WIP_FLAG' then AttRec.BUILD_IN_WIP_FLAG := cr.ATTRIBUTE_VALUE;
589: elsif cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.BUYER_ID' then AttRec.BUYER_ID := cr.ATTRIBUTE_VALUE;
590: elsif cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.CARRYING_COST' then AttRec.CARRYING_COST := cr.ATTRIBUTE_VALUE;
591: elsif cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.COLLATERAL_FLAG' then AttRec.COLLATERAL_FLAG := cr.ATTRIBUTE_VALUE;

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

584: elsif cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.AUTO_REDUCE_MPS' then AttRec.AUTO_REDUCE_MPS := cr.ATTRIBUTE_VALUE;
585: elsif cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.AUTO_SERIAL_ALPHA_PREFIX' then AttRec.AUTO_SERIAL_ALPHA_PREFIX := cr.ATTRIBUTE_VALUE;
586: elsif cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.BOM_ENABLED_FLAG' then AttRec.BOM_ENABLED_FLAG := cr.ATTRIBUTE_VALUE;
587: elsif cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.BOM_ITEM_TYPE' then AttRec.BOM_ITEM_TYPE := cr.ATTRIBUTE_VALUE;
588: elsif cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.BUILD_IN_WIP_FLAG' then AttRec.BUILD_IN_WIP_FLAG := cr.ATTRIBUTE_VALUE;
589: elsif cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.BUYER_ID' then AttRec.BUYER_ID := cr.ATTRIBUTE_VALUE;
590: elsif cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.CARRYING_COST' then AttRec.CARRYING_COST := cr.ATTRIBUTE_VALUE;
591: elsif cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.COLLATERAL_FLAG' then AttRec.COLLATERAL_FLAG := cr.ATTRIBUTE_VALUE;
592: elsif cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.COSTING_ENABLED_FLAG' then AttRec.COSTING_ENABLED_FLAG := cr.ATTRIBUTE_VALUE;

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

585: elsif cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.AUTO_SERIAL_ALPHA_PREFIX' then AttRec.AUTO_SERIAL_ALPHA_PREFIX := cr.ATTRIBUTE_VALUE;
586: elsif cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.BOM_ENABLED_FLAG' then AttRec.BOM_ENABLED_FLAG := cr.ATTRIBUTE_VALUE;
587: elsif cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.BOM_ITEM_TYPE' then AttRec.BOM_ITEM_TYPE := cr.ATTRIBUTE_VALUE;
588: elsif cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.BUILD_IN_WIP_FLAG' then AttRec.BUILD_IN_WIP_FLAG := cr.ATTRIBUTE_VALUE;
589: elsif cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.BUYER_ID' then AttRec.BUYER_ID := cr.ATTRIBUTE_VALUE;
590: elsif cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.CARRYING_COST' then AttRec.CARRYING_COST := cr.ATTRIBUTE_VALUE;
591: elsif cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.COLLATERAL_FLAG' then AttRec.COLLATERAL_FLAG := cr.ATTRIBUTE_VALUE;
592: elsif cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.COSTING_ENABLED_FLAG' then AttRec.COSTING_ENABLED_FLAG := cr.ATTRIBUTE_VALUE;
593: elsif cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.COVERAGE_SCHEDULE_ID' then AttRec.COVERAGE_SCHEDULE_ID := cr.ATTRIBUTE_VALUE;

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

745: elsif cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.COMMS_NL_TRACKABLE_FLAG' then AttRec.COMMS_NL_TRACKABLE_FLAG := cr.ATTRIBUTE_VALUE;
746: elsif cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.ASSET_CREATION_CODE' then AttRec.ASSET_CREATION_CODE := cr.ATTRIBUTE_VALUE;
747: elsif cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.COMMS_ACTIVATION_REQD_FLAG' then AttRec.COMMS_ACTIVATION_REQD_FLAG := cr.ATTRIBUTE_VALUE;
748: elsif cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.ORDERABLE_ON_WEB_FLAG' then AttRec.ORDERABLE_ON_WEB_FLAG := cr.ATTRIBUTE_VALUE;
749: elsif cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.BACK_ORDERABLE_FLAG' then AttRec.BACK_ORDERABLE_FLAG := cr.ATTRIBUTE_VALUE;
750: elsif cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.WEB_STATUS' then AttRec.WEB_STATUS := cr.ATTRIBUTE_VALUE;
751: elsif cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.INDIVISIBLE_FLAG' then AttRec.INDIVISIBLE_FLAG := cr.ATTRIBUTE_VALUE;
752: elsif cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.DIMENSION_UOM_CODE' then AttRec.DIMENSION_UOM_CODE := cr.ATTRIBUTE_VALUE;
753: elsif cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.UNIT_LENGTH' then AttRec.UNIT_LENGTH := cr.ATTRIBUTE_VALUE;

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

752: elsif cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.DIMENSION_UOM_CODE' then AttRec.DIMENSION_UOM_CODE := cr.ATTRIBUTE_VALUE;
753: elsif cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.UNIT_LENGTH' then AttRec.UNIT_LENGTH := cr.ATTRIBUTE_VALUE;
754: elsif cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.UNIT_WIDTH' then AttRec.UNIT_WIDTH := cr.ATTRIBUTE_VALUE;
755: elsif cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.UNIT_HEIGHT' then AttRec.UNIT_HEIGHT := cr.ATTRIBUTE_VALUE;
756: elsif cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.BULK_PICKED_FLAG' then AttRec.BULK_PICKED_FLAG := cr.ATTRIBUTE_VALUE;
757: elsif cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.LOT_STATUS_ENABLED' then AttRec.LOT_STATUS_ENABLED := cr.ATTRIBUTE_VALUE;
758: elsif cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.DEFAULT_LOT_STATUS_ID' then AttRec.DEFAULT_LOT_STATUS_ID := cr.ATTRIBUTE_VALUE;
759: elsif cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.SERIAL_STATUS_ENABLED' then AttRec.SERIAL_STATUS_ENABLED := cr.ATTRIBUTE_VALUE;
760: elsif cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.DEFAULT_SERIAL_STATUS_ID' then AttRec.DEFAULT_SERIAL_STATUS_ID := cr.ATTRIBUTE_VALUE;

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

843: elsif cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.MATURITY_DAYS' then AttRec.MATURITY_DAYS := cr.ATTRIBUTE_VALUE;
844: elsif cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.HOLD_DAYS' then AttRec.HOLD_DAYS := cr.ATTRIBUTE_VALUE;
845: -- End Bug 3713912
846: --Org specific attributes
847: elsif cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.BASE_ITEM_ID' then AttRec.BASE_ITEM_ID := cr.ATTRIBUTE_VALUE;
848: elsif cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.BASE_WARRANTY_SERVICE_ID' then AttRec.BASE_WARRANTY_SERVICE_ID := cr.ATTRIBUTE_VALUE;
849: elsif cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.COST_OF_SALES_ACCOUNT' then AttRec.COST_OF_SALES_ACCOUNT := cr.ATTRIBUTE_VALUE;
850: elsif cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.ENCUMBRANCE_ACCOUNT' then AttRec.ENCUMBRANCE_ACCOUNT := cr.ATTRIBUTE_VALUE;
851: elsif cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.EXPENSE_ACCOUNT' then AttRec.EXPENSE_ACCOUNT := cr.ATTRIBUTE_VALUE;

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

844: elsif cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.HOLD_DAYS' then AttRec.HOLD_DAYS := cr.ATTRIBUTE_VALUE;
845: -- End Bug 3713912
846: --Org specific attributes
847: elsif cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.BASE_ITEM_ID' then AttRec.BASE_ITEM_ID := cr.ATTRIBUTE_VALUE;
848: elsif cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.BASE_WARRANTY_SERVICE_ID' then AttRec.BASE_WARRANTY_SERVICE_ID := cr.ATTRIBUTE_VALUE;
849: elsif cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.COST_OF_SALES_ACCOUNT' then AttRec.COST_OF_SALES_ACCOUNT := cr.ATTRIBUTE_VALUE;
850: elsif cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.ENCUMBRANCE_ACCOUNT' then AttRec.ENCUMBRANCE_ACCOUNT := cr.ATTRIBUTE_VALUE;
851: elsif cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.EXPENSE_ACCOUNT' then AttRec.EXPENSE_ACCOUNT := cr.ATTRIBUTE_VALUE;
852: elsif cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.PLANNER_CODE' then AttRec.PLANNER_CODE := cr.ATTRIBUTE_VALUE;