VIEW: APPS.OKS_IB_CONFIG_V

Source

View Text - Preformatted

SELECT CIIR.object_id config_parent_id, cii.instance_id customer_product_id, cii.serial_number serial_number, cii.install_location_id install_site_use_id, cii.INVENTORY_ITEM_ID INVENTORY_ITEM_ID, cii.inv_master_organization_id inv_master_organization_id, cii.system_id system_id, cii.owner_party_account_id owner_party_account_id, cii.instance_number, cii.instance_status_id FROM CSI_II_RELATIONSHIPS CIIR,CSI_ITEM_INSTANCES CII WHERE CII.INSTANCE_ID = CIIR.SUBJECT_ID(+) AND CIIR.RELATIONSHIP_TYPE_CODE(+) = 'COMPONENT-OF' AND CIIR.ACTIVE_END_DATE(+) IS NULL

View Text - HTML Formatted

SELECT CIIR.OBJECT_ID CONFIG_PARENT_ID
, CII.INSTANCE_ID CUSTOMER_PRODUCT_ID
, CII.SERIAL_NUMBER SERIAL_NUMBER
, CII.INSTALL_LOCATION_ID INSTALL_SITE_USE_ID
, CII.INVENTORY_ITEM_ID INVENTORY_ITEM_ID
, CII.INV_MASTER_ORGANIZATION_ID INV_MASTER_ORGANIZATION_ID
, CII.SYSTEM_ID SYSTEM_ID
, CII.OWNER_PARTY_ACCOUNT_ID OWNER_PARTY_ACCOUNT_ID
, CII.INSTANCE_NUMBER
, CII.INSTANCE_STATUS_ID
FROM CSI_II_RELATIONSHIPS CIIR
, CSI_ITEM_INSTANCES CII
WHERE CII.INSTANCE_ID = CIIR.SUBJECT_ID(+)
AND CIIR.RELATIONSHIP_TYPE_CODE(+) = 'COMPONENT-OF'
AND CIIR.ACTIVE_END_DATE(+) IS NULL