DBA Data[Home] [Help]

VIEW: APPS.CS_ACC_CP_RG_V

Source

View Text - Preformatted

SELECT CP.CUSTOMER_PRODUCT_ID , KFV.CONCATENATED_SEGMENTS PRODUCT_NAME , KFV.DESCRIPTION PRODUCT_DESCRIPTION , CP.INVENTORY_ITEM_ID , CP.CURRENT_SERIAL_NUMBER , CP.SYSTEM_ID , SYS.NAME SYSTEM_NAME , CP.CURRENT_CP_REVISION_ID , REV.REVISION , KFV.ITEM_TYPE PRODUCT_TYPE , CP.CUSTOMER_PRODUCT_STATUS_ID , CPS.NAME CUSTOMER_PRODUCT_STATUS , CP.REFERENCE_NUMBER , CP.LOT_NUMBER , ASOHDR.CUST_PO_NUMBER , ASOHDR.ORDER_NUMBER , CP.CONFIG_ROOT_ID , CP.CONFIG_PARENT_ID , to_number(null) PLATFORM_ID , null PLATFORM , to_number(null) PLATFORM_VERSION_ID , null VERSION , CP.ORG_ID , CPS.INCIDENT_ALLOWED_FLAG , CP.CUSTOMER_ID , CP.INSTALL_SITE_USE_ID FROM CS_CUSTOMER_PRODUCTS_ALL CP, CS_CUSTOMER_PRODUCT_STATUSES CPS, CS_CP_REVISIONS REV, CS_SYSTEMS SYS, CS_LOOKUPS CSL, MTL_SYSTEM_ITEMS_KFV KFV, OE_ORDER_LINES_ALL ASOLIN, OE_ORDER_HEADERS_ALL ASOHDR WHERE CP.SYSTEM_ID = SYS.SYSTEM_ID(+) AND CP.TYPE_CODE = CSL.LOOKUP_CODE(+) AND CSL.LOOKUP_TYPE(+) = 'CUSTOMER_PRODUCT_TYPE' AND CP.CUSTOMER_PRODUCT_ID = REV.CUSTOMER_PRODUCT_ID AND CP.CURRENT_CP_REVISION_ID = REV.CP_REVISION_ID AND CP.CUSTOMER_PRODUCT_STATUS_ID = CPS.CUSTOMER_PRODUCT_STATUS_ID AND CP.CUSTOMER_PRODUCT_STATUS_ID NOT IN (4,1003) AND CP.INVENTORY_ITEM_ID = KFV.INVENTORY_ITEM_ID AND KFV.ORGANIZATION_ID = CS_STD.Get_Item_Valdn_Orgzn_Id AND CP.ORIGINAL_ORDER_LINE_ID= ASOLIN.LINE_ID (+) AND ASOLIN.HEADER_ID= ASOHDR.HEADER_ID (+) AND SYSDATE BETWEEN NVL(CP.START_DATE_ACTIVE,SYSDATE) AND NVL(CP.END_DATE_ACTIVE,SYSDATE)
View Text - HTML Formatted

SELECT CP.CUSTOMER_PRODUCT_ID
, KFV.CONCATENATED_SEGMENTS PRODUCT_NAME
, KFV.DESCRIPTION PRODUCT_DESCRIPTION
, CP.INVENTORY_ITEM_ID
, CP.CURRENT_SERIAL_NUMBER
, CP.SYSTEM_ID
, SYS.NAME SYSTEM_NAME
, CP.CURRENT_CP_REVISION_ID
, REV.REVISION
, KFV.ITEM_TYPE PRODUCT_TYPE
, CP.CUSTOMER_PRODUCT_STATUS_ID
, CPS.NAME CUSTOMER_PRODUCT_STATUS
, CP.REFERENCE_NUMBER
, CP.LOT_NUMBER
, ASOHDR.CUST_PO_NUMBER
, ASOHDR.ORDER_NUMBER
, CP.CONFIG_ROOT_ID
, CP.CONFIG_PARENT_ID
, TO_NUMBER(NULL) PLATFORM_ID
, NULL PLATFORM
, TO_NUMBER(NULL) PLATFORM_VERSION_ID
, NULL VERSION
, CP.ORG_ID
, CPS.INCIDENT_ALLOWED_FLAG
, CP.CUSTOMER_ID
, CP.INSTALL_SITE_USE_ID
FROM CS_CUSTOMER_PRODUCTS_ALL CP
, CS_CUSTOMER_PRODUCT_STATUSES CPS
, CS_CP_REVISIONS REV
, CS_SYSTEMS SYS
, CS_LOOKUPS CSL
, MTL_SYSTEM_ITEMS_KFV KFV
, OE_ORDER_LINES_ALL ASOLIN
, OE_ORDER_HEADERS_ALL ASOHDR
WHERE CP.SYSTEM_ID = SYS.SYSTEM_ID(+)
AND CP.TYPE_CODE = CSL.LOOKUP_CODE(+)
AND CSL.LOOKUP_TYPE(+) = 'CUSTOMER_PRODUCT_TYPE'
AND CP.CUSTOMER_PRODUCT_ID = REV.CUSTOMER_PRODUCT_ID
AND CP.CURRENT_CP_REVISION_ID = REV.CP_REVISION_ID
AND CP.CUSTOMER_PRODUCT_STATUS_ID = CPS.CUSTOMER_PRODUCT_STATUS_ID
AND CP.CUSTOMER_PRODUCT_STATUS_ID NOT IN (4
, 1003)
AND CP.INVENTORY_ITEM_ID = KFV.INVENTORY_ITEM_ID
AND KFV.ORGANIZATION_ID = CS_STD.GET_ITEM_VALDN_ORGZN_ID
AND CP.ORIGINAL_ORDER_LINE_ID= ASOLIN.LINE_ID (+)
AND ASOLIN.HEADER_ID= ASOHDR.HEADER_ID (+)
AND SYSDATE BETWEEN NVL(CP.START_DATE_ACTIVE
, SYSDATE)
AND NVL(CP.END_DATE_ACTIVE
, SYSDATE)