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


VIEW: APPS.AP_HOLDS_V

Object Details
Object Name: AP_HOLDS_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewSQLAP.AP_HOLDS_V
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
ATTRIBUTE1 VARCHAR2 (150)
ATTRIBUTE10 VARCHAR2 (150)
ATTRIBUTE11 VARCHAR2 (150)
ATTRIBUTE12 VARCHAR2 (150)
ATTRIBUTE13 VARCHAR2 (150)
ATTRIBUTE14 VARCHAR2 (150)
ATTRIBUTE15 VARCHAR2 (150)
ATTRIBUTE2 VARCHAR2 (150)
ATTRIBUTE3 VARCHAR2 (150)
ATTRIBUTE4 VARCHAR2 (150)
ATTRIBUTE5 VARCHAR2 (150)
ATTRIBUTE6 VARCHAR2 (150)
ATTRIBUTE7 VARCHAR2 (150)
ATTRIBUTE8 VARCHAR2 (150)
ATTRIBUTE9 VARCHAR2 (150)
ATTRIBUTE_CATEGORY VARCHAR2 (150)
CREATED_BY NUMBER (15)
CREATION_DATE DATE

HELD_BY NUMBER (15) Yes
HOLD_DATE DATE
Yes
HOLD_LOOKUP_CODE VARCHAR2 (25) Yes
HOLD_REASON VARCHAR2 (240)
INVOICE_ID NUMBER (15) Yes
LAST_UPDATED_BY NUMBER (15) Yes
LAST_UPDATE_DATE DATE
Yes
LAST_UPDATE_LOGIN NUMBER (15)
LINE_LOCATION_ID NUMBER (15)
RELEASE_LOOKUP_CODE VARCHAR2 (25)
RELEASE_REASON VARCHAR2 (240)
STATUS_FLAG VARCHAR2 (25)
RESPONSIBILITY_ID NUMBER (15)
ORG_ID NUMBER (15)
USER_RELEASEABLE_FLAG VARCHAR2 (1)
USER_UPDATEABLE_FLAG VARCHAR2 (1)
POSTABLE_FLAG VARCHAR2 (1)
HOLD_NAME VARCHAR2 (80)
HOLD_TYPE VARCHAR2 (80)
RELEASE_NAME VARCHAR2 (80)
USER_NAME_SYSTEM VARCHAR2 (80)
INVOICE_NUM VARCHAR2 (50) Yes
HELD_BY_USER_NAME VARCHAR2 (100)
RELEASE_BY_USER_NAME VARCHAR2 (100)
RELEASE_DATE VARCHAR2 (9)
PO_NUMBERS VARCHAR2 (50)
PO_LINE_NUM VARCHAR2 (240)
SHIP_TO_LOCATION VARCHAR2 (60)
PO_HEADER_ID NUMBER

PO_LINE_ID NUMBER

PO_LINE_LOCATION_ID NUMBER

SHIPMENT_ORDERED NUMBER

SHIPMENT_BILLED NUMBER

SHIPMENT_RECEIVED NUMBER

SHIPMENT_ACCEPTED NUMBER

PO_RELEASE_ID NUMBER

PO_RELEASE_NUMBER NUMBER

RECEIPT_TXN_DATE DATE

RECEIPT_LINE_NUMBER NUMBER

RECEIPT_NUMBER VARCHAR2 (30)
RECEIPT_RECEIVED NUMBER

RECEIPT_BILLED NUMBER

RECEIPT_ACCEPTED NUMBER

MATCHING_BASIS VARCHAR2 (30)
HOLD_ID NUMBER (15) Yes
WF_STATUS_DISPLAY VARCHAR2 (80)
WF_STATUS VARCHAR2 (30)
Query Text

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


SELECT ROW_ID
,      ATTRIBUTE1
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE_CATEGORY
,      CREATED_BY
,      CREATION_DATE
,      HELD_BY
,      HOLD_DATE
,      HOLD_LOOKUP_CODE
,      HOLD_REASON
,      INVOICE_ID
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      LINE_LOCATION_ID
,      RELEASE_LOOKUP_CODE
,      RELEASE_REASON
,      STATUS_FLAG
,      RESPONSIBILITY_ID
,      ORG_ID
,      USER_RELEASEABLE_FLAG
,      USER_UPDATEABLE_FLAG
,      POSTABLE_FLAG
,      HOLD_NAME
,      HOLD_TYPE
,      RELEASE_NAME
,      USER_NAME_SYSTEM
,      INVOICE_NUM
,      HELD_BY_USER_NAME
,      RELEASE_BY_USER_NAME
,      RELEASE_DATE
,      PO_NUMBERS
,      PO_LINE_NUM
,      SHIP_TO_LOCATION
,      PO_HEADER_ID
,      PO_LINE_ID
,      PO_LINE_LOCATION_ID
,      SHIPMENT_ORDERED
,      SHIPMENT_BILLED
,      SHIPMENT_RECEIVED
,      SHIPMENT_ACCEPTED
,      PO_RELEASE_ID
,      PO_RELEASE_NUMBER
,      RECEIPT_TXN_DATE
,      RECEIPT_LINE_NUMBER
,      RECEIPT_NUMBER
,      RECEIPT_RECEIVED
,      RECEIPT_BILLED
,      RECEIPT_ACCEPTED
,      MATCHING_BASIS
,      HOLD_ID
,      WF_STATUS_DISPLAY
,      WF_STATUS
FROM APPS.AP_HOLDS_V;

Dependencies

[top of page]

APPS.AP_HOLDS_V references the following:

SchemaAPPS
SynonymAP_HOLDS
SynonymAP_HOLD_CODES
SynonymAP_INVOICES_ALL
ViewAP_LOOKUP_CODES
PL/SQL PackageFND_GLOBAL - show dependent code
SynonymFND_USER
PL/SQL PackageHR_GENERAL - show dependent code
ViewHR_LOCATIONS
SynonymPO_HEADERS_ALL
SynonymPO_LINES_ALL
SynonymPO_LINE_LOCATIONS_ALL
SynonymPO_LINE_TYPES
SynonymPO_RELEASES_ALL
SynonymRCV_SHIPMENT_HEADERS
SynonymRCV_SHIPMENT_LINES
SynonymRCV_TRANSACTIONS

APPS.AP_HOLDS_V is not referenced by any database object