View: CS_CUSTOMER_PRODUCTS_MAINT_V

View Text

SELECT CP.ROWID ROW_ID
, HZA.ACCOUNT_NUMBER
, HZP.PARTY_NAME
, CP.CUSTOMER_PRODUCT_ID
, CP.LAST_UPDATE_DATE
, CP.LAST_UPDATED_BY
, CP.CREATION_DATE
, CP.CREATED_BY
, CP.LAST_UPDATE_LOGIN
, CP.CUSTOMER_ID
, CP.INVENTORY_ITEM_ID
, CP.CREATED_MANUALLY_FLAG
, CP.MOST_RECENT_FLAG
, CP.CURRENT_CP_REVISION_ID
, CP.CURRENT_SERIAL_NUMBER
, CP.TYPE_CODE
, CP.SYSTEM_ID
, CP.INSTALLATION_DATE
, CP.ORIGINAL_ORDER_LINE_ID
, OOH.ORDERED_DATE
, OOH.ORDER_NUMBER
, OOL.LINE_NUMBER
, OOL.LINK_TO_LINE_ID
, CP.ORIGINAL_LINE_SERV_DETAIL_ID
, OOL.UNIT_SELLING_PRICE
, OOH.PRICE_LIST_ID
, CP.SHIP_TO_SITE_USE_ID
, CP.BILL_TO_SITE_USE_ID
, CP.INSTALL_SITE_USE_ID
, CP.QUANTITY
, CP.SHIPPED_FLAG
, CP.DELIVERED_FLAG
, CP.UNIT_OF_MEASURE_CODE
, CP.PARENT_CP_ID
, CP.START_DATE_ACTIVE
, CP.END_DATE_ACTIVE
, CP.ATTRIBUTE1
, CP.ATTRIBUTE2
, CP.ATTRIBUTE3
, CP.ATTRIBUTE4
, CP.ATTRIBUTE5
, CP.ATTRIBUTE6
, CP.ATTRIBUTE7
, CP.ATTRIBUTE8
, CP.ATTRIBUTE9
, CP.ATTRIBUTE10
, CP.CONTEXT
, CP.CUSTOMER_PRODUCT_STATUS_ID
, CP.ATTRIBUTE11
, CP.ATTRIBUTE12
, CP.ATTRIBUTE13
, CP.ATTRIBUTE14
, CP.ATTRIBUTE15
, CP.SHIPPED_DATE
, CP.ORG_ID
, CP.REFERENCE_NUMBER
, OOH.CUST_PO_NUMBER
, CP.LOT_NUMBER
, CP.SPLIT_FLAG
, CPS.NAME CP_STATUS
, CPS.CANCELLED_FLAG
, CPS.TERMINATED_FLAG
, CPS.STATUS_CHANGE_ALLOWED_FLAG
, CPS.INCIDENT_ALLOWED_FLAG
, CPS.SERVICE_ORDER_ALLOWED_FLAG
, S.NAME SYSTEM
, L.MEANING CP_TYPE
, A1.NAME PRODUCT_AGREEMENT
, CP.PRODUCT_AGREEMENT_ID
, R.REVISION
, SI.SERIAL_NUMBER_CONTROL_CODE
, SI.DESCRIPTION PRODUCT_DESCRIPTION
, NULL SERVICED_STATUS
, NULL SERVICED_STATUS_FLAG
, SI.BOM_ITEM_TYPE
, CP.RETURN_BY_DATE
, CP.ACTUAL_RETURNED_DATE
, CP.CONFIG_ENABLED_FLAG
, CP.CONFIG_START_DATE
, CP.CONFIG_END_DATE
, CP.CONFIG_ROOT_ID
, CP.CONFIG_PARENT_ID
, CP.CONFIG_TYPE
, L3.MEANING
, CP.RMA_LINE_ID
, CP.PROJECT_ID
, CP.TASK_ID
, CP.PLATFORM_VERSION_ID
, NULL PLATFORM_VERSION
, KFV.CONCATENATED_SEGMENTS
, CSXCUMPI_PUB.GET_PART_INFORMATION(CP.CONFIG_PARENT_ID)
, CSXCUMPI_PUB.GET_PART_INFORMATION(CP.CONFIG_ROOT_ID)
, CSXCUMPI_PUB.GET_CHILDREN_FLAG(CP.CUSTOMER_PRODUCT_ID)
, HZSITE1.PARTY_SITE_NAME
, HZPTY1.PARTY_ID
, HZPTY1.PARTY_NAME
, HZPTY1.PARTY_TYPE
, HZPTY1.PERSON_LAST_NAME
, HZPTY1.PERSON_FIRST_NAME
, HZLOC1.LOCATION_ID
, HZLOC1.DESCRIPTION
, HZLOC1.ADDRESS1
, HZLOC1.ADDRESS2
, HZLOC1.ADDRESS3
, HZLOC1.ADDRESS4
, HZSITE1.MAILSTOP
, HZLOC1.CITY
, HZLOC1.POSTAL_CODE
, HZLOC1.STATE
, HZLOC1.PROVINCE
, HZLOC1.COUNTY
, HZLOC1.COUNTRY
, HZSITE2.PARTY_SITE_NAME
, HZPTY2.PARTY_ID
, HZPTY2.PARTY_NAME
, HZPTY2.PARTY_TYPE
, HZPTY2.PERSON_LAST_NAME
, HZPTY2.PERSON_FIRST_NAME
, HZLOC2.LOCATION_ID
, HZLOC2.DESCRIPTION
, HZLOC2.ADDRESS1
, HZLOC2.ADDRESS2
, HZLOC2.ADDRESS3
, HZLOC2.ADDRESS4
, HZSITE2.MAILSTOP
, HZLOC2.CITY
, HZLOC2.POSTAL_CODE
, HZLOC2.STATE
, HZLOC2.PROVINCE
, HZLOC2.COUNTY
, HZLOC2.COUNTRY
, HZSITE3.PARTY_SITE_NAME
, HZPTY3.PARTY_ID
, HZPTY3.PARTY_NAME
, HZPTY3.PARTY_TYPE
, HZPTY3.PERSON_LAST_NAME
, HZPTY3.PERSON_FIRST_NAME
, HZLOC3.LOCATION_ID
, HZLOC3.DESCRIPTION
, HZLOC3.ADDRESS1
, HZLOC3.ADDRESS2
, HZLOC3.ADDRESS3
, HZLOC3.ADDRESS4
, HZSITE3.MAILSTOP
, HZLOC3.CITY
, HZLOC3.POSTAL_CODE
, HZLOC3.STATE
, HZLOC3.PROVINCE
, HZLOC3.COUNTY
, HZLOC3.COUNTRY
, OPER.NAME
, CP.MERCHANT_VIEW_FLAG
, CP.CUSTOMER_VIEW_FLAG
, CP.PRICING_ATTRIBUTE1
, CP.PRICING_ATTRIBUTE2
, CP.PRICING_ATTRIBUTE3
, CP.PRICING_ATTRIBUTE4
, CP.PRICING_ATTRIBUTE5
, CP.PRICING_ATTRIBUTE6
, CP.PRICING_ATTRIBUTE7
, CP.PRICING_ATTRIBUTE8
, CP.PRICING_ATTRIBUTE9
, CP.PRICING_ATTRIBUTE10
, CP.PRICING_ATTRIBUTE11
, CP.PRICING_ATTRIBUTE12
, CP.PRICING_ATTRIBUTE13
, CP.PRICING_ATTRIBUTE14
, CP.PRICING_ATTRIBUTE15
, CP.PRICING_ATTRIBUTE16
, CP.PRICING_ATTRIBUTE17
, CP.PRICING_ATTRIBUTE18
, CP.PRICING_ATTRIBUTE19
, CP.PRICING_ATTRIBUTE20
, CP.PRICING_ATTRIBUTE21
, CP.PRICING_ATTRIBUTE22
, CP.PRICING_ATTRIBUTE23
, CP.PRICING_ATTRIBUTE24
, CP.PRICING_ATTRIBUTE25
, CP.PRICING_ATTRIBUTE26
, CP.PRICING_ATTRIBUTE27
, CP.PRICING_ATTRIBUTE28
, CP.PRICING_ATTRIBUTE29
, CP.PRICING_ATTRIBUTE30
, CP.PRICING_ATTRIBUTE31
, CP.PRICING_ATTRIBUTE32
, CP.PRICING_ATTRIBUTE33
, CP.PRICING_ATTRIBUTE34
, CP.PRICING_ATTRIBUTE35
, CP.PRICING_ATTRIBUTE36
, CP.PRICING_ATTRIBUTE37
, CP.PRICING_ATTRIBUTE38
, CP.PRICING_ATTRIBUTE39
, CP.PRICING_ATTRIBUTE40
, CP.PRICING_ATTRIBUTE41
, CP.PRICING_ATTRIBUTE42
, CP.PRICING_ATTRIBUTE43
, CP.PRICING_ATTRIBUTE44
, CP.PRICING_ATTRIBUTE45
, CP.PRICING_ATTRIBUTE46
, CP.PRICING_ATTRIBUTE47
, CP.PRICING_ATTRIBUTE48
, CP.PRICING_ATTRIBUTE49
, CP.PRICING_ATTRIBUTE50
, CP.PRICING_ATTRIBUTE51
, CP.PRICING_ATTRIBUTE52
, CP.PRICING_ATTRIBUTE53
, CP.PRICING_ATTRIBUTE54
, CP.PRICING_ATTRIBUTE55
, CP.PRICING_ATTRIBUTE56
, CP.PRICING_ATTRIBUTE57
, CP.PRICING_ATTRIBUTE58
, CP.PRICING_ATTRIBUTE59
, CP.PRICING_ATTRIBUTE60
, CP.PRICING_ATTRIBUTE61
, CP.PRICING_ATTRIBUTE62
, CP.PRICING_ATTRIBUTE63
, CP.PRICING_ATTRIBUTE64
, CP.PRICING_ATTRIBUTE65
, CP.PRICING_ATTRIBUTE66
, CP.PRICING_ATTRIBUTE67
, CP.PRICING_ATTRIBUTE68
, CP.PRICING_ATTRIBUTE69
, CP.PRICING_ATTRIBUTE70
, CP.PRICING_ATTRIBUTE71
, CP.PRICING_ATTRIBUTE72
, CP.PRICING_ATTRIBUTE73
, CP.PRICING_ATTRIBUTE74
, CP.PRICING_ATTRIBUTE75
, CP.PRICING_ATTRIBUTE76
, CP.PRICING_ATTRIBUTE77
, CP.PRICING_ATTRIBUTE78
, CP.PRICING_ATTRIBUTE79
, CP.PRICING_ATTRIBUTE80
, CP.PRICING_ATTRIBUTE81
, CP.PRICING_ATTRIBUTE82
, CP.PRICING_ATTRIBUTE83
, CP.PRICING_ATTRIBUTE84
, CP.PRICING_ATTRIBUTE85
, CP.PRICING_ATTRIBUTE86
, CP.PRICING_ATTRIBUTE87
, CP.PRICING_ATTRIBUTE88
, CP.PRICING_ATTRIBUTE89
, CP.PRICING_ATTRIBUTE90
, CP.PRICING_ATTRIBUTE91
, CP.PRICING_ATTRIBUTE92
, CP.PRICING_ATTRIBUTE93
, CP.PRICING_ATTRIBUTE94
, CP.PRICING_ATTRIBUTE95
, CP.PRICING_ATTRIBUTE96
, CP.PRICING_ATTRIBUTE97
, CP.PRICING_ATTRIBUTE98
, CP.PRICING_ATTRIBUTE99
, CP.PRICING_ATTRIBUTE100
, CP.PRICING_CONTEXT
FROM OE_AGREEMENTS A1
, HZ_CUST_ACCOUNTS HZA
, HZ_PARTIES HZP
, HZ_PARTY_SITES HZSITE1
, HZ_LOCATIONS HZLOC1
, HZ_PARTIES HZPTY1
, HZ_PARTY_SITES HZSITE2
, HZ_LOCATIONS HZLOC2
, HZ_PARTIES HZPTY2
, HZ_CUST_ACCT_SITES_ALL HZACCTSITE3
, HZ_PARTY_SITES HZSITE3
, HZ_LOCATIONS HZLOC3
, HZ_PARTIES HZPTY3
, CS_LOOKUPS L
, CS_LOOKUPS L3
, CS_CUSTOMER_PRODUCT_STATUSES CPS
, CS_CP_REVISIONS R
, CS_SYSTEMS S
, MTL_SYSTEM_ITEMS SI
, MTL_SYSTEM_ITEMS_KFV KFV
, ASO_I_OE_ORDER_HEADERS_V OOH
, ASO_I_OE_ORDER_LINES_V OOL
, HR_OPERATING_UNITS OPER
, CS_CUSTOMER_PRODUCTS_ALL CP
WHERE CP.SYSTEM_ID = S.SYSTEM_ID(+)
AND CP.TYPE_CODE = L.LOOKUP_CODE(+)
AND L.LOOKUP_TYPE(+) = 'CUSTOMER_PRODUCT_TYPE'
AND CP.PRODUCT_AGREEMENT_ID = A1.AGREEMENT_ID(+)
AND CP.CUSTOMER_PRODUCT_ID = R.CUSTOMER_PRODUCT_ID
AND CP.CURRENT_CP_REVISION_ID = R.CP_REVISION_ID
AND CP.CUSTOMER_PRODUCT_STATUS_ID = CPS.CUSTOMER_PRODUCT_STATUS_ID
AND CP.INVENTORY_ITEM_ID = SI.INVENTORY_ITEM_ID
AND SI.ORGANIZATION_ID = ( SELECT CS_STD.GET_ITEM_VALDN_ORGZN_ID
FROM DUAL )
AND CP.INVENTORY_ITEM_ID = KFV.INVENTORY_ITEM_ID
AND KFV.ORGANIZATION_ID = ( SELECT CS_STD.GET_ITEM_VALDN_ORGZN_ID
FROM DUAL )
AND CP.CONFIG_TYPE = L3.LOOKUP_CODE(+)
AND L3.LOOKUP_TYPE(+) = 'CS_IB_CONFIG_MANAGEMENT_TYPE'
AND CP.ORIGINAL_ORDER_LINE_ID = OOL.LINE_ID(+)
AND OOL.HEADER_ID = OOH.HEADER_ID(+)
AND CP.CUSTOMER_ID = HZA.CUST_ACCOUNT_ID
AND HZA.PARTY_ID = HZP.PARTY_ID
AND CP.SHIP_TO_SITE_USE_ID = HZSITE1.PARTY_SITE_ID(+)
AND HZSITE1.LOCATION_ID = HZLOC1.LOCATION_ID(+)
AND HZSITE1.PARTY_ID = HZPTY1.PARTY_ID(+)
AND CP.INSTALL_SITE_USE_ID = HZSITE2.PARTY_SITE_ID(+)
AND HZSITE2.LOCATION_ID = HZLOC2.LOCATION_ID(+)
AND HZSITE2.PARTY_ID = HZPTY2.PARTY_ID(+)
AND CP.BILL_TO_SITE_USE_ID = HZACCTSITE3.CUST_ACCT_SITE_ID(+)
AND HZACCTSITE3.PARTY_SITE_ID = HZSITE3.PARTY_SITE_ID(+)
AND HZSITE3.LOCATION_ID = HZLOC3.LOCATION_ID(+)
AND HZSITE3.PARTY_ID = HZPTY3.PARTY_ID(+)
AND CP.ORG_ID = OPER.ORGANIZATION_ID(+)

Columns