DBA Data[Home] [Help]

VIEW: APPS.GMF_LOT_COSTED_ITEMS_V

Source

View Text - Preformatted

SELECT DISTINCT lci.legal_entity_id, lci.cost_type_id, gle.legal_entity_name FROM gmf_lot_costed_items lci, gmf_legal_entities_vw2 gle WHERE lci.legal_entity_id = gle.legal_entity_id
View Text - HTML Formatted

SELECT DISTINCT LCI.LEGAL_ENTITY_ID
, LCI.COST_TYPE_ID
, GLE.LEGAL_ENTITY_NAME
FROM GMF_LOT_COSTED_ITEMS LCI
, GMF_LEGAL_ENTITIES_VW2 GLE
WHERE LCI.LEGAL_ENTITY_ID = GLE.LEGAL_ENTITY_ID