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

VIEW: APPS.ITG_SP_REL_HEADERS_V

Object Details
Object Name: ITG_SP_REL_HEADERS_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewITG.ITG_SP_REL_HEADERS_V
Subobject Name:
Status: VALID


This view is used to generate XML at the PO release headers level for Sync PO Release XML


[View Source]

Columns
Name Datatype Length Mandatory Comments
PO_HEADER_ID NUMBER
Yes
PO_RELEASE_ID NUMBER
Yes
DATETIME_DOCUMENT DATE

OPERAMT_EXTENDED NUMBER

OPERAMT_CURRENCY VARCHAR2 (15)
POID VARCHAR2 (20) Yes
BUYERID VARCHAR2 (240)
DELIVERTO VARCHAR2 (60)
NOTES VARCHAR2 (240)
POENTITY VARCHAR2 (40)
PORELEASE NUMBER
Yes
POSTATUS VARCHAR2 (25)
POTYPE VARCHAR2 (25) Yes
TAXWHEXMPT VARCHAR2 (0)
TO_PO_INTERNAL VARCHAR2 (0)
TO_MISC VARCHAR2 (0)
TO_APPROVER VARCHAR2 (0)
TO_BUYER VARCHAR2 (0)
TO_PAYABLES VARCHAR2 (0)
TO_RECEIVER VARCHAR2 (0)
TO_SUPPLIER VARCHAR2 (0)
Query Text

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


SELECT PO_HEADER_ID
,      PO_RELEASE_ID
,      DATETIME_DOCUMENT
,      OPERAMT_EXTENDED
,      OPERAMT_CURRENCY
,      POID
,      BUYERID
,      DELIVERTO
,      NOTES
,      POENTITY
,      PORELEASE
,      POSTATUS
,      POTYPE
,      TAXWHEXMPT
,      TO_PO_INTERNAL
,      TO_MISC
,      TO_APPROVER
,      TO_BUYER
,      TO_PAYABLES
,      TO_RECEIVER
,      TO_SUPPLIER
FROM APPS.ITG_SP_REL_HEADERS_V;

Dependencies

[top of page]

APPS.ITG_SP_REL_HEADERS_V references the following:

SchemaAPPS
PL/SQL PackageHR_GENERAL - show dependent code
SynonymHR_LOCATIONS_ALL
PL/SQL PackageHR_PERSON_NAME - show dependent code
PL/SQL PackageHR_SECURITY - show dependent code
PL/SQL PackageITG_X_UTILS - show dependent code
ViewPER_PEOPLE_F
SynonymPO_HEADERS_ALL
SynonymPO_RELEASES_ALL

APPS.ITG_SP_REL_HEADERS_V is not referenced by any database object