View: AMS_INSTANCE_PARTY_B2C_V

Product:	AMS - Marketing
Description:	Business to Consumer Views for Install Base
Implementation/DBA Data:	APPS.AMS_INSTANCE_PARTY_B2C_V

View Text

SELECT CID.INSTANCE_ID
, CID.INSTANCE_NUMBER
, CID.EXTERNAL_REFERENCE
, CID.INVENTORY_ITEM_ID
, CID.INVENTORY_REVISION
, CID.INV_MASTER_ORGANIZATION_ID
, CID.SERIAL_NUMBER
, CID.MFG_SERIAL_NUMBER_FLAG
, CID.LOT_NUMBER
, CID.QUANTITY
, CID.UNIT_OF_MEASURE
, CID.ACCOUNTING_CLASS_CODE
, CID.INSTANCE_CONDITION_ID
, CID.INSTANCE_STATUS_ID
, CID.CUSTOMER_VIEW_FLAG
, CID.MERCHANT_VIEW_FLAG
, CID.SELLABLE_FLAG
, CID.SYSTEM_ID
, CID.INSTANCE_TYPE_CODE
, CID.ACTIVE_START_DATE
, CID.ACTIVE_END_DATE
, CID.LOCATION_TYPE_CODE
, CID.LOCATION_ID
, CID.INV_ORGANIZATION_ID
, CID.INV_SUBINVENTORY_NAME
, CID.INV_LOCATOR_ID
, CID.PA_PROJECT_ID
, CID.PA_PROJECT_TASK_ID
, CID.IN_TRANSIT_ORDER_LINE_ID
, CID.WIP_JOB_ID
, CID.PO_ORDER_LINE_ID
, CID.LAST_OE_ORDER_LINE_ID
, CID.LAST_OE_RMA_LINE_ID
, CID.LAST_PO_PO_LINE_ID
, CID.LAST_OE_PO_NUMBER
, CID.LAST_WIP_JOB_ID
, CID.LAST_PA_PROJECT_ID
, CID.LAST_PA_TASK_ID
, CID.LAST_OE_AGREEMENT_ID
, CID.INSTALL_DATE
, CID.MANUALLY_CREATED_FLAG
, CID.RETURN_BY_DATE
, CID.ACTUAL_RETURN_DATE
, CID.CREATION_COMPLETE_FLAG
, CID.COMPLETENESS_FLAG
, CID.CONTEXT
, CID.CREATED_BY
, CID.CREATION_DATE
, CID.LAST_UPDATED_BY
, CID.LAST_UPDATE_DATE
, CID.LAST_UPDATE_LOGIN
, CID.OBJECT_VERSION_NUMBER
, CID.DESCRIPTION
, CID.SERIAL_NUMBER_CONTROL_CODE
, CID.LOT_CONTROL_CODE
, CID.CONCATENATED_SEGMENTS
, CID.PADDED_CONCATENATED_SEGMENTS
, CID.UNIT_OF_MEASURE_NAME
, CID.ORGANIZATION_NAME
, CID.STATUS_CODE
, CID.CONDITION_DESCRIPTION
, CID.STATUS_NAME
, CID.STATUS_DESCRIPTION
, CID.PROJECT_NAME
, CID.PROJECT_TYPE
, CID.PROJECT_STATUS_CODE
, CID.PROJECT_DESCRIPTION
, CID.TASK_NUMBER
, CID.TASK_NAME
, CID.PARENT_TASK_ID
, CID.TASK_DESCRIPTION
, CID.LINE_TYPE_ID
, CID.LINE_NUMBER
, CID.CUST_PO_NUMBER
, CID.ORDER_NUMBER
, CID.ORDER_LINE_VERSION
, CID.ORDER_SOURCE_ID
, CID.ORDERED_DATE
, CID.WIP_ENTITY_NAME
, CID.WIP_ENTITY_TYPE
, CID.WIP_ENTITY_DESCRIPTION
, CID.PO_HEADER_ID
, CID.PO_LINE_TYPE_ID
, CID.PO_LINE_NUMBER
, CID.ITEM_DESCRIPTION
, CID.SYSTEM_NAME
, CIR.SUBJECT_ID CHILD_INSTANCE_ID
, CIR.RELATIONSHIP_ID II_REL_ID
, CIR.RELATIONSHIP_TYPE_CODE II_REL_TYPE_CODE
, CIR.POSITION_REFERENCE II_POSITION_REFERENCE
, CIR.ACTIVE_START_DATE II_REL_ACTIVE_START_DATE
, CIR.ACTIVE_END_DATE II_RELATION_ACTIVE_END_DATE
, CIR.DISPLAY_ORDER II_DISPLAY_ORDER
, CIR.MANDATORY_FLAG II_MANDATORY_FLAG
, CIR.CONTEXT II_RELATION_CONTEXT
, CIP.PARTY_SOURCE_TABLE
, CIP.PARTY_ID
, CIP.RELATIONSHIP_TYPE_CODE IP_REL_TYPE_CODE
, CIP.CONTACT_FLAG IP_CONTACT_FLAG
, CIP.CONTACT_IP_ID IP_CONTACT_IP_ID
, CIP.ACTIVE_START_DATE IP_REL_ACTIVE_START_DATE
, CIP.ACTIVE_END_DATE IP_REL_ACTIVE_END_DATE
, CIP.CONTEXT IP_REL_CONTEXT
FROM CSI_INSTANCE_DETAILS_V CID
, CSI_II_RELATIONSHIPS CIR
, CSI_I_PARTIES CIP
, HZ_PARTIES PARTIES
WHERE CID.INSTANCE_ID = CIR.OBJECT_ID (+)
AND CID.INSTANCE_ID = CIP.INSTANCE_ID
AND CIP.PARTY_SOURCE_TABLE = 'HZ_PARTIES'
AND CIP.PARTY_ID = PARTIES.PARTY_ID
AND PARTIES.PARTY_TYPE = 'PERSON'
AND PARTIES.STATUS = 'A'

Columns