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.PO_CLMREQ_LINE_SOL_REFS_V

Object Details

Object Name:	PO_CLMREQ_LINE_SOL_REFS_V
Object Type:	VIEW
Owner:	APPS
Subobject Name:
Status:	VALID

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
REQUISITION_HEADER_ID	NUMBER		Yes	Requisition header unique identifier
REQUISITION_LINE_ID	NUMBER		Yes	Requisition line unique identifier
REQUISITION_NUMBER	VARCHAR2	(20)	Yes	Line number
LINE_NUMBER	VARCHAR2	(100)		Line number
AUCTION_DISPLAY_NUMBER	VARCHAR2	(240)		Line number
AUCTION_HEADER_ID	NUMBER		Yes	Reference to sourcing auction id
AUCTION_TITLE	VARCHAR2	(80)		Auction title
NEGOTIATION_STATUS	VARCHAR2	(38)		Status of auction. Possible values are DRAFT, ACTIVE, CANCELLED
DOCTYPE_ID	NUMBER			Identifier for document type associated with this auction
AUCTION_LINE_NO	NUMBER		Yes	reference to sourcing auction line number
AUCTION_STATUS	VARCHAR2	(25)		Status of auction. Possible values are DRAFT, ACTIVE, CANCELLED
TRADING_PARTNER_CONTACT_ID	NUMBER			Unique Identifier for contact person for Trading Partner that owns auction
TRADING_PARTNER_ID	NUMBER			Unique Identifier of Trading Partner that owns auction
TRADING_PARTNER_CONTACT_NAME	VARCHAR2	(255)		Contact person name for Trading Partner that owns auction
ORG_ID	NUMBER			org_id for multi-org
PO_START_DATE	DATE			Purchase order start date. Applicable only for long term Buyer's auction.
CREATION_DATE	DATE
PUBLISH_DATE	DATE

Query Text

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


SELECT REQUISITION_HEADER_ID
,      REQUISITION_LINE_ID
,      REQUISITION_NUMBER
,      LINE_NUMBER
,      AUCTION_DISPLAY_NUMBER
,      AUCTION_HEADER_ID
,      AUCTION_TITLE
,      NEGOTIATION_STATUS
,      DOCTYPE_ID
,      AUCTION_LINE_NO
,      AUCTION_STATUS
,      TRADING_PARTNER_CONTACT_ID
,      TRADING_PARTNER_ID
,      TRADING_PARTNER_CONTACT_NAME
,      ORG_ID
,      PO_START_DATE
,      CREATION_DATE
,      PUBLISH_DATE
FROM APPS.PO_CLMREQ_LINE_SOL_REFS_V;

Dependencies

[top of page]

APPS.PO_CLMREQ_LINE_SOL_REFS_V references the following:

APPS: PON_AUCTION_HEADERS_ALL_V; PON_BACKING_REQUISITIONS; PON_LOCALE_PKG - show dependent code; PO_REQUISITION_HEADERS_CLM_V; PO_REQUISITION_LINES_ALL

APPS.PO_CLMREQ_LINE_SOL_REFS_V is not referenced by any database object