VIEW: APPS.JAI_BOE_HEADERS_V

Source

View Text - Preformatted

SELECT jbh.BOE_ID, jbh.ORG_ID, hr.name org_name, jbh.ORGANIZATION_ID, org.organization_name organization_name, jbh.LOCATION_ID, loc.LOCATION_code loc_code, loc.description loc_desc, jbh.BOE_TYPE, boe_type.meaning BOE_TYPE_MEANING, jbh.BOE_DATE, jbh.AGENT_ID, cba.agent_code agent_code, cba.agent_name agent_name, jbh.VESSEL_NAME, jbh.PORT_CODE, port_type.meaning port_type_desc, jbh.COUNTRY_ORIGIN, jbh.COUNTRY_CONSIGNMNT, jbh.IMPORT_SR_NUM, jbh.IMPORT_DATE, jbh.ROTATION_NO, jbh.ROTATION_DATE, jbh.BOE_AMOUNT, jbh.AMOUNT_APPLIED, jbh.AMOUNT_WRITTEN_OFF, jbh.VENDOR_ID, pov.segment1 VENDOR_NUMBER, pov.vendor_name VENDOR_NAME, jbh.VENDOR_SITE_ID, pvs.vendor_site_code, jbh.BOE_WITHOUT_REFER_FLAG, jbh.CURRENCY_CODE, jbh.CURRENCY_RATE_DATE, jbh.CURRENCY_RATE_TYPE, jbh.CURRENCY_RATE, jbh.TERMS_OF_INVOICE, jbh.LICENSE_NUM, jbh.BOL_NUMBER, jbh.BOL_DATE, jbh.NATURE_OF_TRANSACTION, jbh.TERMS_OF_PAYMENT, jbh.GC_CLEARANCE_FLAG, jbh.Customs_authority_id, auth.segment1 auth_num, auth.vendor_name auth_name, jbh.customs_authority_site_id, jbh.port_of_shipment, auth_site.vendor_site_code auth_site_code, jbh.NUMBER_OF_PACKAGE, jbh.GROSS_WEIGHT, jbh.IGM_Number, jbh.IGM_Date, jbh.MAWB_Number, jbh.MAWB_Date, jbh.HAWB_Number, jbh.HAWB_Date, jbh.DEPB_Amount, jbh.STATUS, jbh.CONSOLIDATED_FLAG, jbh.LEGAL_ENTITY_ID, jbh.INVOICE_NUM, jbh.ATTRIBUTE1, jbh.ATTRIBUTE2, jbh.ATTRIBUTE3, jbh.ATTRIBUTE4, jbh.ATTRIBUTE5, jbh.ATTRIBUTE6, jbh.ATTRIBUTE7, jbh.ATTRIBUTE8, jbh.ATTRIBUTE9, jbh.ATTRIBUTE10, jbh.ATTRIBUTE11, jbh.ATTRIBUTE12, jbh.ATTRIBUTE13, jbh.ATTRIBUTE14, jbh.ATTRIBUTE15, jbh.ATTRIBUTE_CATEGORY, jbh.CREATION_DATE, jbh.CREATED_BY, jbh.LAST_UPDATE_DATE, jbh.LAST_UPDATED_BY, jbh.LAST_UPDATE_LOGIN, jbh.OBJECT_VERSION_NUMBER, boe_status.meaning status_desc FROM JAI_CMN_BOE_HDRS jbh, hr_operating_units hr, org_organization_definitions org, hr_locations loc, ja_lookups boe_type, ja_lookups port_type, po_vendors pov, po_vendor_sites_all pvs, po_vendors auth, po_vendor_sites_all auth_site, JAI_CMN_BOE_AGENTS cba, ja_lookups boe_status WHERE jbh.ORG_ID = hr.organization_id AND jbh.BOE_TYPE = boe_type.lookup_code AND jbh.LOCATION_ID = loc.location_id AND jbh.ORGANIZATION_ID = org.organization_id AND jbh.VENDOR_ID = POV.vendor_id(+) AND jbh.VENDOR_SITE_ID = pvs.vendor_site_id(+) AND jbh.Customs_authority_id = auth.vendor_id AND jbh.customs_authority_site_id = auth_site.vendor_site_id AND jbh.PORT_CODE = port_type.lookup_code AND jbh.status = boe_status.lookup_code AND jbh.agent_id = cba.agent_id AND boe_type.lookup_type = 'JAI_BOE_TYPE' AND port_type.lookup_type = 'JAI_PORT_CODE' AND boe_status.lookup_type = 'JAI_BOE_INVOICE_STATUS'

View Text - HTML Formatted

SELECT JBH.BOE_ID
, JBH.ORG_ID
, HR.NAME ORG_NAME
, JBH.ORGANIZATION_ID
, ORG.ORGANIZATION_NAME ORGANIZATION_NAME
, JBH.LOCATION_ID
, LOC.LOCATION_CODE LOC_CODE
, LOC.DESCRIPTION LOC_DESC
, JBH.BOE_TYPE
, BOE_TYPE.MEANING BOE_TYPE_MEANING
, JBH.BOE_DATE
, JBH.AGENT_ID
, CBA.AGENT_CODE AGENT_CODE
, CBA.AGENT_NAME AGENT_NAME
, JBH.VESSEL_NAME
, JBH.PORT_CODE
, PORT_TYPE.MEANING PORT_TYPE_DESC
, JBH.COUNTRY_ORIGIN
, JBH.COUNTRY_CONSIGNMNT
, JBH.IMPORT_SR_NUM
, JBH.IMPORT_DATE
, JBH.ROTATION_NO
, JBH.ROTATION_DATE
, JBH.BOE_AMOUNT
, JBH.AMOUNT_APPLIED
, JBH.AMOUNT_WRITTEN_OFF
, JBH.VENDOR_ID
, POV.SEGMENT1 VENDOR_NUMBER
, POV.VENDOR_NAME VENDOR_NAME
, JBH.VENDOR_SITE_ID
, PVS.VENDOR_SITE_CODE
, JBH.BOE_WITHOUT_REFER_FLAG
, JBH.CURRENCY_CODE
, JBH.CURRENCY_RATE_DATE
, JBH.CURRENCY_RATE_TYPE
, JBH.CURRENCY_RATE
, JBH.TERMS_OF_INVOICE
, JBH.LICENSE_NUM
, JBH.BOL_NUMBER
, JBH.BOL_DATE
, JBH.NATURE_OF_TRANSACTION
, JBH.TERMS_OF_PAYMENT
, JBH.GC_CLEARANCE_FLAG
, JBH.CUSTOMS_AUTHORITY_ID
, AUTH.SEGMENT1 AUTH_NUM
, AUTH.VENDOR_NAME AUTH_NAME
, JBH.CUSTOMS_AUTHORITY_SITE_ID
, JBH.PORT_OF_SHIPMENT
, AUTH_SITE.VENDOR_SITE_CODE AUTH_SITE_CODE
, JBH.NUMBER_OF_PACKAGE
, JBH.GROSS_WEIGHT
, JBH.IGM_NUMBER
, JBH.IGM_DATE
, JBH.MAWB_NUMBER
, JBH.MAWB_DATE
, JBH.HAWB_NUMBER
, JBH.HAWB_DATE
, JBH.DEPB_AMOUNT
, JBH.STATUS
, JBH.CONSOLIDATED_FLAG
, JBH.LEGAL_ENTITY_ID
, JBH.INVOICE_NUM
, JBH.ATTRIBUTE1
, JBH.ATTRIBUTE2
, JBH.ATTRIBUTE3
, JBH.ATTRIBUTE4
, JBH.ATTRIBUTE5
, JBH.ATTRIBUTE6
, JBH.ATTRIBUTE7
, JBH.ATTRIBUTE8
, JBH.ATTRIBUTE9
, JBH.ATTRIBUTE10
, JBH.ATTRIBUTE11
, JBH.ATTRIBUTE12
, JBH.ATTRIBUTE13
, JBH.ATTRIBUTE14
, JBH.ATTRIBUTE15
, JBH.ATTRIBUTE_CATEGORY
, JBH.CREATION_DATE
, JBH.CREATED_BY
, JBH.LAST_UPDATE_DATE
, JBH.LAST_UPDATED_BY
, JBH.LAST_UPDATE_LOGIN
, JBH.OBJECT_VERSION_NUMBER
, BOE_STATUS.MEANING STATUS_DESC
FROM JAI_CMN_BOE_HDRS JBH
, HR_OPERATING_UNITS HR
, ORG_ORGANIZATION_DEFINITIONS ORG
, HR_LOCATIONS LOC
, JA_LOOKUPS BOE_TYPE
, JA_LOOKUPS PORT_TYPE
, PO_VENDORS POV
, PO_VENDOR_SITES_ALL PVS
, PO_VENDORS AUTH
, PO_VENDOR_SITES_ALL AUTH_SITE
, JAI_CMN_BOE_AGENTS CBA
, JA_LOOKUPS BOE_STATUS
WHERE JBH.ORG_ID = HR.ORGANIZATION_ID
AND JBH.BOE_TYPE = BOE_TYPE.LOOKUP_CODE
AND JBH.LOCATION_ID = LOC.LOCATION_ID
AND JBH.ORGANIZATION_ID = ORG.ORGANIZATION_ID
AND JBH.VENDOR_ID = POV.VENDOR_ID(+)
AND JBH.VENDOR_SITE_ID = PVS.VENDOR_SITE_ID(+)
AND JBH.CUSTOMS_AUTHORITY_ID = AUTH.VENDOR_ID
AND JBH.CUSTOMS_AUTHORITY_SITE_ID = AUTH_SITE.VENDOR_SITE_ID
AND JBH.PORT_CODE = PORT_TYPE.LOOKUP_CODE
AND JBH.STATUS = BOE_STATUS.LOOKUP_CODE
AND JBH.AGENT_ID = CBA.AGENT_ID
AND BOE_TYPE.LOOKUP_TYPE = 'JAI_BOE_TYPE'
AND PORT_TYPE.LOOKUP_TYPE = 'JAI_PORT_CODE'
AND BOE_STATUS.LOOKUP_TYPE = 'JAI_BOE_INVOICE_STATUS'