VIEW: APPS.JAI_BOE_DETAILS_V

Source

View Text - Preformatted

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(+)

View Text - HTML Formatted

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(+)