View: CSI_CP_FORM_PROD_V

Product:	CSI - Install Base
Description:	Backward Compatible : Customer Product Form Product details.
Implementation/DBA Data:	APPS.CSI_CP_FORM_PROD_V

View Text

SELECT CII.ROWID ROW_ID
, CII.INSTANCE_ID
, CII.OBJECT_VERSION_NUMBER
, CIP.INSTANCE_PARTY_ID
, CIP.OBJECT_VERSION_NUMBER
, CIA.IP_ACCOUNT_ID
, CIA.OBJECT_VERSION_NUMBER
, CIPA.PRICING_ATTRIBUTE_ID
, CIPA.OBJECT_VERSION_NUMBER
, CIOA.INSTANCE_OU_ID
, MSIK.DESCRIPTION
, MSIK.CONCATENATED_SEGMENTS
, CIA.PARTY_ACCOUNT_ID
, CII.UNIT_OF_MEASURE
, CII.QUANTITY
, CII.INSTANCE_NUMBER
, CSV.NAME
, CSV.SYSTEM_ID
, CII.INVENTORY_REVISION
, CII.INSTALL_DATE
, OOL.ACTUAL_SHIPMENT_DATE
, CII.LOT_NUMBER
, CII.SERIAL_NUMBER
, NULL
, CII.RETURN_BY_DATE
, CII.ACTUAL_RETURN_DATE
, CIS.NAME
, CII.INSTANCE_TYPE_CODE
, OA.NAME PRODUCT_AGREEMENT
, CII.LAST_OE_AGREEMENT_ID
, NULL
, DECODE(OOL.ACTUAL_SHIPMENT_DATE
, NULL
, 'N'
, 'Y')
, NULL
, CII.CUSTOMER_VIEW_FLAG
, CII.MERCHANT_VIEW_FLAG
, CII.PA_PROJECT_ID
, CII.PA_PROJECT_TASK_ID
, CII.ACTIVE_START_DATE
, CII.ACTIVE_END_DATE
, CII.ATTRIBUTE1
, CII.ATTRIBUTE2
, CII.ATTRIBUTE3
, CII.ATTRIBUTE4
, CII.ATTRIBUTE5
, CII.ATTRIBUTE6
, CII.ATTRIBUTE7
, CII.ATTRIBUTE8
, CII.ATTRIBUTE9
, CII.ATTRIBUTE10
, CII.ATTRIBUTE11
, CII.ATTRIBUTE12
, CII.ATTRIBUTE13
, CII.ATTRIBUTE14
, CII.ATTRIBUTE15
, CII.CONTEXT
, OOH.ORDER_NUMBER
, OOL.CREATION_DATE
, OOL.LINE_NUMBER
, CII.LAST_OE_ORDER_LINE_ID
, OOL.CUST_PO_NUMBER
, OOH.TRANSACTIONAL_CURR_CODE
, OOL.UNIT_SELLING_PRICE
, CII.INVENTORY_ITEM_ID
, CII.MANUALLY_CREATED_FLAG
, 'Y' MOST_RECENT_FLAG
, OOL.LINK_TO_LINE_ID ORIGINAL_LINK_TO_ORDER_LINE_ID
, NULL ORIGINAL_LINE_SERV_DETAIL_ID
, OOH.PRICE_LIST_ID
, CIOA.OPERATING_UNIT_ID ORG_ID
, CIS.STATUS_CHANGE_ALLOWED_FLAG
, CIS.INCIDENT_ALLOWED_FLAG
, CIS.SERVICE_ORDER_ALLOWED_FLAG
, MSI.BOM_ITEM_TYPE BOM_TYPE_ID
, NULL RMA_LINE_ID
, CIS.INSTANCE_STATUS_ID
, MSI.SERIAL_NUMBER_CONTROL_CODE
, HZP.PARTY_NAME
, HZP.PARTY_ID
, HZCA.ACCOUNT_NUMBER
, DECODE(NVL(CII.MANUALLY_CREATED_FLAG
, 'N')
, 'Y'
, CIPA.PRICING_ATTRIBUTE1
, OOPA.PRICING_ATTRIBUTE1) PRICING_ATTRIBUTE1
, DECODE(NVL(CII.MANUALLY_CREATED_FLAG
, 'N')
, 'Y'
, CIPA.PRICING_ATTRIBUTE2
, OOPA.PRICING_ATTRIBUTE2) PRICING_ATTRIBUTE2
, DECODE(NVL(CII.MANUALLY_CREATED_FLAG
, 'N')
, 'Y'
, CIPA.PRICING_ATTRIBUTE3
, OOPA.PRICING_ATTRIBUTE3) PRICING_ATTRIBUTE3
, DECODE(NVL(CII.MANUALLY_CREATED_FLAG
, 'N')
, 'Y'
, CIPA.PRICING_ATTRIBUTE4
, OOPA.PRICING_ATTRIBUTE4) PRICING_ATTRIBUTE4
, DECODE(NVL(CII.MANUALLY_CREATED_FLAG
, 'N')
, 'Y'
, CIPA.PRICING_ATTRIBUTE5
, OOPA.PRICING_ATTRIBUTE5) PRICING_ATTRIBUTE5
, DECODE(NVL(CII.MANUALLY_CREATED_FLAG
, 'N')
, 'Y'
, CIPA.PRICING_ATTRIBUTE6
, OOPA.PRICING_ATTRIBUTE6) PRICING_ATTRIBUTE6
, DECODE(NVL(CII.MANUALLY_CREATED_FLAG
, 'N')
, 'Y'
, CIPA.PRICING_ATTRIBUTE7
, OOPA.PRICING_ATTRIBUTE7) PRICING_ATTRIBUTE7
, DECODE(NVL(CII.MANUALLY_CREATED_FLAG
, 'N')
, 'Y'
, CIPA.PRICING_ATTRIBUTE8
, OOPA.PRICING_ATTRIBUTE8) PRICING_ATTRIBUTE8
, DECODE(NVL(CII.MANUALLY_CREATED_FLAG
, 'N')
, 'Y'
, CIPA.PRICING_ATTRIBUTE9
, OOPA.PRICING_ATTRIBUTE9) PRICING_ATTRIBUTE9
, DECODE(NVL(CII.MANUALLY_CREATED_FLAG
, 'N')
, 'Y'
, CIPA.PRICING_ATTRIBUTE10
, OOPA.PRICING_ATTRIBUTE10) PRICING_ATTRIBUTE10
, DECODE(NVL(CII.MANUALLY_CREATED_FLAG
, 'N')
, 'Y'
, CIPA.PRICING_ATTRIBUTE11
, OOPA.PRICING_ATTRIBUTE11) PRICING_ATTRIBUTE11
, DECODE(NVL(CII.MANUALLY_CREATED_FLAG
, 'N')
, 'Y'
, CIPA.PRICING_ATTRIBUTE12
, OOPA.PRICING_ATTRIBUTE12) PRICING_ATTRIBUTE12
, DECODE(NVL(CII.MANUALLY_CREATED_FLAG
, 'N')
, 'Y'
, CIPA.PRICING_ATTRIBUTE13
, OOPA.PRICING_ATTRIBUTE13) PRICING_ATTRIBUTE13
, DECODE(NVL(CII.MANUALLY_CREATED_FLAG
, 'N')
, 'Y'
, CIPA.PRICING_ATTRIBUTE14
, OOPA.PRICING_ATTRIBUTE14) PRICING_ATTRIBUTE14
, DECODE(NVL(CII.MANUALLY_CREATED_FLAG
, 'N')
, 'Y'
, CIPA.PRICING_ATTRIBUTE15
, OOPA.PRICING_ATTRIBUTE15) PRICING_ATTRIBUTE15
, DECODE(NVL(CII.MANUALLY_CREATED_FLAG
, 'N')
, 'Y'
, CIPA.PRICING_ATTRIBUTE16
, OOPA.PRICING_ATTRIBUTE16) PRICING_ATTRIBUTE16
, DECODE(NVL(CII.MANUALLY_CREATED_FLAG
, 'N')
, 'Y'
, CIPA.PRICING_ATTRIBUTE17
, OOPA.PRICING_ATTRIBUTE17) PRICING_ATTRIBUTE17
, DECODE(NVL(CII.MANUALLY_CREATED_FLAG
, 'N')
, 'Y'
, CIPA.PRICING_ATTRIBUTE18
, OOPA.PRICING_ATTRIBUTE18) PRICING_ATTRIBUTE18
, DECODE(NVL(CII.MANUALLY_CREATED_FLAG
, 'N')
, 'Y'
, CIPA.PRICING_ATTRIBUTE19
, OOPA.PRICING_ATTRIBUTE19) PRICING_ATTRIBUTE19
, DECODE(NVL(CII.MANUALLY_CREATED_FLAG
, 'N')
, 'Y'
, CIPA.PRICING_ATTRIBUTE20
, OOPA.PRICING_ATTRIBUTE20) PRICING_ATTRIBUTE20
, DECODE(NVL(CII.MANUALLY_CREATED_FLAG
, 'N')
, 'Y'
, CIPA.PRICING_ATTRIBUTE21
, OOPA.PRICING_ATTRIBUTE21) PRICING_ATTRIBUTE21
, DECODE(NVL(CII.MANUALLY_CREATED_FLAG
, 'N')
, 'Y'
, CIPA.PRICING_ATTRIBUTE22
, OOPA.PRICING_ATTRIBUTE22) PRICING_ATTRIBUTE22
, DECODE(NVL(CII.MANUALLY_CREATED_FLAG
, 'N')
, 'Y'
, CIPA.PRICING_ATTRIBUTE23
, OOPA.PRICING_ATTRIBUTE23) PRICING_ATTRIBUTE23
, DECODE(NVL(CII.MANUALLY_CREATED_FLAG
, 'N')
, 'Y'
, CIPA.PRICING_ATTRIBUTE24
, OOPA.PRICING_ATTRIBUTE24) PRICING_ATTRIBUTE24
, DECODE(NVL(CII.MANUALLY_CREATED_FLAG
, 'N')
, 'Y'
, CIPA.PRICING_ATTRIBUTE25
, OOPA.PRICING_ATTRIBUTE25) PRICING_ATTRIBUTE25
, DECODE(NVL(CII.MANUALLY_CREATED_FLAG
, 'N')
, 'Y'
, CIPA.PRICING_ATTRIBUTE26
, OOPA.PRICING_ATTRIBUTE26) PRICING_ATTRIBUTE26
, DECODE(NVL(CII.MANUALLY_CREATED_FLAG
, 'N')
, 'Y'
, CIPA.PRICING_ATTRIBUTE27
, OOPA.PRICING_ATTRIBUTE27) PRICING_ATTRIBUTE27
, DECODE(NVL(CII.MANUALLY_CREATED_FLAG
, 'N')
, 'Y'
, CIPA.PRICING_ATTRIBUTE28
, OOPA.PRICING_ATTRIBUTE28) PRICING_ATTRIBUTE28
, DECODE(NVL(CII.MANUALLY_CREATED_FLAG
, 'N')
, 'Y'
, CIPA.PRICING_ATTRIBUTE29
, OOPA.PRICING_ATTRIBUTE29) PRICING_ATTRIBUTE29
, DECODE(NVL(CII.MANUALLY_CREATED_FLAG
, 'N')
, 'Y'
, CIPA.PRICING_ATTRIBUTE30
, OOPA.PRICING_ATTRIBUTE30) PRICING_ATTRIBUTE30
, DECODE(NVL(CII.MANUALLY_CREATED_FLAG
, 'N')
, 'Y'
, CIPA.PRICING_ATTRIBUTE31
, OOPA.PRICING_ATTRIBUTE31) PRICING_ATTRIBUTE31
, DECODE(NVL(CII.MANUALLY_CREATED_FLAG
, 'N')
, 'Y'
, CIPA.PRICING_ATTRIBUTE32
, OOPA.PRICING_ATTRIBUTE32) PRICING_ATTRIBUTE32
, DECODE(NVL(CII.MANUALLY_CREATED_FLAG
, 'N')
, 'Y'
, CIPA.PRICING_ATTRIBUTE33
, OOPA.PRICING_ATTRIBUTE33) PRICING_ATTRIBUTE33
, DECODE(NVL(CII.MANUALLY_CREATED_FLAG
, 'N')
, 'Y'
, CIPA.PRICING_ATTRIBUTE34
, OOPA.PRICING_ATTRIBUTE34) PRICING_ATTRIBUTE34
, DECODE(NVL(CII.MANUALLY_CREATED_FLAG
, 'N')
, 'Y'
, CIPA.PRICING_ATTRIBUTE35
, OOPA.PRICING_ATTRIBUTE35) PRICING_ATTRIBUTE35
, DECODE(NVL(CII.MANUALLY_CREATED_FLAG
, 'N')
, 'Y'
, CIPA.PRICING_ATTRIBUTE36
, OOPA.PRICING_ATTRIBUTE36) PRICING_ATTRIBUTE36
, DECODE(NVL(CII.MANUALLY_CREATED_FLAG
, 'N')
, 'Y'
, CIPA.PRICING_ATTRIBUTE37
, OOPA.PRICING_ATTRIBUTE37) PRICING_ATTRIBUTE37
, DECODE(NVL(CII.MANUALLY_CREATED_FLAG
, 'N')
, 'Y'
, CIPA.PRICING_ATTRIBUTE38
, OOPA.PRICING_ATTRIBUTE38) PRICING_ATTRIBUTE38
, DECODE(NVL(CII.MANUALLY_CREATED_FLAG
, 'N')
, 'Y'
, CIPA.PRICING_ATTRIBUTE39
, OOPA.PRICING_ATTRIBUTE39) PRICING_ATTRIBUTE39
, DECODE(NVL(CII.MANUALLY_CREATED_FLAG
, 'N')
, 'Y'
, CIPA.PRICING_ATTRIBUTE40
, OOPA.PRICING_ATTRIBUTE40) PRICING_ATTRIBUTE40
, DECODE(NVL(CII.MANUALLY_CREATED_FLAG
, 'N')
, 'Y'
, CIPA.PRICING_ATTRIBUTE41
, OOPA.PRICING_ATTRIBUTE41) PRICING_ATTRIBUTE41
, DECODE(NVL(CII.MANUALLY_CREATED_FLAG
, 'N')
, 'Y'
, CIPA.PRICING_ATTRIBUTE42
, OOPA.PRICING_ATTRIBUTE42) PRICING_ATTRIBUTE42
, DECODE(NVL(CII.MANUALLY_CREATED_FLAG
, 'N')
, 'Y'
, CIPA.PRICING_ATTRIBUTE43
, OOPA.PRICING_ATTRIBUTE43) PRICING_ATTRIBUTE43
, DECODE(NVL(CII.MANUALLY_CREATED_FLAG
, 'N')
, 'Y'
, CIPA.PRICING_ATTRIBUTE44
, OOPA.PRICING_ATTRIBUTE44) PRICING_ATTRIBUTE44
, DECODE(NVL(CII.MANUALLY_CREATED_FLAG
, 'N')
, 'Y'
, CIPA.PRICING_ATTRIBUTE45
, OOPA.PRICING_ATTRIBUTE45) PRICING_ATTRIBUTE45
, DECODE(NVL(CII.MANUALLY_CREATED_FLAG
, 'N')
, 'Y'
, CIPA.PRICING_ATTRIBUTE46
, OOPA.PRICING_ATTRIBUTE46) PRICING_ATTRIBUTE46
, DECODE(NVL(CII.MANUALLY_CREATED_FLAG
, 'N')
, 'Y'
, CIPA.PRICING_ATTRIBUTE47
, OOPA.PRICING_ATTRIBUTE47) PRICING_ATTRIBUTE47
, DECODE(NVL(CII.MANUALLY_CREATED_FLAG
, 'N')
, 'Y'
, CIPA.PRICING_ATTRIBUTE48
, OOPA.PRICING_ATTRIBUTE48) PRICING_ATTRIBUTE48
, DECODE(NVL(CII.MANUALLY_CREATED_FLAG
, 'N')
, 'Y'
, CIPA.PRICING_ATTRIBUTE49
, OOPA.PRICING_ATTRIBUTE49) PRICING_ATTRIBUTE49
, DECODE(NVL(CII.MANUALLY_CREATED_FLAG
, 'N')
, 'Y'
, CIPA.PRICING_ATTRIBUTE50
, OOPA.PRICING_ATTRIBUTE50) PRICING_ATTRIBUTE50
, DECODE(NVL(CII.MANUALLY_CREATED_FLAG
, 'N')
, 'Y'
, CIPA.PRICING_ATTRIBUTE51
, OOPA.PRICING_ATTRIBUTE51) PRICING_ATTRIBUTE51
, DECODE(NVL(CII.MANUALLY_CREATED_FLAG
, 'N')
, 'Y'
, CIPA.PRICING_ATTRIBUTE52
, OOPA.PRICING_ATTRIBUTE52) PRICING_ATTRIBUTE52
, DECODE(NVL(CII.MANUALLY_CREATED_FLAG
, 'N')
, 'Y'
, CIPA.PRICING_ATTRIBUTE53
, OOPA.PRICING_ATTRIBUTE53) PRICING_ATTRIBUTE53
, DECODE(NVL(CII.MANUALLY_CREATED_FLAG
, 'N')
, 'Y'
, CIPA.PRICING_ATTRIBUTE54
, OOPA.PRICING_ATTRIBUTE54) PRICING_ATTRIBUTE54
, DECODE(NVL(CII.MANUALLY_CREATED_FLAG
, 'N')
, 'Y'
, CIPA.PRICING_ATTRIBUTE55
, OOPA.PRICING_ATTRIBUTE55) PRICING_ATTRIBUTE55
, DECODE(NVL(CII.MANUALLY_CREATED_FLAG
, 'N')
, 'Y'
, CIPA.PRICING_ATTRIBUTE56
, OOPA.PRICING_ATTRIBUTE56) PRICING_ATTRIBUTE56
, DECODE(NVL(CII.MANUALLY_CREATED_FLAG
, 'N')
, 'Y'
, CIPA.PRICING_ATTRIBUTE57
, OOPA.PRICING_ATTRIBUTE57) PRICING_ATTRIBUTE57
, DECODE(NVL(CII.MANUALLY_CREATED_FLAG
, 'N')
, 'Y'
, CIPA.PRICING_ATTRIBUTE58
, OOPA.PRICING_ATTRIBUTE58) PRICING_ATTRIBUTE58
, DECODE(NVL(CII.MANUALLY_CREATED_FLAG
, 'N')
, 'Y'
, CIPA.PRICING_ATTRIBUTE59
, OOPA.PRICING_ATTRIBUTE59) PRICING_ATTRIBUTE59
, DECODE(NVL(CII.MANUALLY_CREATED_FLAG
, 'N')
, 'Y'
, CIPA.PRICING_ATTRIBUTE60
, OOPA.PRICING_ATTRIBUTE60) PRICING_ATTRIBUTE60
, DECODE(NVL(CII.MANUALLY_CREATED_FLAG
, 'N')
, 'Y'
, CIPA.PRICING_ATTRIBUTE61
, OOPA.PRICING_ATTRIBUTE61) PRICING_ATTRIBUTE61
, DECODE(NVL(CII.MANUALLY_CREATED_FLAG
, 'N')
, 'Y'
, CIPA.PRICING_ATTRIBUTE62
, OOPA.PRICING_ATTRIBUTE62) PRICING_ATTRIBUTE62
, DECODE(NVL(CII.MANUALLY_CREATED_FLAG
, 'N')
, 'Y'
, CIPA.PRICING_ATTRIBUTE63
, OOPA.PRICING_ATTRIBUTE63) PRICING_ATTRIBUTE63
, DECODE(NVL(CII.MANUALLY_CREATED_FLAG
, 'N')
, 'Y'
, CIPA.PRICING_ATTRIBUTE64
, OOPA.PRICING_ATTRIBUTE64) PRICING_ATTRIBUTE64
, DECODE(NVL(CII.MANUALLY_CREATED_FLAG
, 'N')
, 'Y'
, CIPA.PRICING_ATTRIBUTE65
, OOPA.PRICING_ATTRIBUTE65) PRICING_ATTRIBUTE65
, DECODE(NVL(CII.MANUALLY_CREATED_FLAG
, 'N')
, 'Y'
, CIPA.PRICING_ATTRIBUTE66
, OOPA.PRICING_ATTRIBUTE66) PRICING_ATTRIBUTE66
, DECODE(NVL(CII.MANUALLY_CREATED_FLAG
, 'N')
, 'Y'
, CIPA.PRICING_ATTRIBUTE67
, OOPA.PRICING_ATTRIBUTE67) PRICING_ATTRIBUTE67
, DECODE(NVL(CII.MANUALLY_CREATED_FLAG
, 'N')
, 'Y'
, CIPA.PRICING_ATTRIBUTE68
, OOPA.PRICING_ATTRIBUTE68) PRICING_ATTRIBUTE68
, DECODE(NVL(CII.MANUALLY_CREATED_FLAG
, 'N')
, 'Y'
, CIPA.PRICING_ATTRIBUTE69
, OOPA.PRICING_ATTRIBUTE69) PRICING_ATTRIBUTE69
, DECODE(NVL(CII.MANUALLY_CREATED_FLAG
, 'N')
, 'Y'
, CIPA.PRICING_ATTRIBUTE70
, OOPA.PRICING_ATTRIBUTE70) PRICING_ATTRIBUTE70
, DECODE(NVL(CII.MANUALLY_CREATED_FLAG
, 'N')
, 'Y'
, CIPA.PRICING_ATTRIBUTE71
, OOPA.PRICING_ATTRIBUTE71) PRICING_ATTRIBUTE71
, DECODE(NVL(CII.MANUALLY_CREATED_FLAG
, 'N')
, 'Y'
, CIPA.PRICING_ATTRIBUTE72
, OOPA.PRICING_ATTRIBUTE72) PRICING_ATTRIBUTE72
, DECODE(NVL(CII.MANUALLY_CREATED_FLAG
, 'N')
, 'Y'
, CIPA.PRICING_ATTRIBUTE73
, OOPA.PRICING_ATTRIBUTE73) PRICING_ATTRIBUTE73
, DECODE(NVL(CII.MANUALLY_CREATED_FLAG
, 'N')
, 'Y'
, CIPA.PRICING_ATTRIBUTE74
, OOPA.PRICING_ATTRIBUTE74) PRICING_ATTRIBUTE74
, DECODE(NVL(CII.MANUALLY_CREATED_FLAG
, 'N')
, 'Y'
, CIPA.PRICING_ATTRIBUTE75
, OOPA.PRICING_ATTRIBUTE75) PRICING_ATTRIBUTE75
, DECODE(NVL(CII.MANUALLY_CREATED_FLAG
, 'N')
, 'Y'
, CIPA.PRICING_ATTRIBUTE76
, OOPA.PRICING_ATTRIBUTE76) PRICING_ATTRIBUTE76
, DECODE(NVL(CII.MANUALLY_CREATED_FLAG
, 'N')
, 'Y'
, CIPA.PRICING_ATTRIBUTE77
, OOPA.PRICING_ATTRIBUTE77) PRICING_ATTRIBUTE77
, DECODE(NVL(CII.MANUALLY_CREATED_FLAG
, 'N')
, 'Y'
, CIPA.PRICING_ATTRIBUTE78
, OOPA.PRICING_ATTRIBUTE78) PRICING_ATTRIBUTE78
, DECODE(NVL(CII.MANUALLY_CREATED_FLAG
, 'N')
, 'Y'
, CIPA.PRICING_ATTRIBUTE79
, OOPA.PRICING_ATTRIBUTE79) PRICING_ATTRIBUTE79
, DECODE(NVL(CII.MANUALLY_CREATED_FLAG
, 'N')
, 'Y'
, CIPA.PRICING_ATTRIBUTE80
, OOPA.PRICING_ATTRIBUTE80) PRICING_ATTRIBUTE80
, DECODE(NVL(CII.MANUALLY_CREATED_FLAG
, 'N')
, 'Y'
, CIPA.PRICING_ATTRIBUTE81
, OOPA.PRICING_ATTRIBUTE81) PRICING_ATTRIBUTE81
, DECODE(NVL(CII.MANUALLY_CREATED_FLAG
, 'N')
, 'Y'
, CIPA.PRICING_ATTRIBUTE82
, OOPA.PRICING_ATTRIBUTE82) PRICING_ATTRIBUTE82
, DECODE(NVL(CII.MANUALLY_CREATED_FLAG
, 'N')
, 'Y'
, CIPA.PRICING_ATTRIBUTE83
, OOPA.PRICING_ATTRIBUTE83) PRICING_ATTRIBUTE83
, DECODE(NVL(CII.MANUALLY_CREATED_FLAG
, 'N')
, 'Y'
, CIPA.PRICING_ATTRIBUTE84
, OOPA.PRICING_ATTRIBUTE84) PRICING_ATTRIBUTE84
, DECODE(NVL(CII.MANUALLY_CREATED_FLAG
, 'N')
, 'Y'
, CIPA.PRICING_ATTRIBUTE85
, OOPA.PRICING_ATTRIBUTE85) PRICING_ATTRIBUTE85
, DECODE(NVL(CII.MANUALLY_CREATED_FLAG
, 'N')
, 'Y'
, CIPA.PRICING_ATTRIBUTE86
, OOPA.PRICING_ATTRIBUTE86) PRICING_ATTRIBUTE86
, DECODE(NVL(CII.MANUALLY_CREATED_FLAG
, 'N')
, 'Y'
, CIPA.PRICING_ATTRIBUTE87
, OOPA.PRICING_ATTRIBUTE87) PRICING_ATTRIBUTE87
, DECODE(NVL(CII.MANUALLY_CREATED_FLAG
, 'N')
, 'Y'
, CIPA.PRICING_ATTRIBUTE88
, OOPA.PRICING_ATTRIBUTE88) PRICING_ATTRIBUTE88
, DECODE(NVL(CII.MANUALLY_CREATED_FLAG
, 'N')
, 'Y'
, CIPA.PRICING_ATTRIBUTE89
, OOPA.PRICING_ATTRIBUTE89) PRICING_ATTRIBUTE89
, DECODE(NVL(CII.MANUALLY_CREATED_FLAG
, 'N')
, 'Y'
, CIPA.PRICING_ATTRIBUTE90
, OOPA.PRICING_ATTRIBUTE90) PRICING_ATTRIBUTE90
, DECODE(NVL(CII.MANUALLY_CREATED_FLAG
, 'N')
, 'Y'
, CIPA.PRICING_ATTRIBUTE91
, OOPA.PRICING_ATTRIBUTE91) PRICING_ATTRIBUTE91
, DECODE(NVL(CII.MANUALLY_CREATED_FLAG
, 'N')
, 'Y'
, CIPA.PRICING_ATTRIBUTE92
, OOPA.PRICING_ATTRIBUTE92) PRICING_ATTRIBUTE92
, DECODE(NVL(CII.MANUALLY_CREATED_FLAG
, 'N')
, 'Y'
, CIPA.PRICING_ATTRIBUTE93
, OOPA.PRICING_ATTRIBUTE93) PRICING_ATTRIBUTE93
, DECODE(NVL(CII.MANUALLY_CREATED_FLAG
, 'N')
, 'Y'
, CIPA.PRICING_ATTRIBUTE94
, OOPA.PRICING_ATTRIBUTE94) PRICING_ATTRIBUTE94
, DECODE(NVL(CII.MANUALLY_CREATED_FLAG
, 'N')
, 'Y'
, CIPA.PRICING_ATTRIBUTE95
, OOPA.PRICING_ATTRIBUTE95) PRICING_ATTRIBUTE95
, DECODE(NVL(CII.MANUALLY_CREATED_FLAG
, 'N')
, 'Y'
, CIPA.PRICING_ATTRIBUTE96
, OOPA.PRICING_ATTRIBUTE96) PRICING_ATTRIBUTE96
, DECODE(NVL(CII.MANUALLY_CREATED_FLAG
, 'N')
, 'Y'
, CIPA.PRICING_ATTRIBUTE97
, OOPA.PRICING_ATTRIBUTE97) PRICING_ATTRIBUTE97
, DECODE(NVL(CII.MANUALLY_CREATED_FLAG
, 'N')
, 'Y'
, CIPA.PRICING_ATTRIBUTE98
, OOPA.PRICING_ATTRIBUTE98) PRICING_ATTRIBUTE98
, DECODE(NVL(CII.MANUALLY_CREATED_FLAG
, 'N')
, 'Y'
, CIPA.PRICING_ATTRIBUTE99
, OOPA.PRICING_ATTRIBUTE99) PRICING_ATTRIBUTE99
, DECODE(NVL(CII.MANUALLY_CREATED_FLAG
, 'N')
, 'Y'
, CIPA.PRICING_ATTRIBUTE100
, OOPA.PRICING_ATTRIBUTE100) PRICING_ATTRIBUTE100
, DECODE(NVL(CII.MANUALLY_CREATED_FLAG
, 'N')
, 'Y'
, CIPA.PRICING_CONTEXT
, OOPA.PRICING_CONTEXT) PRICING_CONTEXT
, CII.EXTERNAL_REFERENCE
FROM CSI_ITEM_INSTANCES CII
, CSI_INSTANCE_STATUSES CIS
, CSI_I_PRICING_ATTRIBS CIPA
, CSI_SYSTEMS_VL CSV
, CSI_I_PARTIES CIP
, CSI_IP_ACCOUNTS CIA
, CSI_I_ORG_ASSIGNMENTS CIOA
, OE_ORDER_HEADERS_ALL OOH
, OE_ORDER_LINES_ALL OOL
, OE_AGREEMENTS_VL OA
, OE_ORDER_PRICE_ATTRIBS OOPA
, MTL_SYSTEM_ITEMS_KFV MSIK
, MTL_SYSTEM_ITEMS MSI
, HZ_PARTIES HZP
, HZ_CUST_ACCOUNTS HZCA
WHERE CII.INSTANCE_STATUS_ID = CIS.INSTANCE_STATUS_ID AND CII.LAST_OE_ORDER_LINE_ID = OOL.LINE_ID(+) AND CII.SYSTEM_ID = CSV.SYSTEM_ID(+) AND CII.INSTANCE_ID = CIOA.INSTANCE_ID(+) AND CIOA.RELATIONSHIP_TYPE_CODE (+) = 'SOLD_FROM' AND HZCA.CUST_ACCOUNT_ID = CIA.PARTY_ACCOUNT_ID AND HZCA.PARTY_ID = HZP.PARTY_ID AND HZP.PARTY_ID = CIP.PARTY_ID AND MSIK.INVENTORY_ITEM_ID = CII.INVENTORY_ITEM_ID AND MSIK.ORGANIZATION_ID = CII.INV_MASTER_ORGANIZATION_ID AND MSIK.INVENTORY_ITEM_ID = MSI.INVENTORY_ITEM_ID AND MSIK.ORGANIZATION_ID = MSI.ORGANIZATION_ID AND OOL.HEADER_ID = OOH.HEADER_ID (+) AND CII.LAST_OE_AGREEMENT_ID = OA.AGREEMENT_ID(+) AND CII.LAST_OE_ORDER_LINE_ID = OOPA.LINE_ID(+) AND CII.INSTANCE_ID = CIPA.INSTANCE_ID (+) AND CII.INSTANCE_ID = CIP.INSTANCE_ID AND CIP.RELATIONSHIP_TYPE_CODE = 'OWNER' AND CIP.PARTY_SOURCE_TABLE = 'HZ_PARTIES' AND CIP.INSTANCE_PARTY_ID = CIA.INSTANCE_PARTY_ID (+) AND CIA.RELATIONSHIP_TYPE_CODE(+) = 'OWNER' AND CIA.ACTIVE_END_DATE (+) IS NULL AND NOT EXISTS ( SELECT 1 FROM CSI_INSTALL_PARAMETERS CIPM WHERE CIPM.INTERNAL_PARTY_ID = CIP.PARTY_ID )
AND (OOPA.ORDER_PRICE_ATTRIB_ID IS NULL OR OOPA.ORDER_PRICE_ATTRIB_ID = ( SELECT MIN(ORDER_PRICE_ATTRIB_ID) FROM OE_ORDER_PRICE_ATTRIBS WHERE LINE_ID = OOPA.LINE_ID ) )

Columns