VIEW: INL.INL_SHIP_LINES_INT#

Source

View Text - Preformatted

select SHIP_HEADER_INT_ID SHIP_HEADER_INT_ID, SHIP_LINE_INT_ID SHIP_LINE_INT_ID, GROUP_ID GROUP_ID, PROCESSING_STATUS_CODE PROCESSING_STATUS_CODE, VALIDATION_FLAG VALIDATION_FLAG, SHIP_LINE_GROUP_REFERENCE SHIP_LINE_GROUP_REFERENCE, PARTY_ID PARTY_ID, PARTY_NUMBER PARTY_NUMBER, PARTY_SITE_ID PARTY_SITE_ID, PARTY_SITE_NUMBER PARTY_SITE_NUMBER, SOURCE_ORGANIZATION_ID SOURCE_ORGANIZATION_ID, SOURCE_ORGANIZATION_CODE SOURCE_ORGANIZATION_CODE, SHIP_LINE_NUM SHIP_LINE_NUM, SHIP_LINE_TYPE_ID SHIP_LINE_TYPE_ID, SHIP_LINE_TYPE_CODE SHIP_LINE_TYPE_CODE, SHIP_LINE_SRC_TYPE_CODE SHIP_LINE_SRC_TYPE_CODE, SHIP_LINE_SOURCE_ID SHIP_LINE_SOURCE_ID, CURRENCY_CODE CURRENCY_CODE, CURRENCY_CONVERSION_TYPE CURRENCY_CONVERSION_TYPE, CURRENCY_CONVERSION_DATE CURRENCY_CONVERSION_DATE, CURRENCY_CONVERSION_RATE CURRENCY_CONVERSION_RATE, INVENTORY_ITEM_ID INVENTORY_ITEM_ID, TXN_QTY TXN_QTY, TXN_UOM_CODE TXN_UOM_CODE, TXN_UNIT_PRICE TXN_UNIT_PRICE, PRIMARY_QTY PRIMARY_QTY, PRIMARY_UOM_CODE PRIMARY_UOM_CODE, PRIMARY_UNIT_PRICE PRIMARY_UNIT_PRICE, SECONDARY_QTY SECONDARY_QTY, SECONDARY_UOM_CODE SECONDARY_UOM_CODE, SECONDARY_UNIT_PRICE SECONDARY_UNIT_PRICE, LANDED_COST_FLAG LANDED_COST_FLAG, ALLOCATION_ENABLED_FLAG ALLOCATION_ENABLED_FLAG, TRX_BUSINESS_CATEGORY TRX_BUSINESS_CATEGORY, INTENDED_USE INTENDED_USE, PRODUCT_FISCAL_CLASS PRODUCT_FISCAL_CLASS, PRODUCT_CATEGORY PRODUCT_CATEGORY, PRODUCT_TYPE PRODUCT_TYPE, USER_DEF_FISCAL_CLASS USER_DEF_FISCAL_CLASS, TAX_CLASSIFICATION_CODE TAX_CLASSIFICATION_CODE, ASSESSABLE_VALUE ASSESSABLE_VALUE, SHIP_FROM_PARTY_ID SHIP_FROM_PARTY_ID, SHIP_FROM_PARTY_NUMBER SHIP_FROM_PARTY_NUMBER, SHIP_FROM_PARTY_SITE_ID SHIP_FROM_PARTY_SITE_ID, SHIP_FROM_PARTY_SITE_NUMBER SHIP_FROM_PARTY_SITE_NUMBER, SHIP_TO_ORGANIZATION_ID SHIP_TO_ORGANIZATION_ID, SHIP_TO_ORGANIZATION_CODE SHIP_TO_ORGANIZATION_CODE, SHIP_TO_LOCATION_ID SHIP_TO_LOCATION_ID, SHIP_TO_LOCATION_CODE SHIP_TO_LOCATION_CODE, BILL_FROM_PARTY_ID BILL_FROM_PARTY_ID, BILL_FROM_PARTY_NUMBER BILL_FROM_PARTY_NUMBER, BILL_FROM_PARTY_SITE_ID BILL_FROM_PARTY_SITE_ID, BILL_FROM_PARTY_SITE_NUMBER BILL_FROM_PARTY_SITE_NUMBER, BILL_TO_ORGANIZATION_ID BILL_TO_ORGANIZATION_ID, BILL_TO_ORGANIZATION_CODE BILL_TO_ORGANIZATION_CODE, BILL_TO_LOCATION_ID BILL_TO_LOCATION_ID, BILL_TO_LOCATION_CODE BILL_TO_LOCATION_CODE, POA_PARTY_ID POA_PARTY_ID, POA_PARTY_NUMBER POA_PARTY_NUMBER, POA_PARTY_SITE_ID POA_PARTY_SITE_ID, POA_PARTY_SITE_NUMBER POA_PARTY_SITE_NUMBER, POO_ORGANIZATION_ID POO_ORGANIZATION_ID, POO_TO_ORGANIZATION_CODE POO_TO_ORGANIZATION_CODE, POO_LOCATION_ID POO_LOCATION_ID, POO_LOCATION_CODE POO_LOCATION_CODE, ORG_ID ORG_ID, SHIP_HEADER_ID SHIP_HEADER_ID, SHIP_LINE_ID SHIP_LINE_ID, INTERFACE_SOURCE_TABLE INTERFACE_SOURCE_TABLE, INTERFACE_SOURCE_LINE_ID INTERFACE_SOURCE_LINE_ID, CREATED_BY CREATED_BY, CREATION_DATE CREATION_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, REQUEST_ID REQUEST_ID, PROGRAM_ID PROGRAM_ID, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE, ATTRIBUTE_CATEGORY_LG ATTRIBUTE_CATEGORY_LG, ATTRIBUTE1_LG ATTRIBUTE1_LG, ATTRIBUTE2_LG ATTRIBUTE2_LG, ATTRIBUTE3_LG ATTRIBUTE3_LG, ATTRIBUTE4_LG ATTRIBUTE4_LG, ATTRIBUTE5_LG ATTRIBUTE5_LG, ATTRIBUTE6_LG ATTRIBUTE6_LG, ATTRIBUTE7_LG ATTRIBUTE7_LG, ATTRIBUTE8_LG ATTRIBUTE8_LG, ATTRIBUTE9_LG ATTRIBUTE9_LG, ATTRIBUTE10_LG ATTRIBUTE10_LG, ATTRIBUTE11_LG ATTRIBUTE11_LG, ATTRIBUTE12_LG ATTRIBUTE12_LG, ATTRIBUTE13_LG ATTRIBUTE13_LG, ATTRIBUTE14_LG ATTRIBUTE14_LG, ATTRIBUTE15_LG ATTRIBUTE15_LG, ATTRIBUTE_CATEGORY_SL ATTRIBUTE_CATEGORY_SL, ATTRIBUTE1_SL ATTRIBUTE1_SL, ATTRIBUTE2_SL ATTRIBUTE2_SL, ATTRIBUTE3_SL ATTRIBUTE3_SL, ATTRIBUTE4_SL ATTRIBUTE4_SL, ATTRIBUTE5_SL ATTRIBUTE5_SL, ATTRIBUTE6_SL ATTRIBUTE6_SL, ATTRIBUTE7_SL ATTRIBUTE7_SL, ATTRIBUTE8_SL ATTRIBUTE8_SL, ATTRIBUTE9_SL ATTRIBUTE9_SL, ATTRIBUTE10_SL ATTRIBUTE10_SL, ATTRIBUTE11_SL ATTRIBUTE11_SL, ATTRIBUTE12_SL ATTRIBUTE12_SL, ATTRIBUTE13_SL ATTRIBUTE13_SL, ATTRIBUTE14_SL ATTRIBUTE14_SL, ATTRIBUTE15_SL ATTRIBUTE15_SL, SHIP_LINE_GROUP_NUM SHIP_LINE_GROUP_NUM, INVENTORY_ITEM_NAME INVENTORY_ITEM_NAME, SHIP_LINE_GROUP_ID SHIP_LINE_GROUP_ID from "INL"."INL_SHIP_LINES_INT"

View Text - HTML Formatted

SELECT SHIP_HEADER_INT_ID SHIP_HEADER_INT_ID
, SHIP_LINE_INT_ID SHIP_LINE_INT_ID
, GROUP_ID GROUP_ID
, PROCESSING_STATUS_CODE PROCESSING_STATUS_CODE
, VALIDATION_FLAG VALIDATION_FLAG
, SHIP_LINE_GROUP_REFERENCE SHIP_LINE_GROUP_REFERENCE
, PARTY_ID PARTY_ID
, PARTY_NUMBER PARTY_NUMBER
, PARTY_SITE_ID PARTY_SITE_ID
, PARTY_SITE_NUMBER PARTY_SITE_NUMBER
, SOURCE_ORGANIZATION_ID SOURCE_ORGANIZATION_ID
, SOURCE_ORGANIZATION_CODE SOURCE_ORGANIZATION_CODE
, SHIP_LINE_NUM SHIP_LINE_NUM
, SHIP_LINE_TYPE_ID SHIP_LINE_TYPE_ID
, SHIP_LINE_TYPE_CODE SHIP_LINE_TYPE_CODE
, SHIP_LINE_SRC_TYPE_CODE SHIP_LINE_SRC_TYPE_CODE
, SHIP_LINE_SOURCE_ID SHIP_LINE_SOURCE_ID
, CURRENCY_CODE CURRENCY_CODE
, CURRENCY_CONVERSION_TYPE CURRENCY_CONVERSION_TYPE
, CURRENCY_CONVERSION_DATE CURRENCY_CONVERSION_DATE
, CURRENCY_CONVERSION_RATE CURRENCY_CONVERSION_RATE
, INVENTORY_ITEM_ID INVENTORY_ITEM_ID
, TXN_QTY TXN_QTY
, TXN_UOM_CODE TXN_UOM_CODE
, TXN_UNIT_PRICE TXN_UNIT_PRICE
, PRIMARY_QTY PRIMARY_QTY
, PRIMARY_UOM_CODE PRIMARY_UOM_CODE
, PRIMARY_UNIT_PRICE PRIMARY_UNIT_PRICE
, SECONDARY_QTY SECONDARY_QTY
, SECONDARY_UOM_CODE SECONDARY_UOM_CODE
, SECONDARY_UNIT_PRICE SECONDARY_UNIT_PRICE
, LANDED_COST_FLAG LANDED_COST_FLAG
, ALLOCATION_ENABLED_FLAG ALLOCATION_ENABLED_FLAG
, TRX_BUSINESS_CATEGORY TRX_BUSINESS_CATEGORY
, INTENDED_USE INTENDED_USE
, PRODUCT_FISCAL_CLASS PRODUCT_FISCAL_CLASS
, PRODUCT_CATEGORY PRODUCT_CATEGORY
, PRODUCT_TYPE PRODUCT_TYPE
, USER_DEF_FISCAL_CLASS USER_DEF_FISCAL_CLASS
, TAX_CLASSIFICATION_CODE TAX_CLASSIFICATION_CODE
, ASSESSABLE_VALUE ASSESSABLE_VALUE
, SHIP_FROM_PARTY_ID SHIP_FROM_PARTY_ID
, SHIP_FROM_PARTY_NUMBER SHIP_FROM_PARTY_NUMBER
, SHIP_FROM_PARTY_SITE_ID SHIP_FROM_PARTY_SITE_ID
, SHIP_FROM_PARTY_SITE_NUMBER SHIP_FROM_PARTY_SITE_NUMBER
, SHIP_TO_ORGANIZATION_ID SHIP_TO_ORGANIZATION_ID
, SHIP_TO_ORGANIZATION_CODE SHIP_TO_ORGANIZATION_CODE
, SHIP_TO_LOCATION_ID SHIP_TO_LOCATION_ID
, SHIP_TO_LOCATION_CODE SHIP_TO_LOCATION_CODE
, BILL_FROM_PARTY_ID BILL_FROM_PARTY_ID
, BILL_FROM_PARTY_NUMBER BILL_FROM_PARTY_NUMBER
, BILL_FROM_PARTY_SITE_ID BILL_FROM_PARTY_SITE_ID
, BILL_FROM_PARTY_SITE_NUMBER BILL_FROM_PARTY_SITE_NUMBER
, BILL_TO_ORGANIZATION_ID BILL_TO_ORGANIZATION_ID
, BILL_TO_ORGANIZATION_CODE BILL_TO_ORGANIZATION_CODE
, BILL_TO_LOCATION_ID BILL_TO_LOCATION_ID
, BILL_TO_LOCATION_CODE BILL_TO_LOCATION_CODE
, POA_PARTY_ID POA_PARTY_ID
, POA_PARTY_NUMBER POA_PARTY_NUMBER
, POA_PARTY_SITE_ID POA_PARTY_SITE_ID
, POA_PARTY_SITE_NUMBER POA_PARTY_SITE_NUMBER
, POO_ORGANIZATION_ID POO_ORGANIZATION_ID
, POO_TO_ORGANIZATION_CODE POO_TO_ORGANIZATION_CODE
, POO_LOCATION_ID POO_LOCATION_ID
, POO_LOCATION_CODE POO_LOCATION_CODE
, ORG_ID ORG_ID
, SHIP_HEADER_ID SHIP_HEADER_ID
, SHIP_LINE_ID SHIP_LINE_ID
, INTERFACE_SOURCE_TABLE INTERFACE_SOURCE_TABLE
, INTERFACE_SOURCE_LINE_ID INTERFACE_SOURCE_LINE_ID
, CREATED_BY CREATED_BY
, CREATION_DATE CREATION_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, REQUEST_ID REQUEST_ID
, PROGRAM_ID PROGRAM_ID
, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, ATTRIBUTE_CATEGORY_LG ATTRIBUTE_CATEGORY_LG
, ATTRIBUTE1_LG ATTRIBUTE1_LG
, ATTRIBUTE2_LG ATTRIBUTE2_LG
, ATTRIBUTE3_LG ATTRIBUTE3_LG
, ATTRIBUTE4_LG ATTRIBUTE4_LG
, ATTRIBUTE5_LG ATTRIBUTE5_LG
, ATTRIBUTE6_LG ATTRIBUTE6_LG
, ATTRIBUTE7_LG ATTRIBUTE7_LG
, ATTRIBUTE8_LG ATTRIBUTE8_LG
, ATTRIBUTE9_LG ATTRIBUTE9_LG
, ATTRIBUTE10_LG ATTRIBUTE10_LG
, ATTRIBUTE11_LG ATTRIBUTE11_LG
, ATTRIBUTE12_LG ATTRIBUTE12_LG
, ATTRIBUTE13_LG ATTRIBUTE13_LG
, ATTRIBUTE14_LG ATTRIBUTE14_LG
, ATTRIBUTE15_LG ATTRIBUTE15_LG
, ATTRIBUTE_CATEGORY_SL ATTRIBUTE_CATEGORY_SL
, ATTRIBUTE1_SL ATTRIBUTE1_SL
, ATTRIBUTE2_SL ATTRIBUTE2_SL
, ATTRIBUTE3_SL ATTRIBUTE3_SL
, ATTRIBUTE4_SL ATTRIBUTE4_SL
, ATTRIBUTE5_SL ATTRIBUTE5_SL
, ATTRIBUTE6_SL ATTRIBUTE6_SL
, ATTRIBUTE7_SL ATTRIBUTE7_SL
, ATTRIBUTE8_SL ATTRIBUTE8_SL
, ATTRIBUTE9_SL ATTRIBUTE9_SL
, ATTRIBUTE10_SL ATTRIBUTE10_SL
, ATTRIBUTE11_SL ATTRIBUTE11_SL
, ATTRIBUTE12_SL ATTRIBUTE12_SL
, ATTRIBUTE13_SL ATTRIBUTE13_SL
, ATTRIBUTE14_SL ATTRIBUTE14_SL
, ATTRIBUTE15_SL ATTRIBUTE15_SL
, SHIP_LINE_GROUP_NUM SHIP_LINE_GROUP_NUM
, INVENTORY_ITEM_NAME INVENTORY_ITEM_NAME
, SHIP_LINE_GROUP_ID SHIP_LINE_GROUP_ID
FROM "INL"."INL_SHIP_LINES_INT"