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.

DBA Data [Home] [Help] [Dependency Information]

VIEW: APPS.INV_3PL_CONTRACTS_V

Object Details

Object Name:	INV_3PL_CONTRACTS_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	INV.INV_3PL_CONTRACTS_V
Subobject Name:
Status:	VALID

View Type

A public view which may be useful for custom reporting or other data
requirements.

INV_3PL_CONTRACTS_V is used to view Contains 3PL Contract info

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
CONTRACT	VARCHAR2	(763)		Contract Info
AUTHORING_ORG_ID	NUMBER		Yes	Identifier for Authoring Organization
BILLING_RULE_HEADER_ID	NUMBER		Yes	Identifier for Billing Rule Header
RULE_NAME	VARCHAR2	(80)	Yes	Name of the Rule
CONTRACT_NUMBER	VARCHAR2	(120)	Yes	Contract Number
ID	NUMBER		Yes	Identifier for Contract

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT CONTRACT
,      AUTHORING_ORG_ID
,      BILLING_RULE_HEADER_ID
,      RULE_NAME
,      CONTRACT_NUMBER
,      ID
FROM APPS.INV_3PL_CONTRACTS_V;

Dependencies

[top of page]

APPS.INV_3PL_CONTRACTS_V references the following:

APPS: HR_GENERAL - show dependent code; HR_OPERATING_UNITS; HR_SECURITY - show dependent code; HZ_PARTIES; MTL_BILLING_RULE_HEADERS_VL; MTL_SERVICE_CONTRACTS_V; OKC_K_PARTY_ROLES_B

APPS.INV_3PL_CONTRACTS_V is not referenced by any database object