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_AWD_REFS_V

Object Details

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

[View Source]

Columns

Name	Datatype	Length	Comments
REQUISITION_HEADER_ID	NUMBER		Requisition header unique identifier
REQUISITION_LINE_ID	NUMBER		Requisition line unique identifier
REQUISITION_NUMBER	VARCHAR2	(20)	Line number
LINE_NUMBER	VARCHAR2	(100)	Line number
PO_HEADER_ID	NUMBER		Document header unique identifier
PO_LINE_ID	NUMBER		Document line unique identifier (References PO_LINES_ALL.po_line_id). For Release Shipments, this references the unique line identifier of Blanket PO
LINE_LOCATION_ID	NUMBER		Document shipment schedule unique identifier
CLM_DOCUMENT_NUMBER	VARCHAR2	(50)	Line number
AUTHORIZATION_STATUS	VARCHAR2	(25)	Authorization status of the purchase order (References PO_LOOKUP_CODES.lookup_code with LOOKUP_TYPE='AUTHORIZATION STATUS')
AGENT_ID	NUMBER		Reference to the HR Job
USER_HOLD_FLAG	VARCHAR2	(1)	Indicates whether the purchase order is on hold or not
CREATION_DATE	DATE		Standard who column - date when this row was created.
VENDOR_ID	NUMBER		Supplier unique identifier (References PO_VENDORS.vendor_id)
VENDOR_SITE_ID	NUMBER		Supplier site unique identifier (References PO_VENDOR_SITES_ALL.vendor_site_id)
VENDOR_CONTACT_ID	NUMBER		Supplier contact unique identifier (References PO_VENDOR_CONTACTS.vendor_contact_id)
ORG_ID	NUMBER		Document line unique identifier (References PO_LINES_ALL.po_line_id). For Release Shipments, this references the unique line identifier of Blanket PO
ACCEPTANCE_REQUIRED_FLAG	VARCHAR2	(1)	Indicates whether acceptance from the supplier is required or not
ACCEPTANCE_DUE_DATE	DATE		Date by which the supplier should accept the purchase order
REPLY_DATE	DATE		RFQ and Quotation only: Date the supplier replied to the RFQ
REPLY_METHOD_LOOKUP_CODE	VARCHAR2	(25)	RFQ and Quotation only: Method the supplier should use to reply to the RFQ
CURRENCY_CODE	VARCHAR2	(15)	Unique identifier for the currency (References FND_CURRENCIES.currency_code)
HEADER_CANCEL_FLAG	VARCHAR2	(1)	Indicates whether the shipment is cancelled or not
CANCEL_FLAG	VARCHAR2	(1)	Indicates whether the shipment is cancelled or not
SHIPMENT_TYPE	VARCHAR2	(25)	Type of the shipment
CLOSED_CODE	VARCHAR2	(30)	Closure status of the shipment
RECEIVING_ROUTING_ID	NUMBER		Receipt routing unique identifier(References RCV_ROUTING_HEADERS.routing_header_id)
VMI_FLAG	VARCHAR2	(1)	Indicates VMI shipment line with value = 'Y'
CONSIGNED_FLAG	VARCHAR2	(1)	Indicates shipment is consigned
DROP_SHIP_FLAG	VARCHAR2	(1)	Indicates whether the Shipment has a backing Sales Order Line.
TRANSACTION_FLOW_HEADER_ID	NUMBER		Transaction flow header identifier(References MTL_TRANSACTION_FLOW_HEADERS.header_id)
SHIPMENT_CLOSED_DATE	DATE		Date when the Shipment is closed for both Receiving and Invoice
VALUE_BASIS	VARCHAR2	(25)	Value basis of the line location
MATCHING_BASIS	VARCHAR2	(30)	Matching basis of the line location
PAYMENT_TYPE	VARCHAR2	(30)	Pay Item type
APPROVED_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
,      PO_HEADER_ID
,      PO_LINE_ID
,      LINE_LOCATION_ID
,      CLM_DOCUMENT_NUMBER
,      AUTHORIZATION_STATUS
,      AGENT_ID
,      USER_HOLD_FLAG
,      CREATION_DATE
,      VENDOR_ID
,      VENDOR_SITE_ID
,      VENDOR_CONTACT_ID
,      ORG_ID
,      ACCEPTANCE_REQUIRED_FLAG
,      ACCEPTANCE_DUE_DATE
,      REPLY_DATE
,      REPLY_METHOD_LOOKUP_CODE
,      CURRENCY_CODE
,      HEADER_CANCEL_FLAG
,      CANCEL_FLAG
,      SHIPMENT_TYPE
,      CLOSED_CODE
,      RECEIVING_ROUTING_ID
,      VMI_FLAG
,      CONSIGNED_FLAG
,      DROP_SHIP_FLAG
,      TRANSACTION_FLOW_HEADER_ID
,      SHIPMENT_CLOSED_DATE
,      VALUE_BASIS
,      MATCHING_BASIS
,      PAYMENT_TYPE
,      APPROVED_DATE
FROM APPS.PO_CLMREQ_LINE_AWD_REFS_V;

Dependencies

[top of page]

APPS.PO_CLMREQ_LINE_AWD_REFS_V references the following:

APPS: PO_DISTRIBUTIONS_ALL; PO_HEADERS_ALL; PO_HEADERS_ALL_SEC; PO_LINES_ALL; PO_LINE_LOCATIONS_ALL; PO_REQUISITION_HEADERS_CLM_V; PO_REQUISITION_LINES_ALL; PO_REQ_DISTRIBUTIONS_ALL

APPS.PO_CLMREQ_LINE_AWD_REFS_V is referenced by following:

APPS: POR_AMENDMENT_PKG - show dependent code; POR_RCV_POST_QUERY_PKG - show dependent code; POR_UTIL_PKG - show dependent code; POR_VIEW_REQS_PKG - show dependent code; PO_DOCUMENT_FUNDS_GRP - show dependent code