1. Tables and Views for SCM
  2. CST_GP_NONGT_SCHEDULE_V

CST_GP_NONGT_SCHEDULE_V

Details

  • Schema: FUSION

  • Object owner: CST

  • Object type: VIEW

Columns

Name

CMR_PO_LINE_LOCATION_ID

CONVERTED_TAX_EXCLUSIVE_PRICE

CONVERTED_AVG_NR_TAX

POS_QTY_ORDERED_PRIMARY_UOM

POS_QTY_SOURCE_DOC_UOM

TRADE_ORG_BU_FUNC_CURR_CODE

MATCH_OPTION

NC_TAX_EXCLUSIVE_PRICE

NC_NR_TAX

Query

SQL_Statement

select cmr_po_line_location_id,

nvl(tax_exclusive_price,0) *nvl(currency_conversion_rate, 1) / conv_factor_to_primary_uom converted_tax_exclusive_price,

SUM((quantity_ordered -quantity_cancelled) *((nr_tax_in_primary_uom +(nvl(nonrecoverable_inclusive_tax,0) / conv_factor_to_primary_uom)) *nvl(currency_conversion_rate,1))) / decode(SUM(quantity_ordered -quantity_cancelled), 0, 1, SUM(quantity_ordered -quantity_cancelled)) converted_avg_nr_tax,

sum((QUANTITY_ORDERED - QUANTITY_CANCELLED)* CONV_FACTOR_TO_PRIMARY_UOM) pos_qty_ordered_primary_uom ,

sum(QUANTITY_ORDERED - QUANTITY_CANCELLED) pos_qty_source_doc_uom ,

trade_org_bu_func_curr_code,

match_option,

nvl(tax_exclusive_price,0) * nvl(currency_conversion_rate, 1) nc_tax_exclusive_price,

SUM((quantity_ordered -quantity_cancelled) * ((nonrecoverable_tax +nvl(nonrecoverable_inclusive_tax,0)) * nvl(currency_conversion_rate,1)))/ decode(SUM(quantity_ordered -quantity_cancelled), 0, 1, SUM(quantity_ordered -quantity_cancelled)) nc_nr_tax

from cmr_purchase_order_dtls

where processed_by_ca_flag = 'Y'

and (active_flag = 'Y' OR active_for_ca_flag = 'Y')

and cmr_po_line_location_id not in

(select cmr_po_line_location_id from cst_gp_purchase_order_dists_gt)

group by cmr_po_line_location_id,

tax_exclusive_price,

currency_conversion_rate,

conv_factor_to_primary_uom,

trade_org_bu_func_curr_code,

match_option