VIEW: APPS.MTL_BILLING_SOURCES_VL

Source

View Text - Preformatted

SELECT b.ROWID row_id, b.billing_source_id, tl.name, tl.description, b.procedure_code, b.billing_source_code , b.creation_date, b.created_by, b.last_update_date, b.last_updated_by, b.last_update_login FROM mtl_billing_sources_tl tl , mtl_billing_sources_b b WHERE tl.language = userenv('LANG') AND tl.billing_source_id = b.billing_source_id

View Text - HTML Formatted

SELECT B.ROWID ROW_ID
, B.BILLING_SOURCE_ID
, TL.NAME
, TL.DESCRIPTION
, B.PROCEDURE_CODE
, B.BILLING_SOURCE_CODE
, B.CREATION_DATE
, B.CREATED_BY
, B.LAST_UPDATE_DATE
, B.LAST_UPDATED_BY
, B.LAST_UPDATE_LOGIN
FROM MTL_BILLING_SOURCES_TL TL
, MTL_BILLING_SOURCES_B B
WHERE TL.LANGUAGE = USERENV('LANG')
AND TL.BILLING_SOURCE_ID = B.BILLING_SOURCE_ID