VIEW: APPS.PMIFV_ITEM_PRICE_V

Source

View Text - Preformatted

SELECT priceitem.QC_GRADE, /* regular attributes */ priceitem.PRICE_UM, priceitem.BASE_PRICE, priceitem.FRTBILL_MTHD, priceitem.LINE_NO, priceitem.PRICE_TYPE, priceitem.BREAK_TYPE, priceitem.PRICELIST_ID, /*ID*/ priceitem.PRICE_CLASS, priceitem.PRICE_ID, priceitem.ITEM_ID, priceitem.WHSE_CODE, Warehouse.WHSE_NAME, item.item_no, /* Resolve Foreign keys */ item.item_desc1, item.item_um, item.item_um2, pricemaster.PRICELIST_CODE, pricemaster.PRICELIST_DESC1, pricemaster.PRICESORT_NAME, pricemaster.COMMENTS, pricemaster.CURRENCY_CODE, pricebreak.LINE_NO, pricebreak.QTY_BREAKPOINT, pricebreak.VALUE_BREAKPOINT, pricebreak.BREAKPOINT_FACTOR, pricebreak.BREAKPOINT_PRICE, pricebreak.BREAKTYPE_ID, priceitem.CREATED_BY, /* WHO */ priceitem.CREATION_DATE, priceitem.LAST_UPDATE_DATE, priceitem.LAST_UPDATED_BY FROM op_prce_itm priceitem, op_prce_brk pricebreak, op_prce_mst pricemaster, ic_item_mst item, ic_whse_mst warehouse WHERE priceitem.pricelist_id = pricemaster.pricelist_id and priceitem.price_id = pricebreak.price_id and priceitem.item_id = item.item_id and priceitem.whse_code = warehouse.whse_code(+) and (warehouse.orgn_code is NULL or warehouse.orgn_code IN (SELECT secorg.orgn_code FROM sy_orgn_mst secorg WHERE PMI_SECURITY_PKG.show_record(secorg.orgn_code) = 'TRUE')) with read only

View Text - HTML Formatted

SELECT PRICEITEM.QC_GRADE
, /* REGULAR ATTRIBUTES */ PRICEITEM.PRICE_UM
, PRICEITEM.BASE_PRICE
, PRICEITEM.FRTBILL_MTHD
, PRICEITEM.LINE_NO
, PRICEITEM.PRICE_TYPE
, PRICEITEM.BREAK_TYPE
, PRICEITEM.PRICELIST_ID
, /*ID*/ PRICEITEM.PRICE_CLASS
, PRICEITEM.PRICE_ID
, PRICEITEM.ITEM_ID
, PRICEITEM.WHSE_CODE
, WAREHOUSE.WHSE_NAME
, ITEM.ITEM_NO
, /* RESOLVE FOREIGN KEYS */ ITEM.ITEM_DESC1
, ITEM.ITEM_UM
, ITEM.ITEM_UM2
, PRICEMASTER.PRICELIST_CODE
, PRICEMASTER.PRICELIST_DESC1
, PRICEMASTER.PRICESORT_NAME
, PRICEMASTER.COMMENTS
, PRICEMASTER.CURRENCY_CODE
, PRICEBREAK.LINE_NO
, PRICEBREAK.QTY_BREAKPOINT
, PRICEBREAK.VALUE_BREAKPOINT
, PRICEBREAK.BREAKPOINT_FACTOR
, PRICEBREAK.BREAKPOINT_PRICE
, PRICEBREAK.BREAKTYPE_ID
, PRICEITEM.CREATED_BY
, /* WHO */ PRICEITEM.CREATION_DATE
, PRICEITEM.LAST_UPDATE_DATE
, PRICEITEM.LAST_UPDATED_BY
FROM OP_PRCE_ITM PRICEITEM
, OP_PRCE_BRK PRICEBREAK
, OP_PRCE_MST PRICEMASTER
, IC_ITEM_MST ITEM
, IC_WHSE_MST WAREHOUSE
WHERE PRICEITEM.PRICELIST_ID = PRICEMASTER.PRICELIST_ID
AND PRICEITEM.PRICE_ID = PRICEBREAK.PRICE_ID
AND PRICEITEM.ITEM_ID = ITEM.ITEM_ID
AND PRICEITEM.WHSE_CODE = WAREHOUSE.WHSE_CODE(+)
AND (WAREHOUSE.ORGN_CODE IS NULL OR WAREHOUSE.ORGN_CODE IN (SELECT SECORG.ORGN_CODE
FROM SY_ORGN_MST SECORG
WHERE PMI_SECURITY_PKG.SHOW_RECORD(SECORG.ORGN_CODE) = 'TRUE')) WITH READ ONLY