OKC_DTS_DELIVERABLES_VL

Details

• Schema: FUSION

• Object owner: OKC

• Object type: VIEW

Columns

Name

DELIVERABLE_ID CHR_ID CLE_ID DELIVERABLE_NUM NAME DESCRIPTION COMMENTS COMPLETION_COMMENTS DIRECTION DELIVERABLE_TYPE DEFAULTED_YN LINE_TYPE_ID ITEM_ID QUANTITY UNIT_PRICE UOM_CODE CURRENCY_CODE DELIVERABLE_STATUS DELIVERY_DATE COMPLETION_DATE DESTINATION_TYPE_CODE RECEIVING_ORG_ID RECEIVING_LOCATION_ID SUPPLIER_ID SUPPLIER_SITE_ID SUPPLIER_ADDRESS_SITE_ID AMOUNT PURCHASING_CATEGORY_ID RATE_TYPE RATE_DATE EXCHANGE_RATE CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN OBJECT_VERSION_NUMBER PURCHASING_PK1_VALUE PURCHASING_PK2_VALUE PURCHASING_PK3_VALUE PURCHASING_PK4_VALUE PURCHASING_PK5_VALUE PAYMENT_TERMS_ID FREIGHT_TERMS_CODE FOB_CODE PREVIOUS_DELIVERABLE_STATUS ATTRIBUTE_CATEGORY ATTRIBUTE1 ATTRIBUTE2 ATTRIBUTE3 ATTRIBUTE4 ATTRIBUTE5 ATTRIBUTE6 ATTRIBUTE7 ATTRIBUTE8 ATTRIBUTE9 ATTRIBUTE10 ATTRIBUTE11 ATTRIBUTE12 ATTRIBUTE13 ATTRIBUTE14 ATTRIBUTE15 ATTRIBUTE16 ATTRIBUTE17 ATTRIBUTE18 ATTRIBUTE19 ATTRIBUTE20 ATTRIBUTE21 ATTRIBUTE22 ATTRIBUTE23 ATTRIBUTE24 ATTRIBUTE25 ATTRIBUTE26 ATTRIBUTE27 ATTRIBUTE28 ATTRIBUTE29 ATTRIBUTE30 PROCURE_BU_ID REQ_BU_ID BUYER_ID SUPPLIER_CONTACT_ID BILL_TO_LOCATION_ID BATCH_ID PO_DOC_NUMBER PO_LINE_NUMBER PO_CREATION_DATE PO_TARGET_SYSTEM CARRIER_ID FIXED_PRICE_SERVICE_YN AGREEMENT_UNIT_PRICE AGREEMENT_PRICE_OVER_ALLWD_YN AGREEMENT_PRICE_LIMIT AGREEMENT_QTY_LIMIT AGREEMENT_AMT_LIMIT AGREED_QTY AGREED_AMT MIN_RELEASE_QTY MIN_RELEASE_AMT REQUESTER_ID AGREEMENT_END_DATE BUYER_SOURCE_CODE REQUESTER_SOURCE_CODE INV_ORG_ID

Query

SQL_Statement

SELECT B.DELIVERABLE_ID, B.CHR_ID, B.CLE_ID, B.DELIVERABLE_NUM, TL.NAME, TL.DESCRIPTION, TL.COMMENTS, TL.COMPLETION_COMMENTS, B.DIRECTION, B.DELIVERABLE_TYPE, B.DEFAULTED_YN, B.LINE_TYPE_ID, B.ITEM_ID, B.QUANTITY, B.UNIT_PRICE, B.UOM_CODE, B.CURRENCY_CODE, B.DELIVERABLE_STATUS, B.DELIVERY_DATE, B.COMPLETION_DATE, B.DESTINATION_TYPE_CODE, B.RECEIVING_ORG_ID, B.RECEIVING_LOCATION_ID, B.SUPPLIER_ID, B.SUPPLIER_SITE_ID, B.SUPPLIER_ADDRESS_SITE_ID, B.AMOUNT, B.PURCHASING_CATEGORY_ID, B.RATE_TYPE, B.RATE_DATE, B.EXCHANGE_RATE, B.CREATED_BY, B.CREATION_DATE, B.LAST_UPDATED_BY, B.LAST_UPDATE_DATE, B.LAST_UPDATE_LOGIN, B.OBJECT_VERSION_NUMBER, B.PURCHASING_PK1_VALUE, B.PURCHASING_PK2_VALUE, B.PURCHASING_PK3_VALUE, B.PURCHASING_PK4_VALUE, B.PURCHASING_PK5_VALUE, B.PAYMENT_TERMS_ID, B.FREIGHT_TERMS_CODE, B.FOB_CODE, B.PREVIOUS_DELIVERABLE_STATUS, B.ATTRIBUTE_CATEGORY, B.ATTRIBUTE1, B.ATTRIBUTE2, B.ATTRIBUTE3, B.ATTRIBUTE4, B.ATTRIBUTE5, B.ATTRIBUTE6, B.ATTRIBUTE7, B.ATTRIBUTE8, B.ATTRIBUTE9, B.ATTRIBUTE10, B.ATTRIBUTE11, B.ATTRIBUTE12, B.ATTRIBUTE13, B.ATTRIBUTE14, B.ATTRIBUTE15, B.ATTRIBUTE16, B.ATTRIBUTE17, B.ATTRIBUTE18, B.ATTRIBUTE19, B.ATTRIBUTE20, B.ATTRIBUTE21, B.ATTRIBUTE22, B.ATTRIBUTE23, B.ATTRIBUTE24, B.ATTRIBUTE25, B.ATTRIBUTE26, B.ATTRIBUTE27, B.ATTRIBUTE28, B.ATTRIBUTE29, B.ATTRIBUTE30, B.PROCURE_BU_ID, B.REQ_BU_ID, B.BUYER_ID, B.SUPPLIER_CONTACT_ID, B.BILL_TO_LOCATION_ID, B.BATCH_ID, B.PO_DOC_NUMBER, B.PO_LINE_NUMBER, B.PO_CREATION_DATE, B.PO_TARGET_SYSTEM, B.CARRIER_ID, B.FIXED_PRICE_SERVICE_YN, B.AGREEMENT_UNIT_PRICE, B.AGREEMENT_PRICE_OVER_ALLWD_YN, B.AGREEMENT_PRICE_LIMIT, B.AGREEMENT_QTY_LIMIT, B.AGREEMENT_AMT_LIMIT, B.AGREED_QTY, B.AGREED_AMT, B.MIN_RELEASE_QTY, B.MIN_RELEASE_AMT, B.REQUESTER_ID, B.AGREEMENT_END_DATE, B.BUYER_SOURCE_CODE, B.REQUESTER_SOURCE_CODE, B.INV_ORG_ID FROM OKC_DTS_DELIVERABLES_B B, OKC_DTS_DELIVERABLES_TL TL WHERE B.DELIVERABLE_ID = TL.DELIVERABLE_ID AND TL.LANGUAGE = USERENV('LANG')