VIEW: JA.JAI_CMN_BOE_HDRS_ALL#

Source

View Text - Preformatted

select BOE_ID BOE_ID, ORGANIZATION_ID ORGANIZATION_ID, BOE_TYPE BOE_TYPE, PORT_CODE PORT_CODE, BOL_DATE BOL_DATE, AGENT_ID AGENT_ID, VESSEL_NAME VESSEL_NAME, PORT_NAME PORT_NAME, COUNTRY_ORIGIN COUNTRY_ORIGIN, COUNTRY_CONSIGNMNT COUNTRY_CONSIGNMNT, IMPORT_SR_NUM IMPORT_SR_NUM, IMPORT_DATE IMPORT_DATE, ROTATION_NO ROTATION_NO, ROTATION_DATE ROTATION_DATE, BOE_AMOUNT BOE_AMOUNT, AMOUNT_APPLIED AMOUNT_APPLIED, VENDOR_ID VENDOR_ID, VENDOR_SITE_ID VENDOR_SITE_ID, LOCATION_ID LOCATION_ID, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, AMOUNT_WRITTEN_OFF AMOUNT_WRITTEN_OFF, CONSOLIDATED_FLAG CONSOLIDATED_FLAG, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, LEGAL_ENTITY_ID LEGAL_ENTITY_ID, INVOICE_NUM INVOICE_NUM, ATTRIBUTE1 ATTRIBUTE1, ATTRIBUTE2 ATTRIBUTE2, ATTRIBUTE3 ATTRIBUTE3, ATTRIBUTE4 ATTRIBUTE4, ATTRIBUTE5 ATTRIBUTE5, ATTRIBUTE6 ATTRIBUTE6, ATTRIBUTE7 ATTRIBUTE7, ATTRIBUTE8 ATTRIBUTE8, ATTRIBUTE9 ATTRIBUTE9, ATTRIBUTE10 ATTRIBUTE10, ATTRIBUTE11 ATTRIBUTE11, ATTRIBUTE12 ATTRIBUTE12, ATTRIBUTE13 ATTRIBUTE13, ATTRIBUTE14 ATTRIBUTE14, ATTRIBUTE15 ATTRIBUTE15, ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY, ORG_ID ORG_ID, BOE_DATE BOE_DATE, BOE_WITHOUT_REFER_FLAG BOE_WITHOUT_REFER_FLAG, CURRENCY_CODE CURRENCY_CODE, CURRENCY_RATE_DATE CURRENCY_RATE_DATE, CURRENCY_RATE_TYPE CURRENCY_RATE_TYPE, CURRENCY_RATE CURRENCY_RATE, BOL_NUMBER BOL_NUMBER, LICENSE_NUM LICENSE_NUM, NATURE_OF_TRANSACTION NATURE_OF_TRANSACTION, TERMS_OF_PAYMENT TERMS_OF_PAYMENT, GC_CLEARANCE_FLAG GC_CLEARANCE_FLAG, CUSTOMS_AUTHORITY_ID CUSTOMS_AUTHORITY_ID, CUSTOMS_AUTHORITY_SITE_ID CUSTOMS_AUTHORITY_SITE_ID, PORT_OF_SHIPMENT PORT_OF_SHIPMENT, NUMBER_OF_PACKAGE NUMBER_OF_PACKAGE, GROSS_WEIGHT GROSS_WEIGHT, IGM_NUMBER IGM_NUMBER, IGM_DATE IGM_DATE, MAWB_NUMBER MAWB_NUMBER, MAWB_DATE MAWB_DATE, HAWB_NUMBER HAWB_NUMBER, HAWB_DATE HAWB_DATE, DEPB_AMOUNT DEPB_AMOUNT, STATUS STATUS, MIGRATION_FLAG MIGRATION_FLAG, TERMS_OF_INVOICE TERMS_OF_INVOICE from "JA"."JAI_CMN_BOE_HDRS_ALL"

View Text - HTML Formatted

SELECT BOE_ID BOE_ID
, ORGANIZATION_ID ORGANIZATION_ID
, BOE_TYPE BOE_TYPE
, PORT_CODE PORT_CODE
, BOL_DATE BOL_DATE
, AGENT_ID AGENT_ID
, VESSEL_NAME VESSEL_NAME
, PORT_NAME PORT_NAME
, COUNTRY_ORIGIN COUNTRY_ORIGIN
, COUNTRY_CONSIGNMNT COUNTRY_CONSIGNMNT
, IMPORT_SR_NUM IMPORT_SR_NUM
, IMPORT_DATE IMPORT_DATE
, ROTATION_NO ROTATION_NO
, ROTATION_DATE ROTATION_DATE
, BOE_AMOUNT BOE_AMOUNT
, AMOUNT_APPLIED AMOUNT_APPLIED
, VENDOR_ID VENDOR_ID
, VENDOR_SITE_ID VENDOR_SITE_ID
, LOCATION_ID LOCATION_ID
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, AMOUNT_WRITTEN_OFF AMOUNT_WRITTEN_OFF
, CONSOLIDATED_FLAG CONSOLIDATED_FLAG
, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, LEGAL_ENTITY_ID LEGAL_ENTITY_ID
, INVOICE_NUM INVOICE_NUM
, ATTRIBUTE1 ATTRIBUTE1
, ATTRIBUTE2 ATTRIBUTE2
, ATTRIBUTE3 ATTRIBUTE3
, ATTRIBUTE4 ATTRIBUTE4
, ATTRIBUTE5 ATTRIBUTE5
, ATTRIBUTE6 ATTRIBUTE6
, ATTRIBUTE7 ATTRIBUTE7
, ATTRIBUTE8 ATTRIBUTE8
, ATTRIBUTE9 ATTRIBUTE9
, ATTRIBUTE10 ATTRIBUTE10
, ATTRIBUTE11 ATTRIBUTE11
, ATTRIBUTE12 ATTRIBUTE12
, ATTRIBUTE13 ATTRIBUTE13
, ATTRIBUTE14 ATTRIBUTE14
, ATTRIBUTE15 ATTRIBUTE15
, ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, ORG_ID ORG_ID
, BOE_DATE BOE_DATE
, BOE_WITHOUT_REFER_FLAG BOE_WITHOUT_REFER_FLAG
, CURRENCY_CODE CURRENCY_CODE
, CURRENCY_RATE_DATE CURRENCY_RATE_DATE
, CURRENCY_RATE_TYPE CURRENCY_RATE_TYPE
, CURRENCY_RATE CURRENCY_RATE
, BOL_NUMBER BOL_NUMBER
, LICENSE_NUM LICENSE_NUM
, NATURE_OF_TRANSACTION NATURE_OF_TRANSACTION
, TERMS_OF_PAYMENT TERMS_OF_PAYMENT
, GC_CLEARANCE_FLAG GC_CLEARANCE_FLAG
, CUSTOMS_AUTHORITY_ID CUSTOMS_AUTHORITY_ID
, CUSTOMS_AUTHORITY_SITE_ID CUSTOMS_AUTHORITY_SITE_ID
, PORT_OF_SHIPMENT PORT_OF_SHIPMENT
, NUMBER_OF_PACKAGE NUMBER_OF_PACKAGE
, GROSS_WEIGHT GROSS_WEIGHT
, IGM_NUMBER IGM_NUMBER
, IGM_DATE IGM_DATE
, MAWB_NUMBER MAWB_NUMBER
, MAWB_DATE MAWB_DATE
, HAWB_NUMBER HAWB_NUMBER
, HAWB_DATE HAWB_DATE
, DEPB_AMOUNT DEPB_AMOUNT
, STATUS STATUS
, MIGRATION_FLAG MIGRATION_FLAG
, TERMS_OF_INVOICE TERMS_OF_INVOICE
FROM "JA"."JAI_CMN_BOE_HDRS_ALL"