egp_system_Items_tl: Table structure, indexes, salients points and how to query the table.
Category: Uncategorized
inv_material_txns Sample Queries
Sample queries related to inv_material_txns table.
Column Details of inv_org_parameters Table
COLUMN NAMEDATA TYPEDATA LENGTHNULLABLE LAST_UPDATE_DATETIMESTAMP(6)11N FILL_KILL_TRANSFER_ORDERS_FLAGVARCHAR24Y TRACK_COUNTRY_OF_ORIGIN_FLAGVARCHAR24Y ORGANIZATION_IDNUMBER22N LAST_UPDATED_BYVARCHAR2256N CREATION_DATETIMESTAMP(6)11N CREATED_BYVARCHAR2256N LAST_UPDATE_LOGINVARCHAR2128Y ORGANIZATION_CODEVARCHAR272Y MASTER_ORGANIZATION_IDNUMBER22Y BUSINESS_UNIT_IDNUMBER22Y LEGAL_ENTITY_IDNUMBER22Y SCHEDULE_IDNUMBER22Y DEFAULT_PICKING_RULE_IDNUMBER22Y DEFAULT_LOCATOR_ORDER_VALUENUMBER22Y DEFAULT_SUBINV_ORDER_VALUENUMBER22Y NEGATIVE_INV_RECEIPT_CODENUMBER22Y STOCK_LOCATOR_CONTROL_CODEVARCHAR2120Y SOURCE_ORGANIZATION_IDNUMBER22Y SOURCE_SUBINVENTORYVARCHAR240Y SOURCE_TYPEVARCHAR2120Y SERIAL_NUMBER_TYPEVARCHAR2120Y AUTO_SERIAL_ALPHA_PREFIXVARCHAR2320Y START_AUTO_SERIAL_NUMBERVARCHAR2320Y AUTO_LOT_ALPHA_PREFIXVARCHAR2320Y LOT_NUMBER_UNIQUENESSVARCHAR2120Y LOT_NUMBER_GENERATIONVARCHAR2120Y LOT_NUMBER_ZERO_PADDINGVARCHAR2120Y LOT_NUMBER_LENGTHNUMBER22Y STARTING_REVISIONVARCHAR272Y LPN_PREFIXVARCHAR240Y LPN_SUFFIXVARCHAR240Y LPN_STARTING_NUMBERNUMBER22Y TOTAL_LPN_LENGTHNUMBER22Y UCC_128_SUFFIX_FLAGVARCHAR24Y ATTRIBUTE_CATEGORYVARCHAR2120Y ATTRIBUTE1VARCHAR2600Y ATTRIBUTE2VARCHAR2600Y ATTRIBUTE3VARCHAR2600Y ATTRIBUTE4VARCHAR2600Y ATTRIBUTE5VARCHAR2600Y ATTRIBUTE6VARCHAR2600Y ATTRIBUTE7VARCHAR2600Y ATTRIBUTE8VARCHAR2600Y ATTRIBUTE9VARCHAR2600Y ATTRIBUTE10VARCHAR2600Y ATTRIBUTE11VARCHAR2600Y ATTRIBUTE12VARCHAR2600Y ATTRIBUTE13VARCHAR2600Y ATTRIBUTE14VARCHAR2600Y ATTRIBUTE15VARCHAR2600Y SERIAL_NUMBER_GENERATIONVARCHAR2120Y GLOBAL_ATTRIBUTE_CATEGORYVARCHAR2120Y GLOBAL_ATTRIBUTE1VARCHAR2600Y GLOBAL_ATTRIBUTE2VARCHAR2600Y GLOBAL_ATTRIBUTE3VARCHAR2600Y GLOBAL_ATTRIBUTE4VARCHAR2600Y GLOBAL_ATTRIBUTE5VARCHAR2600Y GLOBAL_ATTRIBUTE6VARCHAR2600Y GLOBAL_ATTRIBUTE7VARCHAR2600Y GLOBAL_ATTRIBUTE8VARCHAR2600Y GLOBAL_ATTRIBUTE9VARCHAR2600Y GLOBAL_ATTRIBUTE10VARCHAR2600Y GLOBAL_ATTRIBUTE11VARCHAR2600Y GLOBAL_ATTRIBUTE12VARCHAR2600Y GLOBAL_ATTRIBUTE13VARCHAR2600Y GLOBAL_ATTRIBUTE14VARCHAR2600Y GLOBAL_ATTRIBUTE15VARCHAR2600Y GLOBAL_ATTRIBUTE16VARCHAR2600Y GLOBAL_ATTRIBUTE17VARCHAR2600Y GLOBAL_ATTRIBUTE18VARCHAR2600Y GLOBAL_ATTRIBUTE19VARCHAR2600Y GLOBAL_ATTRIBUTE20VARCHAR2600Y MO_PICK_CONFIRM_REQUIREDNUMBER22Y OVPK_TRANSFER_ORDERS_ENABLEDVARCHAR24Y ALLOCATE_SERIAL_FLAGVARCHAR24Y DISTRIBUTED_ORGANIZATION_FLAGVARCHAR24Y ALLOW_DIFFERENT_STATUSNUMBER22Y CHILD_LOT_ALPHA_PREFIXVARCHAR2320Y CHILD_LOT_NUMBER_LENGTHNUMBER22Y CHILD_LOT_VALIDATION_FLAGVARCHAR24Y CHILD_LOT_ZERO_PADDING_FLAGVARCHAR24Y COPY_LOT_ATTRIBUTE_FLAGVARCHAR24Y CREATE_LOT_UOM_CONVERSIONNUMBER22Y PARENT_CHILD_GENERATION_FLAGVARCHAR24Y AUTO_DEL_ALLOC_FLAGVARCHAR24Y ENFORCE_LOCATOR_ALIS_UNQ_FLAGVARCHAR24Y PRE_FILL_PICKED_QTYVARCHAR24Y CAPTURE_PICKING_EXCEPTIONVARCHAR24Y INVENTORY_FLAGVARCHAR24N OBJECT_VERSION_NUMBERNUMBER22N QA_SKIPPING_INSP_FLAGVARCHAR24Y WCS_ENABLEDVARCHAR24Y EAM_ENABLED_FLAGVARCHAR24Y WMS_ENABLED_FLAGVARCHAR24Y MAINT_ORGANIZATION_IDNUMBER22Y TRADING_PARTNER_ORG_FLAGVARCHAR24Y PREGEN_PUTAWAY_TASKS_FLAGNUMBER22Y REGENERATION_INTERVALNUMBER22Y TIMEZONE_IDNUMBER22Y DEFAULT_WMS_PICKING_RULE_IDNUMBER22Y DEFAULT_PUT_AWAY_RULE_IDNUMBER22Y DEFAULT_CARTON_RULE_IDNUMBER22Y DEFAULT_CYC_COUNT_HEADER_IDNUMBER22Y CROSSDOCK_FLAGNUMBER22Y CARTONIZATION_FLAGNUMBER22Y PROJECT_REFERENCE_ENABLEDNUMBER22Y PROJECT_CONTROL_LEVELNUMBER22Y PM_COST_COLLECTION_ENABLEDNUMBER22Y JOB_DEFINITION_NAMEVARCHAR2400Y JOB_DEFINITION_PACKAGEVARCHAR23600Y REQUEST_IDNUMBER22Y PICK_QTY_DEFAULT_REASON_IDNUMBER22Y FIFO_ORIG_RCPT_DATE_FLAGVARCHAR24Y ALLOW_NEG_ONHAND_CC_TXNSVARCHAR24Y PURCHASING_BY_REVISIONVARCHAR24Y ROUND_REORDER_QTY_FLAGVARCHAR24Y REPLNSH_MOVE_ORDER_GROUPINGNUMBER22Y FILL_KILL_MOVE_ORDER_FLAGVARCHAR24Y PICK_SLIP_BATCH_SIZENUMBER22Y STANDARD_PACK_ENABLEDNUMBER22Y AUTO_BREAKDOWN_ENABLEDVARCHAR24Y ATTRIBUTE_NUMBER1NUMBER22Y ATTRIBUTE_NUMBER2NUMBER22Y ATTRIBUTE_NUMBER3NUMBER22Y ATTRIBUTE_NUMBER4NUMBER22Y ATTRIBUTE_NUMBER5NUMBER22Y ATTRIBUTE_NUMBER6NUMBER22Y ATTRIBUTE_NUMBER7NUMBER22Y ATTRIBUTE_NUMBER8NUMBER22Y ATTRIBUTE_NUMBER9NUMBER22Y ATTRIBUTE_NUMBER10NUMBER22Y ATTRIBUTE_DATE1DATE7Y ATTRIBUTE_DATE2DATE7Y ATTRIBUTE_DATE3DATE7Y ATTRIBUTE_DATE4DATE7Y ATTRIBUTE_DATE5DATE7Y ATTRIBUTE_TIMESTAMP1TIMESTAMP(6)11Y ATTRIBUTE_TIMESTAMP2TIMESTAMP(6)11Y ATTRIBUTE_TIMESTAMP3TIMESTAMP(6)11Y ATTRIBUTE_TIMESTAMP4TIMESTAMP(6)11Y ATTRIBUTE_TIMESTAMP5TIMESTAMP(6)11Y PROFIT_CENTER_BU_IDNUMBER22Y MANUAL_RECEIPT_EXP_AT_DESTVARCHAR24Y MFG_PLANT_FLAGVARCHAR24Y CONTRACT_MFG_FLAGVARCHAR24Y SUPPLIER_IDNUMBER22Y SUPPLIER_SITE_IDNUMBER22Y TIMEZONE_CODEVARCHAR2200Y INTEGRATED_SYSTEM_CODEVARCHAR2100Y ITEM_GROUPING_CODEVARCHAR280Y ITEM_DEFINITION_ORG_IDNUMBER22Y GROUPING_JOB_STATUSVARCHAR280Y GROUPING_JOB_IDNUMBER22Y INTERNAL_CUSTOMER_FLAGVARCHAR24Y CUSTOMER_ACCOUNT_NUMBERVARCHAR2120Y PARTY_IDNUMBER22Y USE_CUR_ITEM_COST_FLAGVARCHAR24Y