VIEW: APPS.CST_MATERIAL_OVHD_RULES_V

Source

View Text - Preformatted

SELECT cmohr.rowid, cmohr.RULE_ID, cmohr.LAST_UPDATE_DATE , cmohr.LAST_UPDATED_BY, cmohr.CREATION_DATE , cmohr.CREATED_BY , cmohr.ORGANIZATION_ID, cmohr.TRANSACTION_TYPE, cmohr.SELECTION_criteria, cmohr.CATEGORY_ID, cmohr.ITEM_FROM, cmohr.ITEM_TO, cmohr.ITEM_TYPE, cmohr.SHIP_FROM_ORG, cmohr.EARN_MOH, cmohr.COST_TYPE_ID, mfg1.meaning, decode(cmohr.cost_type_id, null, null, cct.cost_type), mfg2.meaning FROM cst_material_ovhd_rules cmohr, mfg_lookups mfg1, mfg_lookups mfg2, cst_cost_types cct WHERE mfg1.lookup_code = cmohr.transaction_type and mfg1.lookup_type = 'CST_MOH_RULES_TRANSACTION' and mfg2.lookup_code = cmohr.item_type and mfg2.lookup_type = 'CST_MTL_ITEM_TYPE' and cct.cost_type_id = decode(cmohr.cost_type_id, null, (SELECT NVL(mp.avg_rates_cost_type_id, 1) FROM mtl_parameters mp WHERE mp.organization_id = cmohr.organization_id), cmohr.cost_type_id)

View Text - HTML Formatted

SELECT CMOHR.ROWID
, CMOHR.RULE_ID
, CMOHR.LAST_UPDATE_DATE
, CMOHR.LAST_UPDATED_BY
, CMOHR.CREATION_DATE
, CMOHR.CREATED_BY
, CMOHR.ORGANIZATION_ID
, CMOHR.TRANSACTION_TYPE
, CMOHR.SELECTION_CRITERIA
, CMOHR.CATEGORY_ID
, CMOHR.ITEM_FROM
, CMOHR.ITEM_TO
, CMOHR.ITEM_TYPE
, CMOHR.SHIP_FROM_ORG
, CMOHR.EARN_MOH
, CMOHR.COST_TYPE_ID
, MFG1.MEANING
, DECODE(CMOHR.COST_TYPE_ID
, NULL
, NULL
, CCT.COST_TYPE)
, MFG2.MEANING
FROM CST_MATERIAL_OVHD_RULES CMOHR
, MFG_LOOKUPS MFG1
, MFG_LOOKUPS MFG2
, CST_COST_TYPES CCT
WHERE MFG1.LOOKUP_CODE = CMOHR.TRANSACTION_TYPE
AND MFG1.LOOKUP_TYPE = 'CST_MOH_RULES_TRANSACTION'
AND MFG2.LOOKUP_CODE = CMOHR.ITEM_TYPE
AND MFG2.LOOKUP_TYPE = 'CST_MTL_ITEM_TYPE'
AND CCT.COST_TYPE_ID = DECODE(CMOHR.COST_TYPE_ID
, NULL
, (SELECT NVL(MP.AVG_RATES_COST_TYPE_ID
, 1)
FROM MTL_PARAMETERS MP
WHERE MP.ORGANIZATION_ID = CMOHR.ORGANIZATION_ID)
, CMOHR.COST_TYPE_ID)