OKC_VRM_SOURCE_DOC_LINES_V

Details

• Schema: FUSION

• Object owner: OKC

• Object type: VIEW

Columns

Name

LINE_ID CONTRACT_ID START_DATE LINE_NUMBER LINE_CREATION_DATE LINE_UPDATE_DATE JTOT_OBJECT1_CODE ITEM_ID INV_ORG_ID STATUS UOM_CODE NUM_OF_ITEM PRICE_UNIT QUANTITY UNIT_PRICE LINE_AMOUNT SHIP_TO_ACCT_ID SHIP_TO_SITE_USE_ID CUST_PO_NUMBER BUDGET_GROSS_MARGIN REVENUE_IMPACT_DATE EST_VAR_CONSIDERATION_AMT STANDALONE_SELLING_PRICE MEMO_LINE_SEQ_ID BILL_TO_CUST_ACCT_ID BILL_TO_SITE_USE_ID PAYMENT_TERM_ID 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 ATTRIBUTE_NUMBER1 ATTRIBUTE_NUMBER2 ATTRIBUTE_NUMBER3 ATTRIBUTE_NUMBER4 ATTRIBUTE_NUMBER5 ATTRIBUTE_NUMBER6 ATTRIBUTE_NUMBER7 ATTRIBUTE_NUMBER8 ATTRIBUTE_NUMBER9 ATTRIBUTE_NUMBER10 ATTRIBUTE_DATE1 ATTRIBUTE_DATE2 ATTRIBUTE_DATE3 ATTRIBUTE_DATE4 ATTRIBUTE_DATE5 ATTRIBUTE_DATE6 ATTRIBUTE_DATE7 ATTRIBUTE_DATE8 ATTRIBUTE_DATE9 ATTRIBUTE_DATE10 BPLAN_ATTRIBUTE_CATEGORY BPLAN_ATTRIBUTE1 BPLAN_ATTRIBUTE2 BPLAN_ATTRIBUTE3 BPLAN_ATTRIBUTE4 BPLAN_ATTRIBUTE5 BPLAN_ATTRIBUTE6 BPLAN_ATTRIBUTE7 BPLAN_ATTRIBUTE8 BPLAN_ATTRIBUTE9 BPLAN_ATTRIBUTE10 BPLAN_ATTRIBUTE11 BPLAN_ATTRIBUTE12 BPLAN_ATTRIBUTE13 BPLAN_ATTRIBUTE14 BPLAN_ATTRIBUTE15 BPLAN_ATTRIBUTE_CHAR16 BPLAN_ATTRIBUTE_CHAR17 BPLAN_ATTRIBUTE_CHAR18 BPLAN_ATTRIBUTE_CHAR19 BPLAN_ATTRIBUTE_CHAR20 BPLAN_ATTRIBUTE_CHAR21 BPLAN_ATTRIBUTE_CHAR22 BPLAN_ATTRIBUTE_CHAR23 BPLAN_ATTRIBUTE_CHAR24 BPLAN_ATTRIBUTE_CHAR25 BPLAN_ATTRIBUTE_CHAR26 BPLAN_ATTRIBUTE_CHAR27 BPLAN_ATTRIBUTE_CHAR28 BPLAN_ATTRIBUTE_CHAR29 BPLAN_ATTRIBUTE_CHAR30 BPLAN_ATTRIBUTE_CHAR31 BPLAN_ATTRIBUTE_CHAR32 BPLAN_ATTRIBUTE_CHAR33 BPLAN_ATTRIBUTE_CHAR34 BPLAN_ATTRIBUTE_CHAR35 BPLAN_ATTRIBUTE_DATE1 BPLAN_ATTRIBUTE_DATE2 BPLAN_ATTRIBUTE_DATE3 BPLAN_ATTRIBUTE_DATE4 BPLAN_ATTRIBUTE_DATE5 BPLAN_ATTRIBUTE_DATE6 BPLAN_ATTRIBUTE_DATE7 BPLAN_ATTRIBUTE_DATE8 BPLAN_ATTRIBUTE_DATE9 BPLAN_ATTRIBUTE_DATE10 BPLAN_ATTRIBUTE_NUMBER1 BPLAN_ATTRIBUTE_NUMBER2 BPLAN_ATTRIBUTE_NUMBER3 BPLAN_ATTRIBUTE_NUMBER4 BPLAN_ATTRIBUTE_NUMBER5 BPLAN_ATTRIBUTE_NUMBER6 BPLAN_ATTRIBUTE_NUMBER7 BPLAN_ATTRIBUTE_NUMBER8 BPLAN_ATTRIBUTE_NUMBER9 BPLAN_ATTRIBUTE_NUMBER10 BPLAN_ATTRIBUTE_TIMESTAMP1 BPLAN_ATTRIBUTE_TIMESTAMP2 BPLAN_ATTRIBUTE_TIMESTAMP3 BPLAN_ATTRIBUTE_TIMESTAMP4 BPLAN_ATTRIBUTE_TIMESTAMP5 RPLAN_ATTRIBUTE_CATEGORY RPLAN_ATTRIBUTE1 RPLAN_ATTRIBUTE2 RPLAN_ATTRIBUTE3 RPLAN_ATTRIBUTE4 RPLAN_ATTRIBUTE5 RPLAN_ATTRIBUTE6 RPLAN_ATTRIBUTE7 RPLAN_ATTRIBUTE8 RPLAN_ATTRIBUTE9 RPLAN_ATTRIBUTE10 RPLAN_ATTRIBUTE11 RPLAN_ATTRIBUTE12 RPLAN_ATTRIBUTE13 RPLAN_ATTRIBUTE14 RPLAN_ATTRIBUTE15 RPLAN_ATTRIBUTE_CHAR16 RPLAN_ATTRIBUTE_CHAR17 RPLAN_ATTRIBUTE_CHAR18 RPLAN_ATTRIBUTE_CHAR19 RPLAN_ATTRIBUTE_CHAR20 RPLAN_ATTRIBUTE_CHAR21 RPLAN_ATTRIBUTE_CHAR22 RPLAN_ATTRIBUTE_CHAR23 RPLAN_ATTRIBUTE_CHAR24 RPLAN_ATTRIBUTE_CHAR25 RPLAN_ATTRIBUTE_CHAR26 RPLAN_ATTRIBUTE_CHAR27 RPLAN_ATTRIBUTE_CHAR28 RPLAN_ATTRIBUTE_CHAR29 RPLAN_ATTRIBUTE_CHAR30 RPLAN_ATTRIBUTE_CHAR31 RPLAN_ATTRIBUTE_CHAR32 RPLAN_ATTRIBUTE_CHAR33 RPLAN_ATTRIBUTE_CHAR34 RPLAN_ATTRIBUTE_CHAR35 RPLAN_ATTRIBUTE_DATE1 RPLAN_ATTRIBUTE_DATE2 RPLAN_ATTRIBUTE_DATE3 RPLAN_ATTRIBUTE_DATE4 RPLAN_ATTRIBUTE_DATE5 RPLAN_ATTRIBUTE_DATE6 RPLAN_ATTRIBUTE_DATE7 RPLAN_ATTRIBUTE_DATE8 RPLAN_ATTRIBUTE_DATE9 RPLAN_ATTRIBUTE_DATE10 RPLAN_ATTRIBUTE_NUMBER1 RPLAN_ATTRIBUTE_NUMBER2 RPLAN_ATTRIBUTE_NUMBER3 RPLAN_ATTRIBUTE_NUMBER4 RPLAN_ATTRIBUTE_NUMBER5 RPLAN_ATTRIBUTE_NUMBER6 RPLAN_ATTRIBUTE_NUMBER7 RPLAN_ATTRIBUTE_NUMBER8 RPLAN_ATTRIBUTE_NUMBER9 RPLAN_ATTRIBUTE_NUMBER10 RPLAN_ATTRIBUTE_TIMESTAMP1 RPLAN_ATTRIBUTE_TIMESTAMP2 RPLAN_ATTRIBUTE_TIMESTAMP3 RPLAN_ATTRIBUTE_TIMESTAMP4 RPLAN_ATTRIBUTE_TIMESTAMP5

Query

SQL_Statement

SELECT lines.ID LINE_ID, lines.DNZ_CHR_ID CONTRACT_ID, lines.START_DATE, lines.LINE_NUMBER, lines.creation_date line_creation_date, lines.last_update_date line_update_date, lines.JTOT_OBJECT1_CODE, lines.OBJECT1_ID1 ITEM_ID, lines.OBJECT1_ID2 INV_ORG_ID, DECODE(lines.STS_CODE, 'CLOSED', 'FULFILLED', 'NOT_FULFILLED') STATUS, NVL(lines.UOM_CODE,'Ea') UOM_CODE, lines.num_of_item, lines.price_unit, NVL(lines.NUM_OF_ITEM, 1) QUANTITY, NVL(lines.PRICE_UNIT, NVL(lines.LINE_AMOUNT,0)/NVL(lines.NUM_OF_ITEM,1)) UNIT_PRICE, NVL(lines.LINE_AMOUNT,0) LINE_AMOUNT, lines.SHIP_TO_ACCT_ID, lines.ship_to_site_use_id, lines.CUST_PO_NUMBER, lines.BUDGET_GROSS_MARGIN*100 BUDGET_GROSS_MARGIN, lines.REVENUE_IMPACT_DATE, lines.EST_VAR_CONSIDERATION_AMT, lines.STANDALONE_SELLING_PRICE, Decode( lines.OBJECT1_ID1, NULL, DECODE(rev_PLAN.BILL_TYPE_CLASS_CODE, 'AMOUNT_BASED',12, 'PERCENT_SPENT',12, 'PERCENT_COMPLETE',12, NULL,NULL, 11), NULL) MEMO_LINE_SEQ_ID, bill_plan.BILL_TO_CUST_ACCT_ID, bill_plan.bill_to_site_use_id, bill_plan.PAYMENT_TERM_ID, lines.ATTRIBUTE_CATEGORY, lines.ATTRIBUTE1, lines.ATTRIBUTE2, lines.ATTRIBUTE3, lines.ATTRIBUTE4, lines.ATTRIBUTE5, lines.ATTRIBUTE6, lines.ATTRIBUTE7, lines.ATTRIBUTE8, lines.ATTRIBUTE9, lines.ATTRIBUTE10, lines.ATTRIBUTE11, lines.ATTRIBUTE12, lines.ATTRIBUTE13, lines.ATTRIBUTE14, lines.ATTRIBUTE15, lines.ATTRIBUTE16, lines.ATTRIBUTE17, lines.ATTRIBUTE18, lines.ATTRIBUTE19, lines.ATTRIBUTE20, lines.ATTRIBUTE21, lines.ATTRIBUTE22, lines.ATTRIBUTE23, lines.ATTRIBUTE24, lines.ATTRIBUTE25, lines.ATTRIBUTE26, lines.ATTRIBUTE27, lines.ATTRIBUTE28, lines.ATTRIBUTE29, lines.ATTRIBUTE30, lines.ATTRIBUTE_NUMBER1, lines.ATTRIBUTE_NUMBER2, lines.ATTRIBUTE_NUMBER3, lines.ATTRIBUTE_NUMBER4, lines.ATTRIBUTE_NUMBER5, lines.ATTRIBUTE_NUMBER6, lines.ATTRIBUTE_NUMBER7, lines.ATTRIBUTE_NUMBER8, lines.ATTRIBUTE_NUMBER9, lines.ATTRIBUTE_NUMBER10, lines.ATTRIBUTE_DATE1, lines.ATTRIBUTE_DATE2, lines.ATTRIBUTE_DATE3, lines.ATTRIBUTE_DATE4, lines.ATTRIBUTE_DATE5, lines.ATTRIBUTE_DATE6, lines.ATTRIBUTE_DATE7, lines.ATTRIBUTE_DATE8, lines.ATTRIBUTE_DATE9, lines.ATTRIBUTE_DATE10, bill_plan.ATTRIBUTE_CATEGORY BPLAN_ATTRIBUTE_CATEGORY, bill_plan.ATTRIBUTE1 BPLAN_ATTRIBUTE1, bill_plan.ATTRIBUTE2 BPLAN_ATTRIBUTE2, bill_plan.ATTRIBUTE3 BPLAN_ATTRIBUTE3, bill_plan.ATTRIBUTE4 BPLAN_ATTRIBUTE4, bill_plan.ATTRIBUTE5 BPLAN_ATTRIBUTE5, bill_plan.ATTRIBUTE6 BPLAN_ATTRIBUTE6, bill_plan.ATTRIBUTE7 BPLAN_ATTRIBUTE7, bill_plan.ATTRIBUTE8 BPLAN_ATTRIBUTE8, bill_plan.ATTRIBUTE9 BPLAN_ATTRIBUTE9, bill_plan.ATTRIBUTE10 BPLAN_ATTRIBUTE10, bill_plan.ATTRIBUTE11 BPLAN_ATTRIBUTE11, bill_plan.ATTRIBUTE12 BPLAN_ATTRIBUTE12, bill_plan.ATTRIBUTE13 BPLAN_ATTRIBUTE13, bill_plan.ATTRIBUTE14 BPLAN_ATTRIBUTE14, bill_plan.ATTRIBUTE15 BPLAN_ATTRIBUTE15, bill_plan.ATTRIBUTE_CHAR16 BPLAN_ATTRIBUTE_CHAR16, bill_plan.ATTRIBUTE_CHAR17 BPLAN_ATTRIBUTE_CHAR17, bill_plan.ATTRIBUTE_CHAR18 BPLAN_ATTRIBUTE_CHAR18, bill_plan.ATTRIBUTE_CHAR19 BPLAN_ATTRIBUTE_CHAR19, bill_plan.ATTRIBUTE_CHAR20 BPLAN_ATTRIBUTE_CHAR20, bill_plan.ATTRIBUTE_CHAR21 BPLAN_ATTRIBUTE_CHAR21, bill_plan.ATTRIBUTE_CHAR22 BPLAN_ATTRIBUTE_CHAR22, bill_plan.ATTRIBUTE_CHAR23 BPLAN_ATTRIBUTE_CHAR23, bill_plan.ATTRIBUTE_CHAR24 BPLAN_ATTRIBUTE_CHAR24, bill_plan.ATTRIBUTE_CHAR25 BPLAN_ATTRIBUTE_CHAR25, bill_plan.ATTRIBUTE_CHAR26 BPLAN_ATTRIBUTE_CHAR26, bill_plan.ATTRIBUTE_CHAR27 BPLAN_ATTRIBUTE_CHAR27, bill_plan.ATTRIBUTE_CHAR28 BPLAN_ATTRIBUTE_CHAR28, bill_plan.ATTRIBUTE_CHAR29 BPLAN_ATTRIBUTE_CHAR29, bill_plan.ATTRIBUTE_CHAR30 BPLAN_ATTRIBUTE_CHAR30, bill_plan.ATTRIBUTE_CHAR31 BPLAN_ATTRIBUTE_CHAR31, bill_plan.ATTRIBUTE_CHAR32 BPLAN_ATTRIBUTE_CHAR32, bill_plan.ATTRIBUTE_CHAR33 BPLAN_ATTRIBUTE_CHAR33, bill_plan.ATTRIBUTE_CHAR34 BPLAN_ATTRIBUTE_CHAR34, bill_plan.ATTRIBUTE_CHAR35 BPLAN_ATTRIBUTE_CHAR35, bill_plan.ATTRIBUTE_DATE1 BPLAN_ATTRIBUTE_DATE1, bill_plan.ATTRIBUTE_DATE2 BPLAN_ATTRIBUTE_DATE2, bill_plan.ATTRIBUTE_DATE3 BPLAN_ATTRIBUTE_DATE3, bill_plan.ATTRIBUTE_DATE4 BPLAN_ATTRIBUTE_DATE4, bill_plan.ATTRIBUTE_DATE5 BPLAN_ATTRIBUTE_DATE5, bill_plan.ATTRIBUTE_DATE6 BPLAN_ATTRIBUTE_DATE6, bill_plan.ATTRIBUTE_DATE7 BPLAN_ATTRIBUTE_DATE7, bill_plan.ATTRIBUTE_DATE8 BPLAN_ATTRIBUTE_DATE8, bill_plan.ATTRIBUTE_DATE9 BPLAN_ATTRIBUTE_DATE9, bill_plan.ATTRIBUTE_DATE10 BPLAN_ATTRIBUTE_DATE10, bill_plan.ATTRIBUTE_NUMBER1 BPLAN_ATTRIBUTE_NUMBER1, bill_plan.ATTRIBUTE_NUMBER2 BPLAN_ATTRIBUTE_NUMBER2, bill_plan.ATTRIBUTE_NUMBER3 BPLAN_ATTRIBUTE_NUMBER3, bill_plan.ATTRIBUTE_NUMBER4 BPLAN_ATTRIBUTE_NUMBER4, bill_plan.ATTRIBUTE_NUMBER5 BPLAN_ATTRIBUTE_NUMBER5, bill_plan.ATTRIBUTE_NUMBER6 BPLAN_ATTRIBUTE_NUMBER6, bill_plan.ATTRIBUTE_NUMBER7 BPLAN_ATTRIBUTE_NUMBER7, bill_plan.ATTRIBUTE_NUMBER8 BPLAN_ATTRIBUTE_NUMBER8, bill_plan.ATTRIBUTE_NUMBER9 BPLAN_ATTRIBUTE_NUMBER9, bill_plan.ATTRIBUTE_NUMBER10 BPLAN_ATTRIBUTE_NUMBER10, bill_plan.ATTRIBUTE_TIMESTAMP1 BPLAN_ATTRIBUTE_TIMESTAMP1, bill_plan.ATTRIBUTE_TIMESTAMP2 BPLAN_ATTRIBUTE_TIMESTAMP2, bill_plan.ATTRIBUTE_TIMESTAMP3 BPLAN_ATTRIBUTE_TIMESTAMP3, bill_plan.ATTRIBUTE_TIMESTAMP4 BPLAN_ATTRIBUTE_TIMESTAMP4, bill_plan.ATTRIBUTE_TIMESTAMP5 BPLAN_ATTRIBUTE_TIMESTAMP5, rev_plan.ATTRIBUTE_CATEGORY RPLAN_ATTRIBUTE_CATEGORY, rev_plan.ATTRIBUTE1 RPLAN_ATTRIBUTE1, rev_plan.ATTRIBUTE2 RPLAN_ATTRIBUTE2, rev_plan.ATTRIBUTE3 RPLAN_ATTRIBUTE3, rev_plan.ATTRIBUTE4 RPLAN_ATTRIBUTE4, rev_plan.ATTRIBUTE5 RPLAN_ATTRIBUTE5, rev_plan.ATTRIBUTE6 RPLAN_ATTRIBUTE6, rev_plan.ATTRIBUTE7 RPLAN_ATTRIBUTE7, rev_plan.ATTRIBUTE8 RPLAN_ATTRIBUTE8, rev_plan.ATTRIBUTE9 RPLAN_ATTRIBUTE9, rev_plan.ATTRIBUTE10 RPLAN_ATTRIBUTE10, rev_plan.ATTRIBUTE11 RPLAN_ATTRIBUTE11, rev_plan.ATTRIBUTE12 RPLAN_ATTRIBUTE12, rev_plan.ATTRIBUTE13 RPLAN_ATTRIBUTE13, rev_plan.ATTRIBUTE14 RPLAN_ATTRIBUTE14, rev_plan.ATTRIBUTE15 RPLAN_ATTRIBUTE15, rev_plan.ATTRIBUTE_CHAR16 RPLAN_ATTRIBUTE_CHAR16, rev_plan.ATTRIBUTE_CHAR17 RPLAN_ATTRIBUTE_CHAR17, rev_plan.ATTRIBUTE_CHAR18 RPLAN_ATTRIBUTE_CHAR18, rev_plan.ATTRIBUTE_CHAR19 RPLAN_ATTRIBUTE_CHAR19, rev_plan.ATTRIBUTE_CHAR20 RPLAN_ATTRIBUTE_CHAR20, rev_plan.ATTRIBUTE_CHAR21 RPLAN_ATTRIBUTE_CHAR21, rev_plan.ATTRIBUTE_CHAR22 RPLAN_ATTRIBUTE_CHAR22, rev_plan.ATTRIBUTE_CHAR23 RPLAN_ATTRIBUTE_CHAR23, rev_plan.ATTRIBUTE_CHAR24 RPLAN_ATTRIBUTE_CHAR24, rev_plan.ATTRIBUTE_CHAR25 RPLAN_ATTRIBUTE_CHAR25, rev_plan.ATTRIBUTE_CHAR26 RPLAN_ATTRIBUTE_CHAR26, rev_plan.ATTRIBUTE_CHAR27 RPLAN_ATTRIBUTE_CHAR27, rev_plan.ATTRIBUTE_CHAR28 RPLAN_ATTRIBUTE_CHAR28, rev_plan.ATTRIBUTE_CHAR29 RPLAN_ATTRIBUTE_CHAR29, rev_plan.ATTRIBUTE_CHAR30 RPLAN_ATTRIBUTE_CHAR30, rev_plan.ATTRIBUTE_CHAR31 RPLAN_ATTRIBUTE_CHAR31, rev_plan.ATTRIBUTE_CHAR32 RPLAN_ATTRIBUTE_CHAR32, rev_plan.ATTRIBUTE_CHAR33 RPLAN_ATTRIBUTE_CHAR33, rev_plan.ATTRIBUTE_CHAR34 RPLAN_ATTRIBUTE_CHAR34, rev_plan.ATTRIBUTE_CHAR35 RPLAN_ATTRIBUTE_CHAR35, rev_plan.ATTRIBUTE_DATE1 RPLAN_ATTRIBUTE_DATE1, rev_plan.ATTRIBUTE_DATE2 RPLAN_ATTRIBUTE_DATE2, rev_plan.ATTRIBUTE_DATE3 RPLAN_ATTRIBUTE_DATE3, rev_plan.ATTRIBUTE_DATE4 RPLAN_ATTRIBUTE_DATE4, rev_plan.ATTRIBUTE_DATE5 RPLAN_ATTRIBUTE_DATE5, rev_plan.ATTRIBUTE_DATE6 RPLAN_ATTRIBUTE_DATE6, rev_plan.ATTRIBUTE_DATE7 RPLAN_ATTRIBUTE_DATE7, rev_plan.ATTRIBUTE_DATE8 RPLAN_ATTRIBUTE_DATE8, rev_plan.ATTRIBUTE_DATE9 RPLAN_ATTRIBUTE_DATE9, rev_plan.ATTRIBUTE_DATE10 RPLAN_ATTRIBUTE_DATE10, rev_plan.ATTRIBUTE_NUMBER1 RPLAN_ATTRIBUTE_NUMBER1, rev_plan.ATTRIBUTE_NUMBER2 RPLAN_ATTRIBUTE_NUMBER2, rev_plan.ATTRIBUTE_NUMBER3 RPLAN_ATTRIBUTE_NUMBER3, rev_plan.ATTRIBUTE_NUMBER4 RPLAN_ATTRIBUTE_NUMBER4, rev_plan.ATTRIBUTE_NUMBER5 RPLAN_ATTRIBUTE_NUMBER5, rev_plan.ATTRIBUTE_NUMBER6 RPLAN_ATTRIBUTE_NUMBER6, rev_plan.ATTRIBUTE_NUMBER7 RPLAN_ATTRIBUTE_NUMBER7, rev_plan.ATTRIBUTE_NUMBER8 RPLAN_ATTRIBUTE_NUMBER8, rev_plan.ATTRIBUTE_NUMBER9 RPLAN_ATTRIBUTE_NUMBER9, rev_plan.ATTRIBUTE_NUMBER10 RPLAN_ATTRIBUTE_NUMBER10, rev_plan.ATTRIBUTE_TIMESTAMP1 RPLAN_ATTRIBUTE_TIMESTAMP1, rev_plan.ATTRIBUTE_TIMESTAMP2 RPLAN_ATTRIBUTE_TIMESTAMP2, rev_plan.ATTRIBUTE_TIMESTAMP3 RPLAN_ATTRIBUTE_TIMESTAMP3, rev_plan.ATTRIBUTE_TIMESTAMP4 RPLAN_ATTRIBUTE_TIMESTAMP4, rev_plan.ATTRIBUTE_TIMESTAMP5 RPLAN_ATTRIBUTE_TIMESTAMP5 FROM OKC_K_LINES_B lines, PJB_BILL_PLANS_B bill_plan, PJB_BILL_PLANS_B rev_plan, okc_k_headers_all_b cont, OKC_CONTRACT_TYPES_B t WHERE lines.VERSION_TYPE IN ('C','A') AND lines.source_code_class = 'PROJECT' AND lines.JTOT_OBJECT1_CODE IN ('USER_FREE_FORM_PROJECT_BASED','USER_ITEM_PROJECT_BASED') AND lines.STS_CODE IN ('ACTIVE','CLOSED','EXPIRED','HOLD') AND lines.BILL_PLAN_ID = BILL_PLAN.BILL_PLAN_ID(+) AND lines.MAJOR_VERSION = BILL_PLAN.MAJOR_VERSION(+) AND lines.revenue_PLAN_ID = rev_PLAN.BILL_PLAN_ID(+) AND lines.MAJOR_VERSION = rev_PLAN.MAJOR_VERSION(+) AND lines.dnz_chr_id = CONT.ID AND lines.major_version = CONT.major_version AND cont.CONTRACT_TYPE_ID = t.CONTRACT_TYPE_ID and (Nvl(t.INTER_COMPANY_FLAG,'N')<>'Y' and Nvl(t.INTER_PROJECT_FLAG,'N')<>'Y')