Product: | JA - Asia/Pacific Localizations |
---|---|
Description: | |
Implementation/DBA Data: | APPS.JAI_BOE_DETAILS_V |
SELECT JBD.BOE_DETAIL_ID
, JBD.BOE_ID
, JBD.BOE_DOC_ID
, JBD.BOE_DOC_LINE_ID
, JBD.BOE_DOC_LINE_NUM
, JBD.DETAIL_LINE_NUM
, JBD.SHIPMENT_LINE_NUM
, JBD.UNIT_PRICE
, JBD.QUANTITY
, JBD.APPLIED_QTY
, JBD.UOM_CODE
, JBD.LINE_AMOUNT
, JBD.INVENTORY_ITEM_ID
, JBD.CUSTOMS_TARIFF_CODE
, JBD.CUSTOMS_TARIFF_HEADING
, JBD.DUTY_CODE
, JBD.DESCRIPTION
, JBD.ASSESSABLE_VALUE
, JBD.TAX_CATEGORY_ID
, CTC.TAX_CATEGORY_NAME
, CTC.TAX_CATEGORY_DESC
, JBD.TAX_AMOUNT
, JBD.PKG_MARKS_NUM
, JBD.PKG_SERIAL_NUMBER
, JBD.ATTRIBUTE1
, JBD.ATTRIBUTE2
, JBD.ATTRIBUTE3
, JBD.ATTRIBUTE4
, JBD.ATTRIBUTE5
, JBD.ATTRIBUTE6
, JBD.ATTRIBUTE7
, JBD.ATTRIBUTE8
, JBD.ATTRIBUTE9
, JBD.ATTRIBUTE10
, JBD.ATTRIBUTE11
, JBD.ATTRIBUTE12
, JBD.ATTRIBUTE13
, JBD.ATTRIBUTE14
, JBD.ATTRIBUTE15
, JBD.ATTRIBUTE_CATEGORY
, JBD.CREATION_DATE
, JBD.CREATED_BY
, JBD.LAST_UPDATE_DATE
, JBD.LAST_UPDATED_BY
, JBD.LAST_UPDATE_LOGIN
, JBD.OBJECT_VERSION_NUMBER
FROM JAI_BOE_DETAILS JBD
, JAI_CMN_TAX_CTGS_ALL CTC
WHERE JBD.TAX_CATEGORY_ID = CTC.TAX_CATEGORY_ID(+)