[Home] [Help] [Dependency Information]
Object Name: | PON_SYSTEM_FIELDS_VALUES_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | PON.PON_SYSTEM_FIELDS_VALUES_V |
Subobject Name: | |
Status: | VALID |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
Internal
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
AUCTION_HEADER_ID | NUMBER | Yes | Corresponds to pon_auction_headers_all.AUCTION_HEADER_ID | |
NEGOTIATION_NUM | VARCHAR2 | (240) | Corresponds to displayed document number | |
NEGOTIATION_TYPE | VARCHAR2 | (50) | Yes | Corresponds to the type of negotiation like RFQ, Auction, RFI, etc |
NEGOTIATION_TYPE_NAME | VARCHAR2 | (50) | Yes | Corresponds to user-displayed value of type of negotiation |
ORGANIZATION | NUMBER | Corresponds to organization ID for current negotiation | ||
ORGANIZATION_NAME | VARCHAR2 | (240) | Yes | User-displayed value of the organization |
OPEN_DATE | DATE | Open bidding date of negotiation | ||
PREVIEW_DATE | DATE | Preview date of the negotiation | ||
AWARD_DATE | DATE | Award Date of the current negotiation | ||
AMENDMENT_DESCRIPTION | VARCHAR2 | (4000) | Amendment description entered by buyer for amended auctions | |
CLOSE_DATE | DATE | Close bidding date of current negotiation | ||
TITLE | VARCHAR2 | (80) | Negotiation title | |
STYLE | VARCHAR2 | (25) | Buyer security style for current negotiation - private, public, etc | |
STYLE_NAME | VARCHAR2 | (80) | User-displayed style for current negotiation | |
BUYER | VARCHAR2 | (255) | Name of the buyer | |
EVENT | VARCHAR2 | (80) | Name of the event associated with current negotiation | |
PAYMENT_TERMS | NUMBER | Payment terms - internal code | ||
PAYMENT_TERMS_NAME | VARCHAR2 | (50) | Payment terms - user-displayed value | |
CARRIER | VARCHAR2 | (25) | Carrier - internal code | |
CARRIER_NAME | VARCHAR2 | (4000) | Carrier - user-displayed value | |
FOB | VARCHAR2 | (25) | FOB -- internal code | |
FOB_NAME | VARCHAR2 | (80) | FOB - user displayed value | |
FREIGHT_TERMS | VARCHAR2 | (25) | Freight terms - internal code | |
FREIGHT_TERMS_NAME | VARCHAR2 | (80) | Freight terms - user-displayed value | |
NEGOTIATION_CURR | VARCHAR2 | (15) | Negotiation currency of current auction | |
ABSTRACT_STATUS | VARCHAR2 | (20) | Internal status of the abstract - published or not | |
DISPLAY_PDF_FLAG | VARCHAR2 | (8) | Flag to indicate whether buyer wishes to display PDF document to suppliers | |
IS_PAUSED | VARCHAR2 | (1) | Flag to indicate whether auction is paused | |
TWO_PART_FLAG | VARCHAR2 | (1) | Flag to indicate if the negotiation is a two part RFQ. |
Cut, paste (and edit) the following text to query this object:
SELECT AUCTION_HEADER_ID
, NEGOTIATION_NUM
, NEGOTIATION_TYPE
, NEGOTIATION_TYPE_NAME
, ORGANIZATION
, ORGANIZATION_NAME
, OPEN_DATE
, PREVIEW_DATE
, AWARD_DATE
, AMENDMENT_DESCRIPTION
, CLOSE_DATE
, TITLE
, STYLE
, STYLE_NAME
, BUYER
, EVENT
, PAYMENT_TERMS
, PAYMENT_TERMS_NAME
, CARRIER
, CARRIER_NAME
, FOB
, FOB_NAME
, FREIGHT_TERMS
, FREIGHT_TERMS_NAME
, NEGOTIATION_CURR
, ABSTRACT_STATUS
, DISPLAY_PDF_FLAG
, IS_PAUSED
, TWO_PART_FLAG
FROM APPS.PON_SYSTEM_FIELDS_VALUES_V;
APPS.PON_SYSTEM_FIELDS_VALUES_V is not referenced by any database object
|
|
|