PJB_XLA_CONTLINES_REF_V

Details

• Schema: FUSION

• Object owner: PJB

• Object type: VIEW

Columns

Name

CONTRACT_LINE_ID CONTRACT_LINE_NUMBER ITEM_SALES_ACCOUNT CONT_LINE_RECEIVER_PROJECT_ID CONT_LINE_RECEIVER_TASK_ID CONT_LINE_ATTRIBUTE_CATEGORY CONTRACT_LINE_ATTRIBUTE1 CONTRACT_LINE_ATTRIBUTE2 CONTRACT_LINE_ATTRIBUTE3 CONTRACT_LINE_ATTRIBUTE4 CONTRACT_LINE_ATTRIBUTE5 CONTRACT_LINE_ATTRIBUTE6 CONTRACT_LINE_ATTRIBUTE7 CONTRACT_LINE_ATTRIBUTE8 CONTRACT_LINE_ATTRIBUTE9 CONTRACT_LINE_ATTRIBUTE10 CONTRACT_LINE_ATTRIBUTE11 CONTRACT_LINE_ATTRIBUTE12 CONTRACT_LINE_ATTRIBUTE13 CONTRACT_LINE_ATTRIBUTE14 CONTRACT_LINE_ATTRIBUTE15 CONTRACT_LINE_ATTRIBUTE16 CONTRACT_LINE_ATTRIBUTE17 CONTRACT_LINE_ATTRIBUTE18 CONTRACT_LINE_ATTRIBUTE19 CONTRACT_LINE_ATTRIBUTE20 CONTRACT_LINE_ATTRIBUTE21 CONTRACT_LINE_ATTRIBUTE22 CONTRACT_LINE_ATTRIBUTE23 CONTRACT_LINE_ATTRIBUTE24 CONTRACT_LINE_ATTRIBUTE25 CONTRACT_LINE_ATTRIBUTE26 CONTRACT_LINE_ATTRIBUTE27 CONTRACT_LINE_ATTRIBUTE28 CONTRACT_LINE_ATTRIBUTE29 CONTRACT_LINE_ATTRIBUTE30 CON_LINE_CUST_PO_NUMBER CONTRACT_LINE_RISK_FLAG SHIP_TO_CUSTOMER_ID WAREHOUSE_BU_ID INVENTORY_ITEM_ID

Query

SQL_Statement

SELECT ContLines.ID CONTRACT_LINE_ID , ContLines.LINE_NUMBER CONTRACT_LINE_NUMBER , Item.SALES_ACCOUNT ITEM_SALES_ACCOUNT , ContIntAttrib.RECEIVER_PROJECT_ID CONT_LINE_RECEIVER_PROJECT_ID , ContIntAttrib.RECEIVER_TASK_ID CONT_LINE_RECEIVER_TASK_ID , ContLines.ATTRIBUTE_CATEGORY CONT_LINE_ATTRIBUTE_CATEGORY , ContLines.ATTRIBUTE1 CONTRACT_LINE_ATTRIBUTE1 , ContLines.ATTRIBUTE2 CONTRACT_LINE_ATTRIBUTE2 , ContLines.ATTRIBUTE3 CONTRACT_LINE_ATTRIBUTE3 , ContLines.ATTRIBUTE4 CONTRACT_LINE_ATTRIBUTE4 , ContLines.ATTRIBUTE5 CONTRACT_LINE_ATTRIBUTE5 , ContLines.ATTRIBUTE6 CONTRACT_LINE_ATTRIBUTE6 , ContLines.ATTRIBUTE7 CONTRACT_LINE_ATTRIBUTE7 , ContLines.ATTRIBUTE8 CONTRACT_LINE_ATTRIBUTE8 , ContLines.ATTRIBUTE9 CONTRACT_LINE_ATTRIBUTE9 , ContLines.ATTRIBUTE10 CONTRACT_LINE_ATTRIBUTE10 , ContLines.ATTRIBUTE11 CONTRACT_LINE_ATTRIBUTE11 , ContLines.ATTRIBUTE12 CONTRACT_LINE_ATTRIBUTE12 , ContLines.ATTRIBUTE13 CONTRACT_LINE_ATTRIBUTE13 , ContLines.ATTRIBUTE14 CONTRACT_LINE_ATTRIBUTE14 , ContLines.ATTRIBUTE15 CONTRACT_LINE_ATTRIBUTE15 , ContLines.ATTRIBUTE16 CONTRACT_LINE_ATTRIBUTE16 , ContLines.ATTRIBUTE17 CONTRACT_LINE_ATTRIBUTE17 , ContLines.ATTRIBUTE18 CONTRACT_LINE_ATTRIBUTE18 , ContLines.ATTRIBUTE19 CONTRACT_LINE_ATTRIBUTE19 , ContLines.ATTRIBUTE20 CONTRACT_LINE_ATTRIBUTE20 , ContLines.ATTRIBUTE21 CONTRACT_LINE_ATTRIBUTE21 , ContLines.ATTRIBUTE22 CONTRACT_LINE_ATTRIBUTE22 , ContLines.ATTRIBUTE23 CONTRACT_LINE_ATTRIBUTE23 , ContLines.ATTRIBUTE24 CONTRACT_LINE_ATTRIBUTE24 , ContLines.ATTRIBUTE25 CONTRACT_LINE_ATTRIBUTE25 , ContLines.ATTRIBUTE26 CONTRACT_LINE_ATTRIBUTE26 , ContLines.ATTRIBUTE27 CONTRACT_LINE_ATTRIBUTE27 , ContLines.ATTRIBUTE28 CONTRACT_LINE_ATTRIBUTE28 , ContLines.ATTRIBUTE29 CONTRACT_LINE_ATTRIBUTE29 , ContLines.ATTRIBUTE30 CONTRACT_LINE_ATTRIBUTE30 , ContLines.CUST_PO_NUMBER CON_LINE_CUST_PO_NUMBER , ContLines.AT_RISK_YN CONTRACT_LINE_RISK_FLAG , ContLines.SHIP_TO_ACCT_ID SHIP_TO_CUSTOMER_ID , ContLines.SHIP_INV_ORG_ID WAREHOUSE_BU_ID , ContLines.OBJECT1_ID1 INVENTORY_ITEM_ID FROM OKC_K_LINES_B ContLines, PJB_CLIN_INTERNAL_ATTRIBUTES ContIntAttrib, EGP_SYSTEM_ITEMS_B item WHERE ContLines.ID = ContIntAttrib.CONTRACT_LINE_ID(+) AND ContLines.VERSION_TYPE IN ('A','C') AND ContLines.STS_CODE IN ('ACTIVE','CLOSED','EXPIRED','HOLD') AND ContLines.OBJECT1_ID1 = Item.INVENTORY_ITEM_ID(+) AND ContLines.OBJECT1_ID2 = item.ORGANIZATION_ID(+) AND ( (ContLines.Major_Version= ContIntAttrib.Major_Version AND ContIntAttrib.Contract_line_id = ContLines.ID ) OR (ContIntAttrib.Contract_Line_Id IS NULL ) ) UNION ALL SELECT ContLines.ID CONTRACT_LINE_ID , ContLines.LINE_NUMBER CONTRACT_LINE_NUMBER , Item.SALES_ACCOUNT ITEM_SALES_ACCOUNT , ContIntAttrib.RECEIVER_PROJECT_ID CONT_LINE_RECEIVER_PROJECT_ID , ContIntAttrib.RECEIVER_TASK_ID CONT_LINE_RECEIVER_TASK_ID , ContLines.ATTRIBUTE_CATEGORY CONT_LINE_ATTRIBUTE_CATEGORY , ContLines.ATTRIBUTE1 CONTRACT_LINE_ATTRIBUTE1 , ContLines.ATTRIBUTE2 CONTRACT_LINE_ATTRIBUTE2 , ContLines.ATTRIBUTE3 CONTRACT_LINE_ATTRIBUTE3 , ContLines.ATTRIBUTE4 CONTRACT_LINE_ATTRIBUTE4 , ContLines.ATTRIBUTE5 CONTRACT_LINE_ATTRIBUTE5 , ContLines.ATTRIBUTE6 CONTRACT_LINE_ATTRIBUTE6 , ContLines.ATTRIBUTE7 CONTRACT_LINE_ATTRIBUTE7 , ContLines.ATTRIBUTE8 CONTRACT_LINE_ATTRIBUTE8 , ContLines.ATTRIBUTE9 CONTRACT_LINE_ATTRIBUTE9 , ContLines.ATTRIBUTE10 CONTRACT_LINE_ATTRIBUTE10 , ContLines.ATTRIBUTE11 CONTRACT_LINE_ATTRIBUTE11 , ContLines.ATTRIBUTE12 CONTRACT_LINE_ATTRIBUTE12 , ContLines.ATTRIBUTE13 CONTRACT_LINE_ATTRIBUTE13 , ContLines.ATTRIBUTE14 CONTRACT_LINE_ATTRIBUTE14 , ContLines.ATTRIBUTE15 CONTRACT_LINE_ATTRIBUTE15 , ContLines.ATTRIBUTE16 CONTRACT_LINE_ATTRIBUTE16 , ContLines.ATTRIBUTE17 CONTRACT_LINE_ATTRIBUTE17 , ContLines.ATTRIBUTE18 CONTRACT_LINE_ATTRIBUTE18 , ContLines.ATTRIBUTE19 CONTRACT_LINE_ATTRIBUTE19 , ContLines.ATTRIBUTE20 CONTRACT_LINE_ATTRIBUTE20 , ContLines.ATTRIBUTE21 CONTRACT_LINE_ATTRIBUTE21 , ContLines.ATTRIBUTE22 CONTRACT_LINE_ATTRIBUTE22 , ContLines.ATTRIBUTE23 CONTRACT_LINE_ATTRIBUTE23 , ContLines.ATTRIBUTE24 CONTRACT_LINE_ATTRIBUTE24 , ContLines.ATTRIBUTE25 CONTRACT_LINE_ATTRIBUTE25 , ContLines.ATTRIBUTE26 CONTRACT_LINE_ATTRIBUTE26 , ContLines.ATTRIBUTE27 CONTRACT_LINE_ATTRIBUTE27 , ContLines.ATTRIBUTE28 CONTRACT_LINE_ATTRIBUTE28 , ContLines.ATTRIBUTE29 CONTRACT_LINE_ATTRIBUTE29 , ContLines.ATTRIBUTE30 CONTRACT_LINE_ATTRIBUTE30 , ContLines.CUST_PO_NUMBER CON_LINE_CUST_PO_NUMBER , ContLines.AT_RISK_YN CONTRACT_LINE_RISK_FLAG , ContLines.SHIP_TO_ACCT_ID SHIP_TO_CUSTOMER_ID , ContLines.SHIP_INV_ORG_ID WAREHOUSE_BU_ID , ContLines.OBJECT1_ID1 INVENTORY_ITEM_ID FROM OKC_K_LINES_B ContLines, EGP_SYSTEM_ITEMS_B item, PJB_CLIN_INTERNAL_ATTRIBUTES ContIntAttrib, OKC_K_HEADERS_ALL_B ContHead, OKC_BU_IMPL_OPTIONS_ALL BU WHERE ContLines.VERSION_TYPE ='C' AND ContLines.STS_CODE IN ('UNDER_AMENDMENT' ,'CLOSED') AND ContLines.OBJECT1_ID1 = Item.INVENTORY_ITEM_ID(+) AND ContLines.OBJECT1_ID2 = item.ORGANIZATION_ID(+) AND BU.ORG_ID= ContHead.Org_id AND bu.attribute15= 'INCLUDE_UNDER_AMENDMENT' AND ContHead.ID = ContLines.DNZ_CHR_ID AND ContHead.Major_Version= ContLines.Major_Version AND ContHead.under_amend_version_flag='N' AND ContHead.Version_type='C' AND ContHead.STS_CODE ='UNDER_AMENDMENT' AND ContLines.ID = ContIntAttrib.CONTRACT_LINE_ID(+) AND ( (ContLines.Major_Version= ContIntAttrib.Major_Version AND ContIntAttrib.Contract_line_id = ContLines.ID ) OR (ContIntAttrib.Contract_Line_Id IS NULL ) )