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]

TABLE: PON.PON_ITEM_PRICES_INTERFACE

Object Details

Object Name:	PON_ITEM_PRICES_INTERFACE
Object Type:	TABLE
Owner:	PON
FND Design Data:	PON.PON_ITEM_PRICES_INTERFACE
Subobject Name:
Status:	VALID

PON_ITEM_PRICES_INTERFACE temporarily stores negotiation item information that the negotiation owner is uploading from a spreadsheet. Once the information is uploaded the interface is processed and the errors are reported in PON_INTERFACE_ERRORS
It is used by auctions and RFQs

Storage Details

Tablespace:	APPS_TS_INTERFACE
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
PON_ITEM_PRICES_INTERFACE_N1	NORMAL	NONUNIQUE	APPS_TS_INTERFACE	BATCH_ID#1 CATEGORY_NAME
PON_ITEM_PRICES_INTERFACE_N2	NORMAL	NONUNIQUE	APPS_TS_INTERFACE	BATCH_ID#1 ITEM_DESCRIPTION
PON_ITEM_PRICES_INTERFACE_N3	NORMAL	NONUNIQUE	APPS_TS_INTERFACE	BATCH_ID#1 UNIT_OF_MEASURE
PON_ITEM_PRICES_INTERFACE_N5	NORMAL	NONUNIQUE	APPS_TS_INTERFACE	BATCH_ID#1 INTERFACE_LINE_ID
PON_ITEM_PRICES_INTERFACE_N6	NORMAL	NONUNIQUE	APPS_TS_INTERFACE	BATCH_ID#1 SHIP_TO_LOCATION_ID SHIP_TO_LOCATION
PON_ITEM_PRICES_INTERFACE_N7	NORMAL	NONUNIQUE	APPS_TS_INTERFACE	BATCH_ID#1 LINE_TYPE
PON_ITEM_PRICES_INTERFACE_N8	NORMAL	NONUNIQUE	APPS_TS_INTERFACE	BATCH_ID#1 ACTION

Columns

Name	Datatype	Length	Mandatory	Comments
INTERFACE_LINE_ID	NUMBER			Interface line ID
INTERFACE_TYPE	VARCHAR2	(30)		Interface type
AUCTION_LINE_NUMBER	NUMBER			Auction Line Item
ITEM_DESCRIPTION	VARCHAR2	(2500)		Item description
CATEGORY_ID	NUMBER			Unique Identifier for category
CATEGORY_NAME	VARCHAR2	(2000)		Category name
UNIT_OF_MEASURE	VARCHAR2	(25)		Unit of Measure of item
CURRENCY_CODE	VARCHAR2	(15)		Code for currency
QUANTITY	NUMBER			Quantity
UOM_CODE	VARCHAR2	(3)		Code for unit of measure
PRICE	NUMBER			Price
PROMISED_DATE	DATE			Date the items are promised to be delivered by bidder
NEED_BY_DATE	DATE			Date the items are needed to be delivered
TARGET_PRICE	NUMBER			Target price of auctioneer
THRESHOLD_PRICE	NUMBER			Threshold price
BID_START_PRICE	NUMBER			Start price of bidding
NOTE_TO_BIDDERS	VARCHAR2	(4000)		Note to bidders
NOTE_TO_AUCTION_OWNER	VARCHAR2	(4000)		Note to auction owner
SHIP_TO_LOCATION_ID	NUMBER			Location Identifier to which auction items will be shipped
CURRENT_PRICE	NUMBER			Current price being paid by purchaser
RESERVE_PRICE	NUMBER			Reserve price
DISPLAY_TARGET_FLAG	VARCHAR2	(1)		Y or N flag to indicate that target price should be displayed to bidders
INTERFACE_ITEM_TYPE	VARCHAR2	(10)		Item type
INTERFACE_LOT_LINE_ID	NUMBER			No longer used
PO_MIN_REL_AMOUNT	NUMBER			Purchase order minimum release amount
PO_RCPT_TOLERANCE_PCT	NUMBER			Not currently used
NUM_DAYS_EARLY	NUMBER			Not currently used
NUM_DAYS_LATE	NUMBER			Not currently used
SHIP_TO_LOCATION	VARCHAR2	(240)		Name of address location for shipping items
DISPLAY_TARGET_PRICE_FLAG	VARCHAR2	(1)		whether to display target price to bidders
BID_CURRENCY_LIMIT_PRICE	NUMBER			Proxy bid limit price in bid currency
PROXY_BID_LIMIT_PRICE	NUMBER			proxy bid limit price in auction currency
BID_CURRENCY_PRICE	NUMBER			bid price in bid currency
ATTACHMENT_URL	VARCHAR2	(255)		URL type attachment
ATTACHMENT_DESC	VARCHAR2	(255)		Description for URL attachment
ACTION	VARCHAR2	(2)		action code used for multi round to add, delete or modify
NEED_BY_START_DATE	DATE			need by start date
LINE_TYPE	VARCHAR2	(25)		Line Type for the upload item
LINE_TYPE_ID	NUMBER			PK to PO_LINE_TYPES
LINE_ORIGINATION_CODE	VARCHAR2	(50)		source of line
ORDER_TYPE_LOOKUP_CODE	VARCHAR2	(25)		Line type for line, services or quantity
ITEM_NUMBER	VARCHAR2	(820)		Item Number
ITEM_REVISION	VARCHAR2	(3)		Item Revision
ITEM_ID	NUMBER			Unique item identifier
ALLOW_ITEM_DESC_UPDATE_FLAG	VARCHAR2	(1)		Indicates if the item description can be modified
PRICE_AND_QUANTITY_APPLY	VARCHAR2	(1)		Indicates whether price and quantity apply
DISP_LINE_NUMBER	NUMBER			Negotiation Item's Display Line Number
ADDITIONAL_JOB_DETAILS	VARCHAR2	(2000)		Additional Job Details
PO_AGREED_AMOUNT	NUMBER			Purchasing Agreed Amount
DIFFERENTIAL_RESPONSE_TYPE	VARCHAR2	(20)		Price Differential Response Type
PURCHASE_BASIS	VARCHAR2	(25)		Purchase Basis for the line type
JOB_ID	NUMBER			Job Id
UNIT_TARGET_PRICE	NUMBER			The target price for auction item unit price.
UNIT_DISPLAY_TARGET_FLAG	VARCHAR2	(1)		Indicates whether display target price of unit price to suppliers
GROUP_TYPE	VARCHAR2	(25)	Yes	Type of Line
PARENT_LINE_NUMBER	NUMBER			Line Number of Parent Lot/Group
DOCUMENT_DISP_LINE_NUMBER	VARCHAR2	(25)		Document Line Number to display (e.g. 2.1)
ADVANCE_AMOUNT	NUMBER			Amount that may be paid in advance for this line
RECOUPMENT_RATE_PERCENT	NUMBER			Percentage of the amount of each invoice for this line that can be recouped when financing or advances are provided to the supplier.
PROGRESS_PYMT_RATE_PERCENT	NUMBER			Percentage of the amount that will be due to the Supplier upon fulfillment of a pay item for each invoice for this line
RETAINAGE_RATE_PERCENT	NUMBER			Percentage of the invoice line amount that will be retained until the work is completed and accepted.
MAX_RETAINAGE_AMOUNT	NUMBER			Maximum amount that can be retained across all invoices for this line
WORK_APPROVER_USER_NAME	VARCHAR2	(100)		User name of the person who is responsible for confirming that the supplier has performed work as agreed.
WORK_APPROVER_USER_ID	NUMBER			Work approver user id
PROJECT_NUMBER	VARCHAR2	(25)		Number of the project in Oracle Projects to which the cost of this payment/shipment will be charged
PROJECT_ID	NUMBER			Identifier of the Project corresponding to the PROJECT_NUMBER entered. This is derived here and used for populating the transaction table.
PROJECT_TASK_NUMBER	VARCHAR2	(25)		Number of the task in Oracle Projects to which the cost of this payment/shipment will be charged
PROJECT_TASK_ID	NUMBER			Identifier of the Task corresponding to the PROJECT_TASK_NUMBER entered. This is derived here and used for populating the transaction table.
PROJECT_AWARD_NUMBER	VARCHAR2	(15)		Number of the Award which is association with this payment/shipment. This may be populated only if integration with Oracle Grants is enabled
PROJECT_AWARD_ID	NUMBER			Identifier of the Award corresponding to the PROJECT_AWARD_NUMBER entered. This is derived here and used for populating the transaction table.
PROJECT_EXPENDITURE_TYPE	VARCHAR2	(30)		Code for the Expenditure type in Oracle Projects associated with this payment/shipment
PROJECT_EXP_ORGANIZATION_NAME	VARCHAR2	(240)		Name of the expenditure organization associated with this payment/shipment
PROJECT_EXP_ORGANIZATION_ID	NUMBER			Identifier of the Expenditure Organization corresponding to the PROJECT_EXP_ORGANIZATION_NAME entered. This is derived here and used for populating the transaction table.
PROJECT_EXPENDITURE_ITEM_DATE	DATE			Date used for accounting the transaction for this line in Oracle Projects
IP_CATEGORY_NAME	VARCHAR2	(250)		iP category name.
IP_CATEGORY_ID	NUMBER			iP category id.
OUTSIDE_OPERATION_FLAG	VARCHAR2	(1)		Stores whether the line type is for Outside Processing items
SUB_LINE_SEQUENCE_NUMBER	NUMBER			sub line sequence number
LINE_NUM_DISPLAY	VARCHAR2	(100)		CLM Line number display
GROUP_LINE_ID	NUMBER			Line number of corresponding clin
CLM_INFO_FLAG	VARCHAR2	(1)		Indicates whether the line is priced or informational
CLM_OPTION_INDICATOR	VARCHAR2	(1)		Indicates whether the line is optional or base line
CLM_BASE_LINE_NUM	NUMBER			Line number of corresponding base line for optional lines
CLM_OPTION_NUM	NUMBER			CLM Option line number
CLM_OPTION_FROM_DATE	DATE			Option from date
CLM_OPTION_TO_DATE	DATE			Option to date
CLM_FUNDED_FLAG	VARCHAR2	(1)		Indicates if the line is funded
CLM_NEED_BY_DATE	DATE			Date the items are needed to be delivered. Used only for CLM.
CLM_IDC_TYPE	VARCHAR2	(100)
CLM_COST_CONSTRAINT	VARCHAR2	(100)
CLM_CONTRACT_TYPE	VARCHAR2	(100)
INTERFACE_HEADER_ID	NUMBER
CLM_AMOUNT	NUMBER
CLM_UNIT_PRICE	NUMBER
UDA_TEMPLATE_ID	NUMBER
PRICE_BREAK_TYPE	VARCHAR2	(2000)		Type of Price Break
PRICE_BREAK_NEG_FLAG	VARCHAR2	(2000)		Are Price Breaks Negotiable
CLM_DELIVERY_EVENT_CODE	VARCHAR2	(30)		Clm Delivery Event Code Lookup Code
CLM_DELIVERY_EVENT	VARCHAR2	(80)		Clm Delivery Event Code Lookup Meaning
CLM_DELIVERY_PERIOD	NUMBER			Period after the delivery event when the shipment is needed
CLM_DELIVERY_PERIOD_UOM	VARCHAR2	(80)		UoM Lookup Meaning for CLM_DELIVERY_PERIOD
CLM_DELIVERY_PERIOD_UOM_CODE	VARCHAR2	(25)		UoM Lookup Code for CLM_DELIVERY_PERIOD
CLM_POP_DURATION	NUMBER			Duration of the period of performance
CLM_POP_DURATION_UOM	VARCHAR2	(80)		UoM Lookup Meaning for CLM_PERF_DURATION
CLM_POP_DURATION_UOM_CODE	VARCHAR2	(25)		UoM Lookup Code for CLM_PERF_DURATION
BATCH_ID#1	NUMBER			Batch ID of interface
AUCTION_HEADER_ID#1	NUMBER			Auction Header Identifier

Query Text

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


SELECT INTERFACE_LINE_ID
,      INTERFACE_TYPE
,      AUCTION_LINE_NUMBER
,      ITEM_DESCRIPTION
,      CATEGORY_ID
,      CATEGORY_NAME
,      UNIT_OF_MEASURE
,      CURRENCY_CODE
,      QUANTITY
,      UOM_CODE
,      PRICE
,      PROMISED_DATE
,      NEED_BY_DATE
,      TARGET_PRICE
,      THRESHOLD_PRICE
,      BID_START_PRICE
,      NOTE_TO_BIDDERS
,      NOTE_TO_AUCTION_OWNER
,      SHIP_TO_LOCATION_ID
,      CURRENT_PRICE
,      RESERVE_PRICE
,      DISPLAY_TARGET_FLAG
,      INTERFACE_ITEM_TYPE
,      INTERFACE_LOT_LINE_ID
,      PO_MIN_REL_AMOUNT
,      PO_RCPT_TOLERANCE_PCT
,      NUM_DAYS_EARLY
,      NUM_DAYS_LATE
,      SHIP_TO_LOCATION
,      DISPLAY_TARGET_PRICE_FLAG
,      BID_CURRENCY_LIMIT_PRICE
,      PROXY_BID_LIMIT_PRICE
,      BID_CURRENCY_PRICE
,      ATTACHMENT_URL
,      ATTACHMENT_DESC
,      ACTION
,      NEED_BY_START_DATE
,      LINE_TYPE
,      LINE_TYPE_ID
,      LINE_ORIGINATION_CODE
,      ORDER_TYPE_LOOKUP_CODE
,      ITEM_NUMBER
,      ITEM_REVISION
,      ITEM_ID
,      ALLOW_ITEM_DESC_UPDATE_FLAG
,      PRICE_AND_QUANTITY_APPLY
,      DISP_LINE_NUMBER
,      ADDITIONAL_JOB_DETAILS
,      PO_AGREED_AMOUNT
,      DIFFERENTIAL_RESPONSE_TYPE
,      PURCHASE_BASIS
,      JOB_ID
,      UNIT_TARGET_PRICE
,      UNIT_DISPLAY_TARGET_FLAG
,      GROUP_TYPE
,      PARENT_LINE_NUMBER
,      DOCUMENT_DISP_LINE_NUMBER
,      ADVANCE_AMOUNT
,      RECOUPMENT_RATE_PERCENT
,      PROGRESS_PYMT_RATE_PERCENT
,      RETAINAGE_RATE_PERCENT
,      MAX_RETAINAGE_AMOUNT
,      WORK_APPROVER_USER_NAME
,      WORK_APPROVER_USER_ID
,      PROJECT_NUMBER
,      PROJECT_ID
,      PROJECT_TASK_NUMBER
,      PROJECT_TASK_ID
,      PROJECT_AWARD_NUMBER
,      PROJECT_AWARD_ID
,      PROJECT_EXPENDITURE_TYPE
,      PROJECT_EXP_ORGANIZATION_NAME
,      PROJECT_EXP_ORGANIZATION_ID
,      PROJECT_EXPENDITURE_ITEM_DATE
,      IP_CATEGORY_NAME
,      IP_CATEGORY_ID
,      OUTSIDE_OPERATION_FLAG
,      SUB_LINE_SEQUENCE_NUMBER
,      LINE_NUM_DISPLAY
,      GROUP_LINE_ID
,      CLM_INFO_FLAG
,      CLM_OPTION_INDICATOR
,      CLM_BASE_LINE_NUM
,      CLM_OPTION_NUM
,      CLM_OPTION_FROM_DATE
,      CLM_OPTION_TO_DATE
,      CLM_FUNDED_FLAG
,      CLM_NEED_BY_DATE
,      CLM_IDC_TYPE
,      CLM_COST_CONSTRAINT
,      CLM_CONTRACT_TYPE
,      INTERFACE_HEADER_ID
,      CLM_AMOUNT
,      CLM_UNIT_PRICE
,      UDA_TEMPLATE_ID
,      PRICE_BREAK_TYPE
,      PRICE_BREAK_NEG_FLAG
,      CLM_DELIVERY_EVENT_CODE
,      CLM_DELIVERY_EVENT
,      CLM_DELIVERY_PERIOD
,      CLM_DELIVERY_PERIOD_UOM
,      CLM_DELIVERY_PERIOD_UOM_CODE
,      CLM_POP_DURATION
,      CLM_POP_DURATION_UOM
,      CLM_POP_DURATION_UOM_CODE
,      BATCH_ID#1
,      AUCTION_HEADER_ID#1
FROM PON.PON_ITEM_PRICES_INTERFACE;

Dependencies

[top of page]

PON.PON_ITEM_PRICES_INTERFACE does not reference any database object

PON.PON_ITEM_PRICES_INTERFACE is referenced by following:

PON: PON_ITEM_PRICES_INTERFACE#