CMR_XLA_ACCRUAL_CLR_AMTS_V

Details

  • Schema: FUSION

  • Object owner: CMR

  • Object type: VIEW

Columns

Name

ACCRUAL_CLR_ID

CMR_PO_DISTRIBUTION_ID

BUSINESS_UNIT_ID

INVENTORY_ITEM_ID

INV_ORG_ID

DESTINATION_TYPE_CODE

ACCRUAL_CLR_REASON

Query

SQL_Statement

SELECT accrual_clr_id accrual_clr_id

, cmr_po_distribution_id cmr_po_distribution_id

, sold_to_business_unit_id business_unit_id

, inventory_item_id inventory_item_id

, inventory_organization_id inv_org_id

, destination_type_code destination_type_code

, accrual_clr_reason_desc accrual_clr_reason

FROM cmr_accrual_clr_amts