Product: | JA - Asia/Pacific Localizations |
---|---|
Description: | |
Implementation/DBA Data: | APPS.JAI_BOE_HEADERS_V |
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'