View: AST_INSTALLED_BASE_V

View Text

SELECT CP.CUSTOMER_PRODUCT_ID
, CP.CUSTOMER_ID
, CP.INVENTORY_ITEM_ID
, CP.CURRENT_SERIAL_NUMBER
, CP.TYPE_CODE
, CP.SYSTEM_ID
, CP.INSTALLATION_DATE
, CP.ORIGINAL_ORDER_LINE_ID
, CP.INSTALL_SITE_USE_ID
, CP.START_DATE_ACTIVE
, CP.END_DATE_ACTIVE
, CP.CUSTOMER_PRODUCT_STATUS_ID
, CP.SHIPPED_DATE
, CP.ORG_ID
, CP.REFERENCE_NUMBER
, CP.LOT_NUMBER
, CP.SPLIT_FLAG
, HZA.ACCOUNT_NUMBER
, HZP.PARTY_NAME
, CPS.NAME CP_STATUS
, CPS.CANCELLED_FLAG
, CPS.TERMINATED_FLAG
, OOH.ORDERED_DATE
, OOH.ORDER_NUMBER
, OOH.CUST_PO_NUMBER
, OOL.LINE_NUMBER
, OOL.LINK_TO_LINE_ID
, S.NAME SYSTEM
, L.MEANING CP_TYPE
FROM CS_CUSTOMER_PRODUCTS_ALL CP
, HZ_CUST_ACCOUNTS HZA
, HZ_PARTIES HZP
, CS_CUSTOMER_PRODUCT_STATUSES CPS
, OE_ORDER_LINES_ALL OOL
, OE_ORDER_HEADERS_ALL OOH
, CS_SYSTEMS S
, CS_LOOKUPS L
WHERE CP.SYSTEM_ID = S.SYSTEM_ID(+)
AND CP.TYPE_CODE = L.LOOKUP_CODE(+)
AND L.LOOKUP_TYPE(+) = 'CUSTOMER_PRODUCT_TYPE'
AND CP.CUSTOMER_ID = HZA.CUST_ACCOUNT_ID
AND HZA.PARTY_ID = HZP.PARTY_ID
AND CP.CUSTOMER_PRODUCT_STATUS_ID = CPS.CUSTOMER_PRODUCT_STATUS_ID
AND CP.ORIGINAL_ORDER_LINE_ID = OOL.LINE_ID(+)
AND OOL.HEADER_ID = OOH.HEADER_ID(+)

Columns