DBA Data[Home] [Help] [Dependency Information]

VIEW: APPS.PO_REQ_LINES_IN_POOL_SRC_V

Object Details
Object Name: PO_REQ_LINES_IN_POOL_SRC_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewPO.PO_REQ_LINES_IN_POOL_SRC_V
Subobject Name:
Status: VALID

View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.

[View Source]

Columns
Name Datatype Length Mandatory Comments
REQUISITION_HEADER_ID NUMBER
Yes
REQUISITION_NUMBER VARCHAR2 (20) Yes
REQUISITION_LINE_ID NUMBER
Yes REQUISITION_LINE_ID
REQUISITION_LINE_NUM NUMBER
Yes REQUISITION_LINE_NUM
REQUISITION_QUANTITY NUMBER

REQUISITION_QUANTITY
NEED_BY_DATE DATE

NEED_BY_DATE
CREATION_DATE DATE

Standard who column - date when this row was created.
MODIFIED_BY_AGENT_FLAG VARCHAR2 (1)
MODIFIED_BY_AGENT_FLAG
AUCTION_HEADER_ID NUMBER

AUCTION_HEADER_ID
AUCTION_LINE_NUMBER NUMBER

AUCTION_LINE_NUMBER
ORG_ID NUMBER

Organization identifier
PROJECT_NUMBER VARCHAR2 (25)
PROJECT_NUMBER
TASK_NUMBER VARCHAR2 (25)
TASK_NUMBER
Query Text

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


SELECT REQUISITION_HEADER_ID
,      REQUISITION_NUMBER
,      REQUISITION_LINE_ID
,      REQUISITION_LINE_NUM
,      REQUISITION_QUANTITY
,      NEED_BY_DATE
,      CREATION_DATE
,      MODIFIED_BY_AGENT_FLAG
,      AUCTION_HEADER_ID
,      AUCTION_LINE_NUMBER
,      ORG_ID
,      PROJECT_NUMBER
,      TASK_NUMBER
FROM APPS.PO_REQ_LINES_IN_POOL_SRC_V;

Dependencies

[top of page]

APPS.PO_REQ_LINES_IN_POOL_SRC_V references the following:

SchemaAPPS
SynonymPA_PROJECTS_ALL
SynonymPA_TASKS
SynonymPJM_SEIBAN_NUMBERS
SynonymPO_REQUISITION_HEADERS_ALL
SynonymPO_REQUISITION_LINES_ALL
SynonymPO_REQ_DISTRIBUTIONS_ALL
APPS.PO_REQ_LINES_IN_POOL_SRC_V is referenced by following:

SchemaAPPS
Package BodyPON_AUCTION_CREATE_PO_PKG - show dependent code