eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: APPS.CSI_CP_FORM_PROD_V

Source

View Text - Preformatted


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 ) )

View Text - HTML Formatted

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 ) )