VIEW: APPS.MTL_BILLING_RULE_HEADERS_VL

Source

View Text - Preformatted

SELECT b.ROWID row_id, b.billing_rule_header_id, tl.name, tl.description, contract_headers.contract_number, b.service_agreement_id, OU_detail.Organization_id, OU_detail.organization_name, contract_headers.start_Date, contract_headers.end_date, b.creation_date, b.created_by, b.last_update_date, b.last_updated_by, b.last_update_login FROM mtl_billing_rule_headers_tl tl , mtl_billing_rule_headers_b b, okc_k_headers_b contract_headers, org_organization_definitions OU_detail WHERE tl.language = userenv('LANG') AND tl.billing_rule_header_id = b.billing_rule_header_id AND contract_headers.id = b.service_agreement_id AND ou_detail.organization_id = contract_headers.authoring_org_id

View Text - HTML Formatted

SELECT B.ROWID ROW_ID
, B.BILLING_RULE_HEADER_ID
, TL.NAME
, TL.DESCRIPTION
, CONTRACT_HEADERS.CONTRACT_NUMBER
, B.SERVICE_AGREEMENT_ID
, OU_DETAIL.ORGANIZATION_ID
, OU_DETAIL.ORGANIZATION_NAME
, CONTRACT_HEADERS.START_DATE
, CONTRACT_HEADERS.END_DATE
, B.CREATION_DATE
, B.CREATED_BY
, B.LAST_UPDATE_DATE
, B.LAST_UPDATED_BY
, B.LAST_UPDATE_LOGIN
FROM MTL_BILLING_RULE_HEADERS_TL TL
, MTL_BILLING_RULE_HEADERS_B B
, OKC_K_HEADERS_B CONTRACT_HEADERS
, ORG_ORGANIZATION_DEFINITIONS OU_DETAIL
WHERE TL.LANGUAGE = USERENV('LANG')
AND TL.BILLING_RULE_HEADER_ID = B.BILLING_RULE_HEADER_ID
AND CONTRACT_HEADERS.ID = B.SERVICE_AGREEMENT_ID
AND OU_DETAIL.ORGANIZATION_ID = CONTRACT_HEADERS.AUTHORING_ORG_ID