INV_ORG_PARAMETERS

Details

Schema: FUSION
Object owner: INV
Object type: VIEW

Columns

Name
ORGANIZATION_ID ORGANIZATION_CODE LAST_UPDATE_DATE LAST_UPDATED_BY CREATION_DATE CREATED_BY LAST_UPDATE_LOGIN MASTER_ORGANIZATION_ID BUSINESS_UNIT_ID LEGAL_ENTITY_ID SCHEDULE_ID DEFAULT_PICKING_RULE_ID DEFAULT_LOCATOR_ORDER_VALUE DEFAULT_SUBINV_ORDER_VALUE NEGATIVE_INV_RECEIPT_CODE STOCK_LOCATOR_CONTROL_CODE SOURCE_ORGANIZATION_ID SOURCE_SUBINVENTORY SOURCE_TYPE SERIAL_NUMBER_TYPE AUTO_SERIAL_ALPHA_PREFIX START_AUTO_SERIAL_NUMBER AUTO_LOT_ALPHA_PREFIX LOT_NUMBER_UNIQUENESS LOT_NUMBER_GENERATION LOT_NUMBER_ZERO_PADDING LOT_NUMBER_LENGTH STARTING_REVISION LPN_PREFIX LPN_SUFFIX LPN_STARTING_NUMBER TOTAL_LPN_LENGTH UCC_128_SUFFIX_FLAG ATTRIBUTE_CATEGORY ATTRIBUTE1 ATTRIBUTE2 ATTRIBUTE3 ATTRIBUTE4 ATTRIBUTE5 ATTRIBUTE6 ATTRIBUTE7 ATTRIBUTE8 ATTRIBUTE9 ATTRIBUTE10 ATTRIBUTE11 ATTRIBUTE12 ATTRIBUTE13 ATTRIBUTE14 ATTRIBUTE15 SERIAL_NUMBER_GENERATION GLOBAL_ATTRIBUTE_CATEGORY GLOBAL_ATTRIBUTE1 GLOBAL_ATTRIBUTE2 GLOBAL_ATTRIBUTE3 GLOBAL_ATTRIBUTE4 GLOBAL_ATTRIBUTE5 GLOBAL_ATTRIBUTE6 GLOBAL_ATTRIBUTE7 GLOBAL_ATTRIBUTE8 GLOBAL_ATTRIBUTE9 GLOBAL_ATTRIBUTE10 GLOBAL_ATTRIBUTE11 GLOBAL_ATTRIBUTE12 GLOBAL_ATTRIBUTE13 GLOBAL_ATTRIBUTE14 GLOBAL_ATTRIBUTE15 GLOBAL_ATTRIBUTE16 GLOBAL_ATTRIBUTE17 GLOBAL_ATTRIBUTE18 GLOBAL_ATTRIBUTE19 GLOBAL_ATTRIBUTE20 MO_PICK_CONFIRM_REQUIRED OVPK_TRANSFER_ORDERS_ENABLED ALLOCATE_SERIAL_FLAG DISTRIBUTED_ORGANIZATION_FLAG ALLOW_DIFFERENT_STATUS CHILD_LOT_ALPHA_PREFIX CHILD_LOT_NUMBER_LENGTH CHILD_LOT_VALIDATION_FLAG CHILD_LOT_ZERO_PADDING_FLAG COPY_LOT_ATTRIBUTE_FLAG CREATE_LOT_UOM_CONVERSION PARENT_CHILD_GENERATION_FLAG AUTO_DEL_ALLOC_FLAG ENFORCE_LOCATOR_ALIS_UNQ_FLAG PRE_FILL_PICKED_QTY CAPTURE_PICKING_EXCEPTION PICK_QTY_DEFAULT_REASON_ID QA_SKIPPING_INSP_FLAG WCS_ENABLED EAM_ENABLED_FLAG WMS_ENABLED_FLAG MAINT_ORGANIZATION_ID TRADING_PARTNER_ORG_FLAG PREGEN_PUTAWAY_TASKS_FLAG REGENERATION_INTERVAL TIMEZONE_ID DEFAULT_WMS_PICKING_RULE_ID DEFAULT_PUT_AWAY_RULE_ID DEFAULT_CARTON_RULE_ID DEFAULT_CYC_COUNT_HEADER_ID CROSSDOCK_FLAG CARTONIZATION_FLAG PROJECT_REFERENCE_ENABLED PROJECT_CONTROL_LEVEL PM_COST_COLLECTION_ENABLED FIFO_ORIG_RCPT_DATE_FLAG ALLOW_NEG_ONHAND_CC_TXNS PURCHASING_BY_REVISION ROUND_REORDER_QTY_FLAG REPLNSH_MOVE_ORDER_GROUPING FILL_KILL_MOVE_ORDER_FLAG PICK_SLIP_BATCH_SIZE STANDARD_PACK_ENABLED AUTO_BREAKDOWN_ENABLED JOB_DEFINITION_NAME JOB_DEFINITION_PACKAGE REQUEST_ID ATTRIBUTE_NUMBER1 ATTRIBUTE_NUMBER2 ATTRIBUTE_NUMBER3 ATTRIBUTE_NUMBER4 ATTRIBUTE_NUMBER5 ATTRIBUTE_NUMBER6 ATTRIBUTE_NUMBER7 ATTRIBUTE_NUMBER8 ATTRIBUTE_NUMBER9 ATTRIBUTE_NUMBER10 ATTRIBUTE_DATE1 ATTRIBUTE_DATE2 ATTRIBUTE_DATE3 ATTRIBUTE_DATE4 ATTRIBUTE_DATE5 ATTRIBUTE_TIMESTAMP1 ATTRIBUTE_TIMESTAMP2 ATTRIBUTE_TIMESTAMP3 ATTRIBUTE_TIMESTAMP4 ATTRIBUTE_TIMESTAMP5 PROFIT_CENTER_BU_ID MANUAL_RECEIPT_EXP_AT_DEST MFG_PLANT_FLAG CONTRACT_MFG_FLAG SUPPLIER_ID SUPPLIER_SITE_ID TIMEZONE_CODE FILL_KILL_TRANSFER_ORDERS_FLAG INTEGRATED_SYSTEM_CODE ITEM_GROUPING_CODE ITEM_DEFINITION_ORG_ID GROUPING_JOB_STATUS GROUPING_JOB_ID TRACK_COUNTRY_OF_ORIGIN_FLAG INTERNAL_CUSTOMER_FLAG CUSTOMER_ACCOUNT_NUMBER PARTY_ID USE_CUR_ITEM_COST_FLAG SPECIAL_HNDLNG_OVRPK_FLAG FA_BOOK_TYPE_CODE ALLOW_ITEM_SUBSTITUTIONS WMS_WITH_MFG_ALM FILL_KILL_SALES_ORDER_FLAG

Name

ORGANIZATION_ID

ORGANIZATION_CODE

LAST_UPDATE_DATE

LAST_UPDATED_BY

CREATION_DATE

CREATED_BY

LAST_UPDATE_LOGIN

MASTER_ORGANIZATION_ID

BUSINESS_UNIT_ID

LEGAL_ENTITY_ID

SCHEDULE_ID

DEFAULT_PICKING_RULE_ID

DEFAULT_LOCATOR_ORDER_VALUE

DEFAULT_SUBINV_ORDER_VALUE

NEGATIVE_INV_RECEIPT_CODE

STOCK_LOCATOR_CONTROL_CODE

SOURCE_ORGANIZATION_ID

SOURCE_SUBINVENTORY

SOURCE_TYPE

SERIAL_NUMBER_TYPE

AUTO_SERIAL_ALPHA_PREFIX

START_AUTO_SERIAL_NUMBER

AUTO_LOT_ALPHA_PREFIX

LOT_NUMBER_UNIQUENESS

LOT_NUMBER_GENERATION

LOT_NUMBER_ZERO_PADDING

LOT_NUMBER_LENGTH

STARTING_REVISION

LPN_PREFIX

LPN_SUFFIX

LPN_STARTING_NUMBER

TOTAL_LPN_LENGTH

UCC_128_SUFFIX_FLAG

ATTRIBUTE_CATEGORY

ATTRIBUTE1

ATTRIBUTE2

ATTRIBUTE3

ATTRIBUTE4

ATTRIBUTE5

ATTRIBUTE6

ATTRIBUTE7

ATTRIBUTE8

ATTRIBUTE9

ATTRIBUTE10

ATTRIBUTE11

ATTRIBUTE12

ATTRIBUTE13

ATTRIBUTE14

ATTRIBUTE15

SERIAL_NUMBER_GENERATION

GLOBAL_ATTRIBUTE_CATEGORY

GLOBAL_ATTRIBUTE1

GLOBAL_ATTRIBUTE2

GLOBAL_ATTRIBUTE3

GLOBAL_ATTRIBUTE4

GLOBAL_ATTRIBUTE5

GLOBAL_ATTRIBUTE6

GLOBAL_ATTRIBUTE7

GLOBAL_ATTRIBUTE8

GLOBAL_ATTRIBUTE9

GLOBAL_ATTRIBUTE10

GLOBAL_ATTRIBUTE11

GLOBAL_ATTRIBUTE12

GLOBAL_ATTRIBUTE13

GLOBAL_ATTRIBUTE14

GLOBAL_ATTRIBUTE15

GLOBAL_ATTRIBUTE16

GLOBAL_ATTRIBUTE17

GLOBAL_ATTRIBUTE18

GLOBAL_ATTRIBUTE19

GLOBAL_ATTRIBUTE20

MO_PICK_CONFIRM_REQUIRED

OVPK_TRANSFER_ORDERS_ENABLED

ALLOCATE_SERIAL_FLAG

DISTRIBUTED_ORGANIZATION_FLAG

ALLOW_DIFFERENT_STATUS

CHILD_LOT_ALPHA_PREFIX

CHILD_LOT_NUMBER_LENGTH

CHILD_LOT_VALIDATION_FLAG

CHILD_LOT_ZERO_PADDING_FLAG

COPY_LOT_ATTRIBUTE_FLAG

CREATE_LOT_UOM_CONVERSION

PARENT_CHILD_GENERATION_FLAG

AUTO_DEL_ALLOC_FLAG

ENFORCE_LOCATOR_ALIS_UNQ_FLAG

PRE_FILL_PICKED_QTY

CAPTURE_PICKING_EXCEPTION

PICK_QTY_DEFAULT_REASON_ID

QA_SKIPPING_INSP_FLAG

WCS_ENABLED

EAM_ENABLED_FLAG

WMS_ENABLED_FLAG

MAINT_ORGANIZATION_ID

TRADING_PARTNER_ORG_FLAG

PREGEN_PUTAWAY_TASKS_FLAG

REGENERATION_INTERVAL

TIMEZONE_ID

DEFAULT_WMS_PICKING_RULE_ID

DEFAULT_PUT_AWAY_RULE_ID

DEFAULT_CARTON_RULE_ID

DEFAULT_CYC_COUNT_HEADER_ID

CROSSDOCK_FLAG

CARTONIZATION_FLAG

PROJECT_REFERENCE_ENABLED

PROJECT_CONTROL_LEVEL

PM_COST_COLLECTION_ENABLED

FIFO_ORIG_RCPT_DATE_FLAG

ALLOW_NEG_ONHAND_CC_TXNS

PURCHASING_BY_REVISION

ROUND_REORDER_QTY_FLAG

REPLNSH_MOVE_ORDER_GROUPING

FILL_KILL_MOVE_ORDER_FLAG

PICK_SLIP_BATCH_SIZE

STANDARD_PACK_ENABLED

AUTO_BREAKDOWN_ENABLED

JOB_DEFINITION_NAME

JOB_DEFINITION_PACKAGE

REQUEST_ID

ATTRIBUTE_NUMBER1

ATTRIBUTE_NUMBER2

ATTRIBUTE_NUMBER3

ATTRIBUTE_NUMBER4

ATTRIBUTE_NUMBER5

ATTRIBUTE_NUMBER6

ATTRIBUTE_NUMBER7

ATTRIBUTE_NUMBER8

ATTRIBUTE_NUMBER9

ATTRIBUTE_NUMBER10

ATTRIBUTE_DATE1

ATTRIBUTE_DATE2

ATTRIBUTE_DATE3

ATTRIBUTE_DATE4

ATTRIBUTE_DATE5

ATTRIBUTE_TIMESTAMP1

ATTRIBUTE_TIMESTAMP2

ATTRIBUTE_TIMESTAMP3

ATTRIBUTE_TIMESTAMP4

ATTRIBUTE_TIMESTAMP5

PROFIT_CENTER_BU_ID

MANUAL_RECEIPT_EXP_AT_DEST

MFG_PLANT_FLAG

CONTRACT_MFG_FLAG

SUPPLIER_ID

SUPPLIER_SITE_ID

TIMEZONE_CODE

FILL_KILL_TRANSFER_ORDERS_FLAG

INTEGRATED_SYSTEM_CODE

ITEM_GROUPING_CODE

ITEM_DEFINITION_ORG_ID

GROUPING_JOB_STATUS

GROUPING_JOB_ID

TRACK_COUNTRY_OF_ORIGIN_FLAG

INTERNAL_CUSTOMER_FLAG

CUSTOMER_ACCOUNT_NUMBER

PARTY_ID

USE_CUR_ITEM_COST_FLAG

SPECIAL_HNDLNG_OVRPK_FLAG

FA_BOOK_TYPE_CODE

ALLOW_ITEM_SUBSTITUTIONS

WMS_WITH_MFG_ALM

FILL_KILL_SALES_ORDER_FLAG

Query

SQL_Statement
SELECT IOP.ORGANIZATION_ID ORGANIZATION_ID, IOP.ORGANIZATION_CODE ORGANIZATION_CODE, IOP.LAST_UPDATE_DATE LAST_UPDATE_DATE, IOP.LAST_UPDATED_BY LAST_UPDATED_BY, IOP.CREATION_DATE CREATION_DATE, IOP.CREATED_BY CREATED_BY, IOP.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, IOP.MASTER_ORGANIZATION_ID MASTER_ORGANIZATION_ID, IOP.BUSINESS_UNIT_ID BUSINESS_UNIT_ID, IOP.LEGAL_ENTITY_ID LEGAL_ENTITY_ID, IOP.SCHEDULE_ID SCHEDULE_ID, IOP.DEFAULT_PICKING_RULE_ID DEFAULT_PICKING_RULE_ID, IOP.DEFAULT_LOCATOR_ORDER_VALUE DEFAULT_LOCATOR_ORDER_VALUE, IOP.DEFAULT_SUBINV_ORDER_VALUE DEFAULT_SUBINV_ORDER_VALUE, IOP.NEGATIVE_INV_RECEIPT_CODE NEGATIVE_INV_RECEIPT_CODE, IOP.STOCK_LOCATOR_CONTROL_CODE STOCK_LOCATOR_CONTROL_CODE, IOP.SOURCE_ORGANIZATION_ID SOURCE_ORGANIZATION_ID, IOP.SOURCE_SUBINVENTORY SOURCE_SUBINVENTORY, IOP.SOURCE_TYPE SOURCE_TYPE, IOP.SERIAL_NUMBER_TYPE SERIAL_NUMBER_TYPE, IOP.AUTO_SERIAL_ALPHA_PREFIX AUTO_SERIAL_ALPHA_PREFIX, IOP.START_AUTO_SERIAL_NUMBER START_AUTO_SERIAL_NUMBER, IOP.AUTO_LOT_ALPHA_PREFIX AUTO_LOT_ALPHA_PREFIX, IOP.LOT_NUMBER_UNIQUENESS LOT_NUMBER_UNIQUENESS, IOP.LOT_NUMBER_GENERATION LOT_NUMBER_GENERATION, IOP.LOT_NUMBER_ZERO_PADDING LOT_NUMBER_ZERO_PADDING, IOP.LOT_NUMBER_LENGTH LOT_NUMBER_LENGTH, IOP.STARTING_REVISION STARTING_REVISION, IOP.LPN_PREFIX LPN_PREFIX, IOP.LPN_SUFFIX LPN_SUFFIX, IOP.LPN_STARTING_NUMBER LPN_STARTING_NUMBER, IOP.TOTAL_LPN_LENGTH TOTAL_LPN_LENGTH, IOP.UCC_128_SUFFIX_FLAG UCC_128_SUFFIX_FLAG, IOP.ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY, IOP.ATTRIBUTE1 ATTRIBUTE1, IOP.ATTRIBUTE2 ATTRIBUTE2, IOP.ATTRIBUTE3 ATTRIBUTE3, IOP.ATTRIBUTE4 ATTRIBUTE4, IOP.ATTRIBUTE5 ATTRIBUTE5, IOP.ATTRIBUTE6 ATTRIBUTE6, IOP.ATTRIBUTE7 ATTRIBUTE7, IOP.ATTRIBUTE8 ATTRIBUTE8, IOP.ATTRIBUTE9 ATTRIBUTE9, IOP.ATTRIBUTE10 ATTRIBUTE10, IOP.ATTRIBUTE11 ATTRIBUTE11, IOP.ATTRIBUTE12 ATTRIBUTE12, IOP.ATTRIBUTE13 ATTRIBUTE13, IOP.ATTRIBUTE14 ATTRIBUTE14, IOP.ATTRIBUTE15 ATTRIBUTE15, IOP.SERIAL_NUMBER_GENERATION SERIAL_NUMBER_GENERATION, IOP.GLOBAL_ATTRIBUTE_CATEGORY GLOBAL_ATTRIBUTE_CATEGORY, IOP.GLOBAL_ATTRIBUTE1 GLOBAL_ATTRIBUTE1, IOP.GLOBAL_ATTRIBUTE2 GLOBAL_ATTRIBUTE2, IOP.GLOBAL_ATTRIBUTE3 GLOBAL_ATTRIBUTE3, IOP.GLOBAL_ATTRIBUTE4 GLOBAL_ATTRIBUTE4, IOP.GLOBAL_ATTRIBUTE5 GLOBAL_ATTRIBUTE5, IOP.GLOBAL_ATTRIBUTE6 GLOBAL_ATTRIBUTE6, IOP.GLOBAL_ATTRIBUTE7 GLOBAL_ATTRIBUTE7, IOP.GLOBAL_ATTRIBUTE8 GLOBAL_ATTRIBUTE8, IOP.GLOBAL_ATTRIBUTE9 GLOBAL_ATTRIBUTE9, IOP.GLOBAL_ATTRIBUTE10 GLOBAL_ATTRIBUTE10, IOP.GLOBAL_ATTRIBUTE11 GLOBAL_ATTRIBUTE11, IOP.GLOBAL_ATTRIBUTE12 GLOBAL_ATTRIBUTE12, IOP.GLOBAL_ATTRIBUTE13 GLOBAL_ATTRIBUTE13, IOP.GLOBAL_ATTRIBUTE14 GLOBAL_ATTRIBUTE14, IOP.GLOBAL_ATTRIBUTE15 GLOBAL_ATTRIBUTE15, IOP.GLOBAL_ATTRIBUTE16 GLOBAL_ATTRIBUTE16, IOP.GLOBAL_ATTRIBUTE17 GLOBAL_ATTRIBUTE17, IOP.GLOBAL_ATTRIBUTE18 GLOBAL_ATTRIBUTE18, IOP.GLOBAL_ATTRIBUTE19 GLOBAL_ATTRIBUTE19, IOP.GLOBAL_ATTRIBUTE20 GLOBAL_ATTRIBUTE20, IOP.MO_PICK_CONFIRM_REQUIRED MO_PICK_CONFIRM_REQUIRED, IOP.OVPK_TRANSFER_ORDERS_ENABLED OVPK_TRANSFER_ORDERS_ENABLED, IOP.ALLOCATE_SERIAL_FLAG ALLOCATE_SERIAL_FLAG, IOP.DISTRIBUTED_ORGANIZATION_FLAG DISTRIBUTED_ORGANIZATION_FLAG, IOP.ALLOW_DIFFERENT_STATUS ALLOW_DIFFERENT_STATUS, IOP.CHILD_LOT_ALPHA_PREFIX CHILD_LOT_ALPHA_PREFIX, IOP.CHILD_LOT_NUMBER_LENGTH CHILD_LOT_NUMBER_LENGTH, IOP.CHILD_LOT_VALIDATION_FLAG CHILD_LOT_VALIDATION_FLAG, IOP.CHILD_LOT_ZERO_PADDING_FLAG CHILD_LOT_ZERO_PADDING_FLAG, IOP.COPY_LOT_ATTRIBUTE_FLAG COPY_LOT_ATTRIBUTE_FLAG, IOP.CREATE_LOT_UOM_CONVERSION CREATE_LOT_UOM_CONVERSION, IOP.PARENT_CHILD_GENERATION_FLAG PARENT_CHILD_GENERATION_FLAG, IOP.AUTO_DEL_ALLOC_FLAG AUTO_DEL_ALLOC_FLAG, IOP.ENFORCE_LOCATOR_ALIS_UNQ_FLAG ENFORCE_LOCATOR_ALIS_UNQ_FLAG, IOP.PRE_FILL_PICKED_QTY PRE_FILL_PICKED_QTY, IOP.CAPTURE_PICKING_EXCEPTION CAPTURE_PICKING_EXCEPTION, IOP.PICK_QTY_DEFAULT_REASON_ID PICK_QTY_DEFAULT_REASON_ID, IOP.QA_SKIPPING_INSP_FLAG QA_SKIPPING_INSP_FLAG, IOP.WCS_ENABLED WCS_ENABLED, IOP.EAM_ENABLED_FLAG EAM_ENABLED_FLAG, IOP.WMS_ENABLED_FLAG WMS_ENABLED_FLAG, IOP.MAINT_ORGANIZATION_ID MAINT_ORGANIZATION_ID, IOP.TRADING_PARTNER_ORG_FLAG TRADING_PARTNER_ORG_FLAG, IOP.PREGEN_PUTAWAY_TASKS_FLAG PREGEN_PUTAWAY_TASKS_FLAG, IOP.REGENERATION_INTERVAL REGENERATION_INTERVAL, IOP.TIMEZONE_ID TIMEZONE_ID, IOP.DEFAULT_WMS_PICKING_RULE_ID DEFAULT_WMS_PICKING_RULE_ID, IOP.DEFAULT_PUT_AWAY_RULE_ID DEFAULT_PUT_AWAY_RULE_ID, IOP.DEFAULT_CARTON_RULE_ID DEFAULT_CARTON_RULE_ID, IOP.DEFAULT_CYC_COUNT_HEADER_ID DEFAULT_CYC_COUNT_HEADER_ID, IOP.CROSSDOCK_FLAG CROSSDOCK_FLAG, IOP.CARTONIZATION_FLAG CARTONIZATION_FLAG, IOP.PROJECT_REFERENCE_ENABLED PROJECT_REFERENCE_ENABLED, IOP.PROJECT_CONTROL_LEVEL PROJECT_CONTROL_LEVEL, IOP.PM_COST_COLLECTION_ENABLED PM_COST_COLLECTION_ENABLED, IOP.FIFO_ORIG_RCPT_DATE_FLAG FIFO_ORIG_RCPT_DATE_FLAG, IOP.ALLOW_NEG_ONHAND_CC_TXNS ALLOW_NEG_ONHAND_CC_TXNS, IOP.PURCHASING_BY_REVISION PURCHASING_BY_REVISION, IOP.ROUND_REORDER_QTY_FLAG ROUND_REORDER_QTY_FLAG, IOP.REPLNSH_MOVE_ORDER_GROUPING REPLNSH_MOVE_ORDER_GROUPING, IOP.FILL_KILL_MOVE_ORDER_FLAG FILL_KILL_MOVE_ORDER_FLAG, IOP.PICK_SLIP_BATCH_SIZE PICK_SLIP_BATCH_SIZE, IOP.STANDARD_PACK_ENABLED STANDARD_PACK_ENABLED, IOP.AUTO_BREAKDOWN_ENABLED, IOP.JOB_DEFINITION_NAME JOB_DEFINITION_NAME, IOP.JOB_DEFINITION_PACKAGE JOB_DEFINITION_PACKAGE, IOP.REQUEST_ID REQUEST_ID, IOP.ATTRIBUTE_NUMBER1 ATTRIBUTE_NUMBER1, IOP.ATTRIBUTE_NUMBER2 ATTRIBUTE_NUMBER2, IOP.ATTRIBUTE_NUMBER3 ATTRIBUTE_NUMBER3, IOP.ATTRIBUTE_NUMBER4 ATTRIBUTE_NUMBER4, IOP.ATTRIBUTE_NUMBER5 ATTRIBUTE_NUMBER5, IOP.ATTRIBUTE_NUMBER6 ATTRIBUTE_NUMBER6, IOP.ATTRIBUTE_NUMBER7 ATTRIBUTE_NUMBER7, IOP.ATTRIBUTE_NUMBER8 ATTRIBUTE_NUMBER8, IOP.ATTRIBUTE_NUMBER9 ATTRIBUTE_NUMBER9, IOP.ATTRIBUTE_NUMBER10 ATTRIBUTE_NUMBER10, IOP.ATTRIBUTE_DATE1 ATTRIBUTE_DATE1, IOP.ATTRIBUTE_DATE2 ATTRIBUTE_DATE2, IOP.ATTRIBUTE_DATE3 ATTRIBUTE_DATE3, IOP.ATTRIBUTE_DATE4 ATTRIBUTE_DATE4, IOP.ATTRIBUTE_DATE5 ATTRIBUTE_DATE5, IOP.ATTRIBUTE_TIMESTAMP1 ATTRIBUTE_TIMESTAMP1, IOP.ATTRIBUTE_TIMESTAMP2 ATTRIBUTE_TIMESTAMP2, IOP.ATTRIBUTE_TIMESTAMP3 ATTRIBUTE_TIMESTAMP3, IOP.ATTRIBUTE_TIMESTAMP4 ATTRIBUTE_TIMESTAMP4, IOP.ATTRIBUTE_TIMESTAMP5 ATTRIBUTE_TIMESTAMP5, IOP.PROFIT_CENTER_BU_ID, IOP.MANUAL_RECEIPT_EXP_AT_DEST, IOP.MFG_PLANT_FLAG, IOP.CONTRACT_MFG_FLAG, IOP.SUPPLIER_ID, IOP.SUPPLIER_SITE_ID, IOP.TIMEZONE_CODE, IOP.FILL_KILL_TRANSFER_ORDERS_FLAG, IOP.INTEGRATED_SYSTEM_CODE, IOP.ITEM_GROUPING_CODE, IOP.ITEM_DEFINITION_ORG_ID, IOP.GROUPING_JOB_STATUS, IOP.GROUPING_JOB_ID, IOP.TRACK_COUNTRY_OF_ORIGIN_FLAG, IOP.INTERNAL_CUSTOMER_FLAG, IOP.CUSTOMER_ACCOUNT_NUMBER, IOP.PARTY_ID, IOP.USE_CUR_ITEM_COST_FLAG, IOP.SPECIAL_HNDLNG_OVRPK_FLAG, IOP.FA_BOOK_TYPE_CODE, IOP.ALLOW_ITEM_SUBSTITUTIONS, IOP.WMS_WITH_MFG_ALM, IOP.FILL_KILL_SALES_ORDER_FLAG FROM INV_ORG_PARAMETERS IOP WHERE IOP.INVENTORY_FLAG = 'Y'

SQL_Statement

SELECT

IOP.ORGANIZATION_ID ORGANIZATION_ID,

IOP.ORGANIZATION_CODE ORGANIZATION_CODE,

IOP.LAST_UPDATE_DATE LAST_UPDATE_DATE,

IOP.LAST_UPDATED_BY LAST_UPDATED_BY,

IOP.CREATION_DATE CREATION_DATE,

IOP.CREATED_BY CREATED_BY,

IOP.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN,

IOP.MASTER_ORGANIZATION_ID MASTER_ORGANIZATION_ID,

IOP.BUSINESS_UNIT_ID BUSINESS_UNIT_ID,

IOP.LEGAL_ENTITY_ID LEGAL_ENTITY_ID,

IOP.SCHEDULE_ID SCHEDULE_ID,

IOP.DEFAULT_PICKING_RULE_ID DEFAULT_PICKING_RULE_ID,

IOP.DEFAULT_LOCATOR_ORDER_VALUE DEFAULT_LOCATOR_ORDER_VALUE,

IOP.DEFAULT_SUBINV_ORDER_VALUE DEFAULT_SUBINV_ORDER_VALUE,

IOP.NEGATIVE_INV_RECEIPT_CODE NEGATIVE_INV_RECEIPT_CODE,

IOP.STOCK_LOCATOR_CONTROL_CODE STOCK_LOCATOR_CONTROL_CODE,

IOP.SOURCE_ORGANIZATION_ID SOURCE_ORGANIZATION_ID,

IOP.SOURCE_SUBINVENTORY SOURCE_SUBINVENTORY,

IOP.SOURCE_TYPE SOURCE_TYPE,

IOP.SERIAL_NUMBER_TYPE SERIAL_NUMBER_TYPE,

IOP.AUTO_SERIAL_ALPHA_PREFIX AUTO_SERIAL_ALPHA_PREFIX,

IOP.START_AUTO_SERIAL_NUMBER START_AUTO_SERIAL_NUMBER,

IOP.AUTO_LOT_ALPHA_PREFIX AUTO_LOT_ALPHA_PREFIX,

IOP.LOT_NUMBER_UNIQUENESS LOT_NUMBER_UNIQUENESS,

IOP.LOT_NUMBER_GENERATION LOT_NUMBER_GENERATION,

IOP.LOT_NUMBER_ZERO_PADDING LOT_NUMBER_ZERO_PADDING,

IOP.LOT_NUMBER_LENGTH LOT_NUMBER_LENGTH,

IOP.STARTING_REVISION STARTING_REVISION,

IOP.LPN_PREFIX LPN_PREFIX,

IOP.LPN_SUFFIX LPN_SUFFIX,

IOP.LPN_STARTING_NUMBER LPN_STARTING_NUMBER,

IOP.TOTAL_LPN_LENGTH TOTAL_LPN_LENGTH,

IOP.UCC_128_SUFFIX_FLAG UCC_128_SUFFIX_FLAG,

IOP.ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY,

IOP.ATTRIBUTE1 ATTRIBUTE1,

IOP.ATTRIBUTE2 ATTRIBUTE2,

IOP.ATTRIBUTE3 ATTRIBUTE3,

IOP.ATTRIBUTE4 ATTRIBUTE4,

IOP.ATTRIBUTE5 ATTRIBUTE5,

IOP.ATTRIBUTE6 ATTRIBUTE6,

IOP.ATTRIBUTE7 ATTRIBUTE7,

IOP.ATTRIBUTE8 ATTRIBUTE8,

IOP.ATTRIBUTE9 ATTRIBUTE9,

IOP.ATTRIBUTE10 ATTRIBUTE10,

IOP.ATTRIBUTE11 ATTRIBUTE11,

IOP.ATTRIBUTE12 ATTRIBUTE12,

IOP.ATTRIBUTE13 ATTRIBUTE13,

IOP.ATTRIBUTE14 ATTRIBUTE14,

IOP.ATTRIBUTE15 ATTRIBUTE15,

IOP.SERIAL_NUMBER_GENERATION SERIAL_NUMBER_GENERATION,

IOP.GLOBAL_ATTRIBUTE_CATEGORY GLOBAL_ATTRIBUTE_CATEGORY,

IOP.GLOBAL_ATTRIBUTE1 GLOBAL_ATTRIBUTE1,

IOP.GLOBAL_ATTRIBUTE2 GLOBAL_ATTRIBUTE2,

IOP.GLOBAL_ATTRIBUTE3 GLOBAL_ATTRIBUTE3,

IOP.GLOBAL_ATTRIBUTE4 GLOBAL_ATTRIBUTE4,

IOP.GLOBAL_ATTRIBUTE5 GLOBAL_ATTRIBUTE5,

IOP.GLOBAL_ATTRIBUTE6 GLOBAL_ATTRIBUTE6,

IOP.GLOBAL_ATTRIBUTE7 GLOBAL_ATTRIBUTE7,

IOP.GLOBAL_ATTRIBUTE8 GLOBAL_ATTRIBUTE8,

IOP.GLOBAL_ATTRIBUTE9 GLOBAL_ATTRIBUTE9,

IOP.GLOBAL_ATTRIBUTE10 GLOBAL_ATTRIBUTE10,

IOP.GLOBAL_ATTRIBUTE11 GLOBAL_ATTRIBUTE11,

IOP.GLOBAL_ATTRIBUTE12 GLOBAL_ATTRIBUTE12,

IOP.GLOBAL_ATTRIBUTE13 GLOBAL_ATTRIBUTE13,

IOP.GLOBAL_ATTRIBUTE14 GLOBAL_ATTRIBUTE14,

IOP.GLOBAL_ATTRIBUTE15 GLOBAL_ATTRIBUTE15,

IOP.GLOBAL_ATTRIBUTE16 GLOBAL_ATTRIBUTE16,

IOP.GLOBAL_ATTRIBUTE17 GLOBAL_ATTRIBUTE17,

IOP.GLOBAL_ATTRIBUTE18 GLOBAL_ATTRIBUTE18,

IOP.GLOBAL_ATTRIBUTE19 GLOBAL_ATTRIBUTE19,

IOP.GLOBAL_ATTRIBUTE20 GLOBAL_ATTRIBUTE20,

IOP.MO_PICK_CONFIRM_REQUIRED MO_PICK_CONFIRM_REQUIRED,

IOP.OVPK_TRANSFER_ORDERS_ENABLED OVPK_TRANSFER_ORDERS_ENABLED,

IOP.ALLOCATE_SERIAL_FLAG ALLOCATE_SERIAL_FLAG,

IOP.DISTRIBUTED_ORGANIZATION_FLAG DISTRIBUTED_ORGANIZATION_FLAG,

IOP.ALLOW_DIFFERENT_STATUS ALLOW_DIFFERENT_STATUS,

IOP.CHILD_LOT_ALPHA_PREFIX CHILD_LOT_ALPHA_PREFIX,

IOP.CHILD_LOT_NUMBER_LENGTH CHILD_LOT_NUMBER_LENGTH,

IOP.CHILD_LOT_VALIDATION_FLAG CHILD_LOT_VALIDATION_FLAG,

IOP.CHILD_LOT_ZERO_PADDING_FLAG CHILD_LOT_ZERO_PADDING_FLAG,

IOP.COPY_LOT_ATTRIBUTE_FLAG COPY_LOT_ATTRIBUTE_FLAG,

IOP.CREATE_LOT_UOM_CONVERSION CREATE_LOT_UOM_CONVERSION,

IOP.PARENT_CHILD_GENERATION_FLAG PARENT_CHILD_GENERATION_FLAG,

IOP.AUTO_DEL_ALLOC_FLAG AUTO_DEL_ALLOC_FLAG,

IOP.ENFORCE_LOCATOR_ALIS_UNQ_FLAG ENFORCE_LOCATOR_ALIS_UNQ_FLAG,

IOP.PRE_FILL_PICKED_QTY PRE_FILL_PICKED_QTY,

IOP.CAPTURE_PICKING_EXCEPTION CAPTURE_PICKING_EXCEPTION,

IOP.PICK_QTY_DEFAULT_REASON_ID PICK_QTY_DEFAULT_REASON_ID,

IOP.QA_SKIPPING_INSP_FLAG QA_SKIPPING_INSP_FLAG,

IOP.WCS_ENABLED WCS_ENABLED,

IOP.EAM_ENABLED_FLAG EAM_ENABLED_FLAG,

IOP.WMS_ENABLED_FLAG WMS_ENABLED_FLAG,

IOP.MAINT_ORGANIZATION_ID MAINT_ORGANIZATION_ID,

IOP.TRADING_PARTNER_ORG_FLAG TRADING_PARTNER_ORG_FLAG,

IOP.PREGEN_PUTAWAY_TASKS_FLAG PREGEN_PUTAWAY_TASKS_FLAG,

IOP.REGENERATION_INTERVAL REGENERATION_INTERVAL,

IOP.TIMEZONE_ID TIMEZONE_ID,

IOP.DEFAULT_WMS_PICKING_RULE_ID DEFAULT_WMS_PICKING_RULE_ID,

IOP.DEFAULT_PUT_AWAY_RULE_ID DEFAULT_PUT_AWAY_RULE_ID,

IOP.DEFAULT_CARTON_RULE_ID DEFAULT_CARTON_RULE_ID,

IOP.DEFAULT_CYC_COUNT_HEADER_ID DEFAULT_CYC_COUNT_HEADER_ID,

IOP.CROSSDOCK_FLAG CROSSDOCK_FLAG,

IOP.CARTONIZATION_FLAG CARTONIZATION_FLAG,

IOP.PROJECT_REFERENCE_ENABLED PROJECT_REFERENCE_ENABLED,

IOP.PROJECT_CONTROL_LEVEL PROJECT_CONTROL_LEVEL,

IOP.PM_COST_COLLECTION_ENABLED PM_COST_COLLECTION_ENABLED,

IOP.FIFO_ORIG_RCPT_DATE_FLAG FIFO_ORIG_RCPT_DATE_FLAG,

IOP.ALLOW_NEG_ONHAND_CC_TXNS ALLOW_NEG_ONHAND_CC_TXNS,

IOP.PURCHASING_BY_REVISION PURCHASING_BY_REVISION,

IOP.ROUND_REORDER_QTY_FLAG ROUND_REORDER_QTY_FLAG,

IOP.REPLNSH_MOVE_ORDER_GROUPING REPLNSH_MOVE_ORDER_GROUPING,

IOP.FILL_KILL_MOVE_ORDER_FLAG FILL_KILL_MOVE_ORDER_FLAG,

IOP.PICK_SLIP_BATCH_SIZE PICK_SLIP_BATCH_SIZE,

IOP.STANDARD_PACK_ENABLED STANDARD_PACK_ENABLED,

IOP.AUTO_BREAKDOWN_ENABLED,

IOP.JOB_DEFINITION_NAME JOB_DEFINITION_NAME,

IOP.JOB_DEFINITION_PACKAGE JOB_DEFINITION_PACKAGE,

IOP.REQUEST_ID REQUEST_ID,

IOP.ATTRIBUTE_NUMBER1 ATTRIBUTE_NUMBER1,

IOP.ATTRIBUTE_NUMBER2 ATTRIBUTE_NUMBER2,

IOP.ATTRIBUTE_NUMBER3 ATTRIBUTE_NUMBER3,

IOP.ATTRIBUTE_NUMBER4 ATTRIBUTE_NUMBER4,

IOP.ATTRIBUTE_NUMBER5 ATTRIBUTE_NUMBER5,

IOP.ATTRIBUTE_NUMBER6 ATTRIBUTE_NUMBER6,

IOP.ATTRIBUTE_NUMBER7 ATTRIBUTE_NUMBER7,

IOP.ATTRIBUTE_NUMBER8 ATTRIBUTE_NUMBER8,

IOP.ATTRIBUTE_NUMBER9 ATTRIBUTE_NUMBER9,

IOP.ATTRIBUTE_NUMBER10 ATTRIBUTE_NUMBER10,

IOP.ATTRIBUTE_DATE1 ATTRIBUTE_DATE1,

IOP.ATTRIBUTE_DATE2 ATTRIBUTE_DATE2,

IOP.ATTRIBUTE_DATE3 ATTRIBUTE_DATE3,

IOP.ATTRIBUTE_DATE4 ATTRIBUTE_DATE4,

IOP.ATTRIBUTE_DATE5 ATTRIBUTE_DATE5,

IOP.ATTRIBUTE_TIMESTAMP1 ATTRIBUTE_TIMESTAMP1,

IOP.ATTRIBUTE_TIMESTAMP2 ATTRIBUTE_TIMESTAMP2,

IOP.ATTRIBUTE_TIMESTAMP3 ATTRIBUTE_TIMESTAMP3,

IOP.ATTRIBUTE_TIMESTAMP4 ATTRIBUTE_TIMESTAMP4,

IOP.ATTRIBUTE_TIMESTAMP5 ATTRIBUTE_TIMESTAMP5,

IOP.PROFIT_CENTER_BU_ID,

IOP.MANUAL_RECEIPT_EXP_AT_DEST,

IOP.MFG_PLANT_FLAG,

IOP.CONTRACT_MFG_FLAG,

IOP.SUPPLIER_ID,

IOP.SUPPLIER_SITE_ID,

IOP.TIMEZONE_CODE,

IOP.FILL_KILL_TRANSFER_ORDERS_FLAG,

IOP.INTEGRATED_SYSTEM_CODE,

IOP.ITEM_GROUPING_CODE,

IOP.ITEM_DEFINITION_ORG_ID,

IOP.GROUPING_JOB_STATUS,

IOP.GROUPING_JOB_ID,

IOP.TRACK_COUNTRY_OF_ORIGIN_FLAG,

IOP.INTERNAL_CUSTOMER_FLAG,

IOP.CUSTOMER_ACCOUNT_NUMBER,

IOP.PARTY_ID,

IOP.USE_CUR_ITEM_COST_FLAG,

IOP.SPECIAL_HNDLNG_OVRPK_FLAG,

IOP.FA_BOOK_TYPE_CODE,

IOP.ALLOW_ITEM_SUBSTITUTIONS,

IOP.WMS_WITH_MFG_ALM,

IOP.FILL_KILL_SALES_ORDER_FLAG

FROM

INV_ORG_PARAMETERS IOP

WHERE

IOP.INVENTORY_FLAG = 'Y'