CMR_R_ACTIVE_PURCHASE_ORDDTL

Details

Schema: FUSION
Object owner: CMR
Object type: VIEW

Columns

Name
CMR_PO_DISTRIBUTION_ID PO_LINE_LOCATION_ID INVENTORY_ITEM_ID SOLD_TO_BUSINESS_UNIT_ID CATEGORY_ID DELIVER_TO_INVENTORY_ORG_ID DELIVER_TO_BUSINESS_UNIT_ID PRICE NONRECOVERABLE_TAX EVENT_DATE EVENT_TYPE PO_HEADER_ID ACCRUAL_ACCOUNT_ID QUANTITY_ORDERED UOM_CODE AMOUNT_ORDERED QUANTITY_CANCELLED AMOUNT_CANCELLED SECONDARY_QUANTITY SECONDARY_UOM_CODE SECONDARY_QTY_CANCELLED ACTIVE_FLAG CURRENCY_CODE CURRENCY_CONVERSION_TYPE CURRENCY_CONVERSION_DATE CURRENCY_CONVERSION_RATE ACCRUE_ON_RECEIPT_FLAG MATCH_OPTION DESTINATION_TYPE_CODE VENDOR_ID VENDOR_SITE_ID EXTERNAL_SYSTEM_REFERENCE EXTERNAL_SYSTEM_REF_ID PERIOD_END_ACCRUED_FLAG LAST_RUN_PERIOD_ID PO_NUMBER LINE_NUMBER SHIPMENT_NUMBER DISTRIBUTION_NUMBER PROCESSED_BY_CA_FLAG PROCESSED_BY_RA_FLAG CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN REQUEST_ID JOB_DEFINITION_NAME JOB_DEFINITION_PACKAGE ACTIVE_FOR_CA_FLAG PO_LINE_ID SHIP_TO_LOCATION_ID PRICE_IN_PRIMARY_UOM NR_TAX_IN_PRIMARY_UOM CONV_FACTOR_TO_PRIMARY_UOM ITEM_DESCRIPTION USE_FOR_GP_FLAG PURCHASE_BASIS MATCHING_BASIS CMR_PO_LINE_LOCATION_ID CHARGE_ACCOUNT_ID VARIANCE_ACCOUNT_ID DESTINATION_CHARGE_ACCOUNT_ID DESTINATION_VARIANCE_ACCT_ID PROCUREMENT_BUSINESS_UNIT_ID BILL_TO_BUSINESS_UNIT_ID SOLD_TO_LEGAL_ENTITY_ID SFO_PRIMARY_TRADE_RELATION_ID ORCHESTRATION_ORDER_FLAG TRADE_ORGANIZATION_ID TRADE_ORG_BU_FUNC_CURR_CODE NEED_BY_DATE PROMISED_DATE AGENT_ID DEFAULT_INVENTORY_ORG_ID TAX_EXCLUSIVE_PRICE NONRECOVERABLE_INCLUSIVE_TAX CONSIGNED_FLAG PRODUCT_FISCAL_CLASSIFICATION INTENDED_USE SUPPLIER_ITEM COUNTRY_OF_ORIGIN_CODE REQUISITIONING_BU_ID DELIVER_TO_BU_FUNC_CURR_CODE RECOVERABLE_TAX RECOVERABLE_INCLUSIVE_TAX

Name

CMR_PO_DISTRIBUTION_ID

PO_LINE_LOCATION_ID

INVENTORY_ITEM_ID

SOLD_TO_BUSINESS_UNIT_ID

CATEGORY_ID

DELIVER_TO_INVENTORY_ORG_ID

DELIVER_TO_BUSINESS_UNIT_ID

PRICE

NONRECOVERABLE_TAX

EVENT_DATE

EVENT_TYPE

PO_HEADER_ID

ACCRUAL_ACCOUNT_ID

QUANTITY_ORDERED

UOM_CODE

AMOUNT_ORDERED

QUANTITY_CANCELLED

AMOUNT_CANCELLED

SECONDARY_QUANTITY

SECONDARY_UOM_CODE

SECONDARY_QTY_CANCELLED

ACTIVE_FLAG

CURRENCY_CODE

CURRENCY_CONVERSION_TYPE

CURRENCY_CONVERSION_DATE

CURRENCY_CONVERSION_RATE

ACCRUE_ON_RECEIPT_FLAG

MATCH_OPTION

DESTINATION_TYPE_CODE

VENDOR_ID

VENDOR_SITE_ID

EXTERNAL_SYSTEM_REFERENCE

EXTERNAL_SYSTEM_REF_ID

PERIOD_END_ACCRUED_FLAG

LAST_RUN_PERIOD_ID

PO_NUMBER

LINE_NUMBER

SHIPMENT_NUMBER

DISTRIBUTION_NUMBER

PROCESSED_BY_CA_FLAG

PROCESSED_BY_RA_FLAG

CREATED_BY

CREATION_DATE

LAST_UPDATED_BY

LAST_UPDATE_DATE

LAST_UPDATE_LOGIN

REQUEST_ID

JOB_DEFINITION_NAME

JOB_DEFINITION_PACKAGE

ACTIVE_FOR_CA_FLAG

PO_LINE_ID

SHIP_TO_LOCATION_ID

PRICE_IN_PRIMARY_UOM

NR_TAX_IN_PRIMARY_UOM

CONV_FACTOR_TO_PRIMARY_UOM

ITEM_DESCRIPTION

USE_FOR_GP_FLAG

PURCHASE_BASIS

MATCHING_BASIS

CMR_PO_LINE_LOCATION_ID

CHARGE_ACCOUNT_ID

VARIANCE_ACCOUNT_ID

DESTINATION_CHARGE_ACCOUNT_ID

DESTINATION_VARIANCE_ACCT_ID

PROCUREMENT_BUSINESS_UNIT_ID

BILL_TO_BUSINESS_UNIT_ID

SOLD_TO_LEGAL_ENTITY_ID

SFO_PRIMARY_TRADE_RELATION_ID

ORCHESTRATION_ORDER_FLAG

TRADE_ORGANIZATION_ID

TRADE_ORG_BU_FUNC_CURR_CODE

NEED_BY_DATE

PROMISED_DATE

AGENT_ID

DEFAULT_INVENTORY_ORG_ID

TAX_EXCLUSIVE_PRICE

NONRECOVERABLE_INCLUSIVE_TAX

CONSIGNED_FLAG

PRODUCT_FISCAL_CLASSIFICATION

INTENDED_USE

SUPPLIER_ITEM

COUNTRY_OF_ORIGIN_CODE

REQUISITIONING_BU_ID

DELIVER_TO_BU_FUNC_CURR_CODE

RECOVERABLE_TAX

RECOVERABLE_INCLUSIVE_TAX

Query

SQL_Statement
SELECT CMR_PO_DISTRIBUTION_ID , PO_LINE_LOCATION_ID , INVENTORY_ITEM_ID , SOLD_TO_BUSINESS_UNIT_ID , CATEGORY_ID , DELIVER_TO_INVENTORY_ORG_ID , DELIVER_TO_BUSINESS_UNIT_ID , PRICE , NONRECOVERABLE_TAX , EVENT_DATE , EVENT_TYPE , PO_HEADER_ID , ACCRUAL_ACCOUNT_ID , QUANTITY_ORDERED , UOM_CODE , AMOUNT_ORDERED , QUANTITY_CANCELLED , AMOUNT_CANCELLED , SECONDARY_QUANTITY , SECONDARY_UOM_CODE , SECONDARY_QTY_CANCELLED , ACTIVE_FLAG , CURRENCY_CODE , CURRENCY_CONVERSION_TYPE , CURRENCY_CONVERSION_DATE , CURRENCY_CONVERSION_RATE , ACCRUE_ON_RECEIPT_FLAG , MATCH_OPTION , DESTINATION_TYPE_CODE , VENDOR_ID , VENDOR_SITE_ID , EXTERNAL_SYSTEM_REFERENCE , EXTERNAL_SYSTEM_REF_ID , PERIOD_END_ACCRUED_FLAG , LAST_RUN_PERIOD_ID , PO_NUMBER , LINE_NUMBER , SHIPMENT_NUMBER , DISTRIBUTION_NUMBER , PROCESSED_BY_CA_FLAG , PROCESSED_BY_RA_FLAG , CREATED_BY , CREATION_DATE , LAST_UPDATED_BY , LAST_UPDATE_DATE , LAST_UPDATE_LOGIN , REQUEST_ID , JOB_DEFINITION_NAME , JOB_DEFINITION_PACKAGE , ACTIVE_FOR_CA_FLAG , PO_LINE_ID , SHIP_TO_LOCATION_ID , PRICE_IN_PRIMARY_UOM , NR_TAX_IN_PRIMARY_UOM , CONV_FACTOR_TO_PRIMARY_UOM , ITEM_DESCRIPTION , USE_FOR_GP_FLAG , PURCHASE_BASIS , MATCHING_BASIS , CMR_PO_LINE_LOCATION_ID , CHARGE_ACCOUNT_ID , VARIANCE_ACCOUNT_ID , DESTINATION_CHARGE_ACCOUNT_ID , DESTINATION_VARIANCE_ACCT_ID , PROCUREMENT_BUSINESS_UNIT_ID , BILL_TO_BUSINESS_UNIT_ID , SOLD_TO_LEGAL_ENTITY_ID , SFO_PRIMARY_TRADE_RELATION_ID , ORCHESTRATION_ORDER_FLAG , TRADE_ORGANIZATION_ID , TRADE_ORG_BU_FUNC_CURR_CODE , NEED_BY_DATE , PROMISED_DATE , AGENT_ID , DEFAULT_INVENTORY_ORG_ID , TAX_EXCLUSIVE_PRICE , NONRECOVERABLE_INCLUSIVE_TAX , CONSIGNED_FLAG , PRODUCT_FISCAL_CLASSIFICATION , INTENDED_USE , SUPPLIER_ITEM , COUNTRY_OF_ORIGIN_CODE , REQUISITIONING_BU_ID , DELIVER_TO_BU_FUNC_CURR_CODE, RECOVERABLE_TAX, RECOVERABLE_INCLUSIVE_TAX FROM CMR_PURCHASE_ORDER_DTLS WHERE ACTIVE_FLAG='Y'

SQL_Statement

SELECT

CMR_PO_DISTRIBUTION_ID ,

PO_LINE_LOCATION_ID ,

INVENTORY_ITEM_ID ,

SOLD_TO_BUSINESS_UNIT_ID ,

CATEGORY_ID ,

DELIVER_TO_INVENTORY_ORG_ID ,

DELIVER_TO_BUSINESS_UNIT_ID ,

PRICE ,

NONRECOVERABLE_TAX ,

EVENT_DATE ,

EVENT_TYPE ,

PO_HEADER_ID ,

ACCRUAL_ACCOUNT_ID ,

QUANTITY_ORDERED ,

UOM_CODE ,

AMOUNT_ORDERED ,

QUANTITY_CANCELLED ,

AMOUNT_CANCELLED ,

SECONDARY_QUANTITY ,

SECONDARY_UOM_CODE ,

SECONDARY_QTY_CANCELLED ,

ACTIVE_FLAG ,

CURRENCY_CODE ,

CURRENCY_CONVERSION_TYPE ,

CURRENCY_CONVERSION_DATE ,

CURRENCY_CONVERSION_RATE ,

ACCRUE_ON_RECEIPT_FLAG ,

MATCH_OPTION ,

DESTINATION_TYPE_CODE ,

VENDOR_ID ,

VENDOR_SITE_ID ,

EXTERNAL_SYSTEM_REFERENCE ,

EXTERNAL_SYSTEM_REF_ID ,

PERIOD_END_ACCRUED_FLAG ,

LAST_RUN_PERIOD_ID ,

PO_NUMBER ,

LINE_NUMBER ,

SHIPMENT_NUMBER ,

DISTRIBUTION_NUMBER ,

PROCESSED_BY_CA_FLAG ,

PROCESSED_BY_RA_FLAG ,

CREATED_BY ,

CREATION_DATE ,

LAST_UPDATED_BY ,

LAST_UPDATE_DATE ,

LAST_UPDATE_LOGIN ,

REQUEST_ID ,

JOB_DEFINITION_NAME ,

JOB_DEFINITION_PACKAGE ,

ACTIVE_FOR_CA_FLAG ,

PO_LINE_ID ,

SHIP_TO_LOCATION_ID ,

PRICE_IN_PRIMARY_UOM ,

NR_TAX_IN_PRIMARY_UOM ,

CONV_FACTOR_TO_PRIMARY_UOM ,

ITEM_DESCRIPTION ,

USE_FOR_GP_FLAG ,

PURCHASE_BASIS ,

MATCHING_BASIS ,

CMR_PO_LINE_LOCATION_ID ,

CHARGE_ACCOUNT_ID ,

VARIANCE_ACCOUNT_ID ,

DESTINATION_CHARGE_ACCOUNT_ID ,

DESTINATION_VARIANCE_ACCT_ID ,

PROCUREMENT_BUSINESS_UNIT_ID ,

BILL_TO_BUSINESS_UNIT_ID ,

SOLD_TO_LEGAL_ENTITY_ID ,

SFO_PRIMARY_TRADE_RELATION_ID ,

ORCHESTRATION_ORDER_FLAG ,

TRADE_ORGANIZATION_ID ,

TRADE_ORG_BU_FUNC_CURR_CODE ,

NEED_BY_DATE ,

PROMISED_DATE ,

AGENT_ID ,

DEFAULT_INVENTORY_ORG_ID ,

TAX_EXCLUSIVE_PRICE ,

NONRECOVERABLE_INCLUSIVE_TAX ,

CONSIGNED_FLAG ,

PRODUCT_FISCAL_CLASSIFICATION ,

INTENDED_USE ,

SUPPLIER_ITEM ,

COUNTRY_OF_ORIGIN_CODE ,

REQUISITIONING_BU_ID ,

DELIVER_TO_BU_FUNC_CURR_CODE,

RECOVERABLE_TAX,

RECOVERABLE_INCLUSIVE_TAX

FROM CMR_PURCHASE_ORDER_DTLS

WHERE ACTIVE_FLAG='Y'