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

Object Details

Object Name:	POBV_REQUISITIONS
Object Type:	VIEW
Owner:	APPS
FND Design Data:	PO.POBV_REQUISITIONS
Subobject Name:
Status:	VALID

View Type

A Business Intelligence System view

This shows internal requests for goods or services. A requisition can originate from an employee or from another source, such as inventory or manufacturing.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
REQUISITION_ID	NUMBER		Yes
DOCUMENT_NUMBER	VARCHAR2	(20)	Yes
OPERATING_UNIT_ID	NUMBER
OPERATING_UNIT_NAME	VARCHAR2	(240)	Yes
_LA:REQUISITION_TYPE	CHAR	(72)
_LA:AUTHORIZATION_STATUS	CHAR	(80)
AUTHORIZER_NOTE	VARCHAR2	(4000)
_LA:CLOSURE_STATUS	CHAR	(65)
DESCRIPTION	VARCHAR2	(240)
EMERGENCY_PO_NUMBER	VARCHAR2	(20)
_LA:TRANSFERRED_TO_OE_FLAG	CHAR	(68)
USSGL_TRANSACTION_CODE	VARCHAR2	(30)
PREPARER_ID	NUMBER	(9)	Yes
CREATED_DATE	DATE
CREATED_BY	NUMBER			Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
LAST_UPDATED_DATE	DATE		Yes
LAST_UPDATED_BY	NUMBER		Yes	Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
_LA:CANCEL_FLAG	CHAR	(57)
CBC_ACCOUNTING_DATE	DATE
_LA:CHANGE_PENDING_FLAG	CHAR	(65)
APPS_SOURCE_CODE	VARCHAR2	(25)
EMERGENCY_PO_NUM	VARCHAR2	(20)
PCARD_ID	NUMBER	(15)
CONTRACTOR_STATUS	VARCHAR2	(25)		The status of the resource finalization process for temp labor reqs
CONTRACTOR_REQUISITION_FLAG	VARCHAR2	(1)		Flag to indicate whether the requisition is a regular req or a temp labor req
APPROVED_DATE	DATE

Query Text

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


SELECT REQUISITION_ID
,      DOCUMENT_NUMBER
,      OPERATING_UNIT_ID
,      OPERATING_UNIT_NAME
,      _LA:REQUISITION_TYPE
,      _LA:AUTHORIZATION_STATUS
,      AUTHORIZER_NOTE
,      _LA:CLOSURE_STATUS
,      DESCRIPTION
,      EMERGENCY_PO_NUMBER
,      _LA:TRANSFERRED_TO_OE_FLAG
,      USSGL_TRANSACTION_CODE
,      PREPARER_ID
,      CREATED_DATE
,      CREATED_BY
,      LAST_UPDATED_DATE
,      LAST_UPDATED_BY
,      _LA:CANCEL_FLAG
,      CBC_ACCOUNTING_DATE
,      _LA:CHANGE_PENDING_FLAG
,      APPS_SOURCE_CODE
,      EMERGENCY_PO_NUM
,      PCARD_ID
,      CONTRACTOR_STATUS
,      CONTRACTOR_REQUISITION_FLAG
,      APPROVED_DATE
FROM APPS.POBV_REQUISITIONS;

Dependencies

[top of page]

APPS.POBV_REQUISITIONS references the following:

APPS: HR_ALL_ORGANIZATION_UNITS; PO_REQUISITION_HEADERS_ALL

APPS.POBV_REQUISITIONS is not referenced by any database object