VIEW: APPS.AMS_INSTANCE_PARTY_B2B_V

Source

View Text - Preformatted

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 = 'PARTY_RELATIONSHIP' AND PARTIES.STATUS = 'A'

View Text - HTML Formatted

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 = 'PARTY_RELATIONSHIP'
AND PARTIES.STATUS = 'A'