eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

View: MTL_BILLING_RULE_HEADERS_VL

Product:	INV - Inventory
Description:
Implementation/DBA Data:	APPS.MTL_BILLING_RULE_HEADERS_VL

View Text

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

Columns

Name
ROW_ID
BILLING_RULE_HEADER_ID
NAME
DESCRIPTION
CONTRACT_NUMBER
SERVICE_AGREEMENT_ID
ORGANIZATION_ID
ORGANIZATION_NAME
START_DATE
END_DATE
CREATION_DATE
CREATED_BY
LAST_UPDATE_DATE
LAST_UPDATED_BY
LAST_UPDATE_LOGIN