Oracle eBusiness Suite Technical Reference

Release 11i - Copyright (c) 2001 - 2005 Oracle

This Technical Reference Manual (TRM) in any form, software or printed matter, contains proprietary information of Oracle ; it is provided under an Oracle agreement containing restrictions on use and disclosure and is also protected by copyright, patent, and other intellectual property law. Restrictions applicable to this TRM include, but are not limited to: (a) exercising either the same degree of care to safeguard the confidentiality of this TRM as you exercise to safeguard the confidentiality of your own most important Confidential Information or a reasonable degree of care, whichever is greater; (b) maintaining agreements with your employees and agents that protect the Confidential Information of third parties such as Oracle and instructing such employees and agents of these requirements for this TRM; (c) restricting disclosure of this TRM to those of your employees who have a 'need to know' consistent with the purposes for which this TRM was disclosed to you; (d) maintaining this TRM at all times on your premises; (e) not removing or destroying any proprietary or confidential legends or markings placed upon this TRM in whatever form, software or printed matter; and (f) not reproducing or transmitting this TRM in any form or by any means, electronic or mechanical, for any purpose, without the express written permission of Oracle. You should not use this TRM in any form, software or printed matter, to create software that performs the same or similar functions as any Oracle products.

The information in this TRM is subject to change without notice. If you find any problems in the TRM in any form, software or printed matter, please report them to us in writing. Oracle does not warrant that this TRM is error free. This TRM is provided to customer 'as is' with no warranty of any kind. This TRM does not constitute Documentation as that term is defined in Oracle's agreements. Reverse engineering of the Programs (software and documentation) associated with this TRM are prohibited. The Programs associated with this TRM are not intended for use in any nuclear, aviation, mass transit, medical, or other inherently dangerous applications. It shall be licensee's responsibility to take all appropriate fail safe, backup, redundancy and other measures to ensure the safe use of such applications if the Programs are used for such purposes, and Oracle disclaims liability for any damages caused by such use of the Programs. Program Documentation is licensed for use solely to support the deployment of the Programs and not for any other any other purpose. Restricted Rights Legend

This TRM and the Programs associated with this TRM delivered subject to the DOD FAR Supplement are 'commercial computer software' and use, duplication and disclosure of the TRM and the Programs associated with this TRM shall be subject to the licensing restrictions set forth in the applicable Oracle license agreement. Otherwise, this TRM and the Programs associated with this TRM delivered subject to the Federal Acquisition Regulations are 'restricted computer software' and use, duplication and disclosure of the TRM and the Programs associated with this TRM shall be subject to the restrictions in FAR 52.227-14, Rights in Data General, including Alternate III (June 1987). Oracle, 500 Oracle Parkway, Redwood City, CA 94065.

Oracle is a registered trademark. AIM Advantage™, Big Business. Small Business. All Business.™, CDM Advantage™, .comference™, ConText®, Des40®, Easy*Query™, Easy*SQL®, Education Objects™, EMM Advantage™, Enabling the Information Age®, ExpertDetectSM, Express®, FastForwardSM, GEMMS®, Gist™, Hyper*SQL™, instantOracle™, "Internet Business Intelligence - Insight for Everyone"™, iSQL*Plus™, JInitiator™, NLS*Workbench®, Object Marketplace™, ODP Pulse™, ODP Techwire™, OLA™, On Oracle™, Oracle®, Oracle Book®, Oracle Bookbatch®, Oracle BookBuilder®, OracleBRONZE®, Oracle Business OnLine®, OracleDevConnectSM, Oracle® Discoverer™, Oracle® Expert™, Oracle Financials®, OracleGOLDSM, OracleIncidentSM, OracleJSP™, OracleLifeCycleSM, Oracle Media Objects®, OracleMERCURYSM, OracleMetaLinkSM, OraclemetalsSM, OracleMobile™, Oracle Names®, Oracle NetSolutions®, Oracle® One™, Oracle Open Gateways®, Oracle OpenWorld®, OraclePLATINUMSM, Oracle Power Objects®, Oracle Press®, Oracle Procedural Gateway®, Oracle Quality®, Oracle Secure Network Services®, OracleSILVERSM, Oracle® SQL/Services™, Oracle® SQL*TutorSM, OracleSTERLINGSM, Oracle Store®, Oracle Transparent Gateway®, OracleWare®, Oracle8i™, Oracle9i™, PC Express®, Personal Express®, PJM Advantage™, PL/SQL™, Pro*Ada®, Pro*C™, Pro*C/C++™, Pro*COBOL®, Pro*FORTRAN®, Pro*Pascal®, Pro*PL/1®, Pro*REXX®, Profit™, ProREXX™, Report Card™, Secure Access 2.0™, Secure Network Services®, Security Without Compromise™, SellingPoint®, SQL*Plus®, Tutor™ are trademarks or registered trademarks of Oracle. Other names may be trademarks of their respective owners. The absence of a product or service name, slogan, or logo from this list does not constitute a waiver of Oracle's trademark or other intellectual property rights concerning that name, slogan, or logo.

eTRM - ITG Tables and Views

VIEW - APPS.ITG_CPO_PO_HEADERS_V
VIEW - APPS.ITG_CPO_PO_LINES_V
VIEW - APPS.ITG_CPO_PO_SCHED_V
VIEW - APPS.ITG_CPO_REL_HEADERS_V
VIEW - APPS.ITG_CPO_REL_LINES_V
VIEW - APPS.ITG_CPO_REL_SCHED_V
VIEW - APPS.ITG_CREQ_HEADERS_V
VIEW - APPS.ITG_CREQ_LINES_V
VIEW - APPS.ITG_LPI_HEADERS_V
VIEW - APPS.ITG_LPI_LINES_V
VIEW - APPS.ITG_PO_DISTRBN_ARCH_V
VIEW - APPS.ITG_PO_HEADER_ARCH_V
VIEW - APPS.ITG_PO_LINE_ARCH_V
VIEW - APPS.ITG_PO_LINE_LOC_ARCH_V
VIEW - APPS.ITG_REQ_DISTRIBUTIONS_V
VIEW - APPS.ITG_REQ_HEADERS_V
VIEW - APPS.ITG_REQ_LINES_V
VIEW - APPS.ITG_REQ_VENDORS_V
VIEW - APPS.ITG_REQ_VENDOR_CONTACTS_V
VIEW - APPS.ITG_REQ_VENDOR_SITES_V
VIEW - APPS.ITG_SP_PO_HEADERS_V
VIEW - APPS.ITG_SP_PO_LINE_DIST_V
VIEW - APPS.ITG_SP_PO_LINE_PART_EMPL_V
VIEW - APPS.ITG_SP_PO_LINE_PART_SHIPTO_V
VIEW - APPS.ITG_SP_PO_LINE_SCHED_V
VIEW - APPS.ITG_SP_PO_PART_SHIPTO_V
VIEW - APPS.ITG_SP_PO_PART_SOLDTO_V
VIEW - APPS.ITG_SP_PO_PART_SUPPL_V
VIEW - APPS.ITG_SP_PO_POLINE_V
VIEW - APPS.ITG_SP_PO_POTERM_V
VIEW - APPS.ITG_SP_REL_HEADERS_V
VIEW - APPS.ITG_SP_REL_LINE_DIST_V
VIEW - APPS.ITG_SP_REL_LINE_PART_EMPL_V
VIEW - APPS.ITG_SP_REL_LINE_PART_SHIPTO_V
VIEW - APPS.ITG_SP_REL_LINE_SCHED_V
VIEW - APPS.ITG_SP_REL_PART_SHIPTO_V
VIEW - APPS.ITG_SP_REL_PART_SOLDTO_V
VIEW - APPS.ITG_SP_REL_PART_SUPPL_V
VIEW - APPS.ITG_SP_REL_POLINE_V
VIEW - APPS.ITG_SP_REL_POTERM_V
VIEW - APPS.ITG_UPDEL_HEADERS_V
VIEW - APPS.ITG_UPDEL_LINES_V

View: ITG_CPO_PO_HEADERS_V

Comments
View Type

A public view which may be useful for custom reporting or other data requirements.

Creates header, lines and schedule PO views for CANCEL PO 006.

Columns
Name Datatype Length Mandatory Comments
PO_HEADER_ID NUMBER
Y Po header number
POID VARCHAR2 (20) Y Purchase order number
SITELEVEL_1 NUMBER

Site level

[top of page]

APPS.ITG_CPO_PO_HEADERS_V references the following:

APPS
SYNONYM - PO_HEADERS_ALL

APPS.ITG_CPO_PO_HEADERS_V is not referenced by any database object

[top of page]

View: ITG_CPO_PO_LINES_V

Comments
View Type

A public view which may be useful for custom reporting or other data requirements.

View to obtain a few columns of po_lines_all table

Columns
Name Datatype Length Mandatory Comments
PO_LINE_ID NUMBER
Y Purchase order line Id
PO_HEADER_ID NUMBER
Y Purchase order header Id
POLINENUM NUMBER
Y Purchase order line number

[top of page]

APPS.ITG_CPO_PO_LINES_V references the following:

APPS
SYNONYM - PO_LINES_ALL

APPS.ITG_CPO_PO_LINES_V is not referenced by any database object

[top of page]

View: ITG_CPO_PO_SCHED_V

Comments
View Type

A public view which may be useful for custom reporting or other data requirements.

This view is used to generate XML at PO line schedule level for Cancel PO XML

Columns
Name Datatype Length Mandatory Comments
PO_HEADER_ID NUMBER
Y Purchase order header Id
PO_LINE_ID NUMBER
Y Purchase order line Id
LINE_LOCATION_ID NUMBER
Y Line location id
PSCLINENUM NUMBER

Schedule line number

[top of page]

APPS.ITG_CPO_PO_SCHED_V references the following:

APPS
SYNONYM - PO_LINE_LOCATIONS_ALL

APPS.ITG_CPO_PO_SCHED_V is not referenced by any database object

[top of page]

View: ITG_CPO_REL_HEADERS_V

Comments
View Type

A public view which may be useful for custom reporting or other data requirements.

PO RELEASE header view for CANCEL PO 006

Columns
Name Datatype Length Mandatory Comments
PO_HEADER_ID NUMBER
Y Purchase order header Id
PO_RELEASE_ID NUMBER
Y Purchase order release Id
POID VARCHAR2 (20) Y Purchase order number
SITELEVEL_1 NUMBER

Site leve
PORELEASE NUMBER
Y Release number

[top of page]

APPS.ITG_CPO_REL_HEADERS_V references the following:

APPS
SYNONYM - PO_HEADERS_ALL
SYNONYM - PO_RELEASES_ALL

APPS.ITG_CPO_REL_HEADERS_V is not referenced by any database object

[top of page]

View: ITG_CPO_REL_LINES_V

Comments
View Type

A public view which may be useful for custom reporting or other data requirements.

PO RELEASE line view for CANCEL PO 006

Columns
Name Datatype Length Mandatory Comments
PO_LINE_ID NUMBER
Y Purchase order line Id
PO_HEADER_ID NUMBER
Y Purchase order header Id
PO_RELEASE_ID NUMBER
Y Purhcase order release Id
POLINENUM NUMBER
Y Purchase order line number

[top of page]

APPS.ITG_CPO_REL_LINES_V references the following:

APPS
SYNONYM - PO_LINES_ALL
SYNONYM - PO_RELEASES_ALL

APPS.ITG_CPO_REL_LINES_V is not referenced by any database object

[top of page]

View: ITG_CPO_REL_SCHED_V

Comments
View Type

A public view which may be useful for custom reporting or other data requirements.

PO RELEASE schedule view for CANCEL PO 006

Columns
Name Datatype Length Mandatory Comments
PO_HEADER_ID NUMBER
Y Purchase order header Id
PO_LINE_ID NUMBER
Y Purchase order line Id
LINE_LOCATION_ID NUMBER
Y Line location id
PO_RELEASE_ID NUMBER
Y Purchase order release Id
PSCLINENUM NUMBER

Schedule line number

[top of page]

APPS.ITG_CPO_REL_SCHED_V references the following:

APPS
SYNONYM - PO_LINE_LOCATIONS_ALL
SYNONYM - PO_RELEASES_ALL

APPS.ITG_CPO_REL_SCHED_V is not referenced by any database object

[top of page]

View: ITG_CREQ_HEADERS_V

Comments
View Type

A public view which may be useful for custom reporting or other data requirements.

Header view for Cancel Requisition

Columns
Name Datatype Length Mandatory Comments
REQUISITION_HEADER_ID NUMBER
Y Requisition header Id
REQUISTNID VARCHAR2 (20) Y Requisition Number
SITELEVEL1 NUMBER

Site level

[top of page]

APPS.ITG_CREQ_HEADERS_V references the following:

APPS
SYNONYM - PO_REQUISITION_HEADERS_ALL

APPS.ITG_CREQ_HEADERS_V is not referenced by any database object

[top of page]

View: ITG_CREQ_LINES_V

Comments
View Type

A public view which may be useful for custom reporting or other data requirements.

Lines view for Cancel Requisition XML

Columns
Name Datatype Length Mandatory Comments
REQUISITION_HEADER_ID NUMBER
Y Requistion header id
REQUISITION_LINE_ID NUMBER
Y Requisition line Id
REQLINENUM NUMBER
Y Requistion line number
SEGMENT1 VARCHAR2 (20) Y Requisition number
ORG_ID NUMBER

Organization id

[top of page]

APPS.ITG_CREQ_LINES_V references the following:

APPS
SYNONYM - PO_REQUISITION_HEADERS_ALL
SYNONYM - PO_REQUISITION_LINES_ALL

APPS.ITG_CREQ_LINES_V is not referenced by any database object

[top of page]

View: ITG_LPI_HEADERS_V

Comments
***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

Columns
Name Datatype Length Mandatory Comments
INVOICE_ID NUMBER (15) Y
AMOUNT_DOC_T_INVAMOUNT NUMBER

AMOUNT_DOC_T_CURRENCY_CODE VARCHAR2 (15) Y
AMOUNT_DOC_T_LOOKUP_TYPE VARCHAR2 (2)
DOCUMENT_DATETIME DATE

AMOUNT_DOC_F_AMOUNT NUMBER

AMOUNT_DOC_F_CURRENCY_CODE VARCHAR2 (15) Y
AMOUNT_DOC_F_LOOKUP_TYPE VARCHAR2 (2)
GLENTITYS VARCHAR2 (25)
ORIGREF VARCHAR2 (50) Y
DESCRIPTN VARCHAR2 (25)
DOCTYPE VARCHAR2 (25)
LEDGER VARCHAR2 (30) Y
PAYMENT VARCHAR2 (25)
USERID VARCHAR2 (100) Y
VOUCHER NUMBER

SUPPLIER_NAME VARCHAR2 (240)
SUPPLUER_ONETIME VARCHAR2 (1)
SUPPLIER_PARTNRID VARCHAR2 (30) Y
SUPPLIER_PARTNRTYPE CHAR (8)
SUPPLIER_CURRENCY VARCHAR2 (15) Y
SUPPLIER_DESCRIPTN VARCHAR2 (320)
SUPPLIER_PARTNRIDX VARCHAR2 (40)
SUPPLIER_TAXEXMPT VARCHAR2 (1)
SUPPLIER_TAXID VARCHAR2 (20)
SUPPLIER_UA_USFLAG VARCHAR2 (1)
SUPPLIER_ADDRESS_LINE1 VARCHAR2 (240)
SUPPLIER_ADDRESS_LINE2 VARCHAR2 (240)
SUPPLIER_ADDRESS_LINE3 VARCHAR2 (240)
SUPPLIER_ADDRESS_CITY VARCHAR2 (25)
SUPPLIER_ADDRESS_COUNTRY VARCHAR2 (25)
SUPPLIER_ADDRESS_COUNTY VARCHAR2 (150)
SUPPLIER_ADDRESS_DESCRIPTN VARCHAR2 (15)
SUPPLIER_ADDRESS_FAX VARCHAR2 (26)
SUPPLIER_ADDRESS_POSTALCODE VARCHAR2 (20)
SUPPLIER_ADDRESS_STATEPROVN VARCHAR2 (150)
SUPPLIER_ADDRESS_TELEPHONE VARCHAR2 (26)
SUPPLIER_ADDRESS_UA_VATCODE VARCHAR2 (0)
SUPPLIER_ADDRESS_UA_PURSITE VARCHAR2 (1)
SUPPLIER_ADDRESS_UA_PAYSITE VARCHAR2 (1)
SUPPLIER_ADDRESS_UA_RFQSITE VARCHAR2 (1)
SUPPLIER_ADDRESS_UA_PCSITE VARCHAR2 (1)
AMOUNT_DISCNT_T_AMOUNT NUMBER

AMOUNT_DISCNT_T_CURRENCY_CODE VARCHAR2 (15) Y
AMOUNT_DISCNT_T_LOOKUP_CODE VARCHAR2 (2)
AMOUNT_DISCNT_F_AMOUNT NUMBER

AMOUNT_DISCNT_F_CURRENCY_CODE VARCHAR2 (15) Y
AMOUNT_DISCNT_F_LOOKUP_CODE VARCHAR2 (2)
TERM_DESCRIPTN VARCHAR2 (240)
TERMID VARCHAR2 (50)
AMOUNT_TAX_T_AMOUNT NUMBER

AMOUNT_TAX_T_CURRENCY_CODE VARCHAR2 (15) Y
AMOUNT_TAX_T_LOOKUP_CODE VARCHAR2 (2)
AMOUNT_TAX_F_AMOUNT NUMBER

AMOUNT_TAX_F_CURRENCY_CODE VARCHAR2 (15) Y
AMOUNT_TAX_F_LOOKUP_CODE VARCHAR2 (2)
AMOUNT_TAXBASE_F_AMOUNT NUMBER

AMOUNT_TAXBASE_F_CURRENCY_CODE VARCHAR2 (15) Y
AMOUNT_TAXBASE_F_LOOKUP_CODE VARCHAR2 (2)
AMOUNT_TAXBASE_T_AMOUNT NUMBER

AMOUNT_TAXBASE_T_CURRENCY_CODE VARCHAR2 (15) Y
AMOUNT_TAXBASE_T_LOOKUP_CODE VARCHAR2 (2)
TAX_TAXCODE VARCHAR2 (15)

[top of page]

APPS.ITG_LPI_HEADERS_V references the following:

APPS
SYNONYM - AP_INVOICES_ALL
SYNONYM - AP_TERMS
SYNONYM - FND_USER
SYNONYM - GL_CODE_COMBINATIONS
VIEW - GL_SETS_OF_BOOKS
PACKAGE - ITG_X_UTILS
VIEW - PO_VENDORS
VIEW - PO_VENDOR_SITES_ALL

APPS.ITG_LPI_HEADERS_V is not referenced by any database object

[top of page]

View: ITG_LPI_LINES_V

Comments
***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

Columns
Name Datatype Length Mandatory Comments
INVOICE_ID NUMBER (15) Y
DISTRIBUTION_LINE_NUMBER NUMBER (15) Y
AMOUNT_EXTENDED_T_AMOUNT NUMBER

AMOUNT_EXTENDED_T_CURR_CODE VARCHAR2 (15) Y
AMOUNT_EXTENDED_T_LOOKUP_CODE VARCHAR2 (2)
AMOUNT_EXTENDED_F_AMOUNT NUMBER

AMOUNT_EXTENDED_F_CURR_CODE VARCHAR2 (15) Y
AMOUNT_EXTENDED_F_LOOKUP_CODE VARCHAR2 (2)
OPERAMT_F_UNITPRICE NUMBER

OPERAMT_UNIT_F_CURRENCY_CODE VARCHAR2 (15) Y
OPERAMT_UNIT_F_QUANTITY NUMBER

OPERAMT_UNIT_F_UOMCODE VARCHAR2 (3) Y
OPERAMT_T_UNITPRICE NUMBER

OPERAMT_UNIT_T_CURRENCY_CODE VARCHAR2 (15) Y
OPERAMT_UNIT_T_QUANTITY NUMBER

OPERAMT_UNIT_T_UOMCODE VARCHAR2 (3) Y
QUANTITY_ITEM_QUANTITY NUMBER

QUANTITY_ITEM_UOMCODE VARCHAR2 (3) Y
GLNOMACCT VARCHAR2 (25)
INVLINENUM VARCHAR2 (40)
COSTCENTER VARCHAR2 (25)
DESCRIPTN VARCHAR2 (240)
ELEMENT1 VARCHAR2 (25)
ELEMENT2 VARCHAR2 (25)
ELEMENT3 VARCHAR2 (25)
ELEMENT4 VARCHAR2 (25)
ELEMENT5 VARCHAR2 (25)
ELEMENT6 VARCHAR2 (25)
ELEMENT7 VARCHAR2 (25)
ELEMENT8 VARCHAR2 (25)
ELEMENT9 VARCHAR2 (25)
ELEMENT10 VARCHAR2 (25)
ELEMENT11 VARCHAR2 (25)
ELEMENT12 VARCHAR2 (25)
ELEMENT13 VARCHAR2 (25)
ELEMENT14 VARCHAR2 (25)
ELEMENT15 VARCHAR2 (25)
ELEMENT16 VARCHAR2 (25)
ELEMENT17 VARCHAR2 (25)
ELEMENT18 VARCHAR2 (25)
ELEMENT19 VARCHAR2 (25)
ELEMENT20 VARCHAR2 (25)
ELEMENT21 VARCHAR2 (25)
ELEMENT22 VARCHAR2 (25)
ELEMENT23 VARCHAR2 (25)
ELEMENT24 VARCHAR2 (25)
ELEMENT25 VARCHAR2 (25)
ELEMENT26 VARCHAR2 (25)
ELEMENT27 VARCHAR2 (25)
ELEMENT28 VARCHAR2 (25)
ELEMENT29 VARCHAR2 (25)
ELEMENT30 VARCHAR2 (25)
GLENTITYD VARCHAR2 (25)
ITEM VARCHAR2 (4000)
ITEMTYPE VARCHAR2 (25)
POID VARCHAR2 (61)
TAXCODE VARCHAR2 (15)
QUANTITY_UA_RATE_RATE NUMBER

DATETIME_UA_EFFECTIVE DATE

UA_EXCHTYPE VARCHAR2 (30)
UA_ORG VARCHAR2 (40)

[top of page]

APPS.ITG_LPI_LINES_V references the following:

APPS
SYNONYM - AP_INVOICES_ALL
SYNONYM - AP_INVOICE_DISTRIBUTIONS_ALL
SYNONYM - GL_CODE_COMBINATIONS
VIEW - GL_SETS_OF_BOOKS
PACKAGE - ITG_X_UTILS
SYNONYM - MTL_SYSTEM_ITEMS
SYNONYM - MTL_UNITS_OF_MEASURE
SYNONYM - PO_DISTRIBUTIONS_ALL
SYNONYM - PO_HEADERS_ALL
SYNONYM - PO_LINES_ALL

APPS.ITG_LPI_LINES_V is not referenced by any database object

[top of page]

View: ITG_PO_DISTRBN_ARCH_V

Comments

Used for XML mapping in the distribution level

Columns
Name Datatype Length Mandatory Comments
REVISION_NUM NUMBER

PO Header ID
PO_RELEASE_ID NUMBER

PO_DISTRIBUTION_ID NUMBER
Y
PO_HEADER_ID NUMBER
Y
PO_LINE_ID NUMBER

PO_LINE_LOC_ID NUMBER

DISTRIBUTION_NUM NUMBER
Y
PROJECT_NUM VARCHAR2 (4000)
PROJECT_TYPE VARCHAR2 (20)
TASK_NUM VARCHAR2 (25)
QTY_ORDERED NUMBER

CONVERSION_RATE NUMBER

CONV_RATE_DATE DATE

DESTINATION_TYPE VARCHAR2 (25)
REQUESTOR VARCHAR2 (240)
EMAIL_ADDRESS VARCHAR2 (240)
WORK_TELEPHONE VARCHAR2 (60)
DFF_DIST_ATTR1 VARCHAR2 (30)
DFF_DIST_ATTR2 VARCHAR2 (150)
DFF_DIST_ATTR3 VARCHAR2 (150)
DFF_DIST_ATTR4 VARCHAR2 (150)
DFF_DIST_ATTR5 VARCHAR2 (150)
DFF_DIST_ATTR6 VARCHAR2 (150)
DFF_DIST_ATTR7 VARCHAR2 (150)
DFF_DIST_ATTR8 VARCHAR2 (150)
DFF_DIST_ATTR9 VARCHAR2 (150)
DFF_DIST_ATTR10 VARCHAR2 (150)
DFF_DIST_ATTR11 VARCHAR2 (150)
DFF_DIST_ATTR12 VARCHAR2 (150)
DFF_DIST_ATTR13 VARCHAR2 (150)
DFF_DIST_ATTR14 VARCHAR2 (150)
DFF_DIST_ATTR15 VARCHAR2 (150)
DFF_DIST_ATTR16 VARCHAR2 (150)

[top of page]

APPS.ITG_PO_DISTRBN_ARCH_V references the following:

APPS
PACKAGE - MRP_GET_PROJECT
SYNONYM - PA_PROJECTS_ALL
SYNONYM - PA_TASKS
SYNONYM - PER_ALL_PEOPLE_F
SYNONYM - PER_PHONES
SYNONYM - PO_DISTRIBUTIONS_ARCHIVE_ALL

APPS.ITG_PO_DISTRBN_ARCH_V is not referenced by any database object

[top of page]

View: ITG_PO_HEADER_ARCH_V

Comments

Used for XML mapping in the header level

Columns
Name Datatype Length Mandatory Comments
POID NUMBER

CONTRACTB VARCHAR2 (20)
REVISION_NUM NUMBER

This revision number of po or the release
RELEASE_ID NUMBER

RELEASE_NUM NUMBER

TYPE_LOOKUP_CODE VARCHAR2 (25)
STYLE_NAME VARCHAR2 (240)
PO_CURRENCY VARCHAR2 (15)
ACCEPTANCE_REQUIRED_FLAG VARCHAR2 (1)
ACCEPTANCE_DUE_DATE DATE

CREATION_DATE DATE

SUPPLIER_ORDER_NUM VARCHAR2 (25)
SUPP_ORG_NAME VARCHAR2 (240)
SUPP_OTF VARCHAR2 (1)
SUPP_PARTNER_TYPE CHAR (8)
SUPPLIER_PARTNER_ID VARCHAR2 (30)
SUPPLIER_PARTNER_ID_X VARCHAR2 (60)
ORDER_TOTAL NUMBER

SUPP_CURRENCY VARCHAR2 (15)
VAT_REGISTRATION_NUM VARCHAR2 (20)
SUPP_ADDR_LINE1 VARCHAR2 (240)
SUPP_ADDR_LINE2 VARCHAR2 (240)
SUPP_ADDR_LINE3 VARCHAR2 (240)
SUPP_CITY VARCHAR2 (25)
SUPP_COUNTRY VARCHAR2 (25)
SUPP_ZIP VARCHAR2 (20)
SUPP_STATE VARCHAR2 (150)
SUPP_PHONE VARCHAR2 (26)
BUYING_ORG_NAME VARCHAR2 (240)
BUYING_ORG_OTF CHAR (1)
BUYING_ORG_PARTNER_TYPE CHAR (6)
PARTNER_ID NUMBER

PARTNER_ID_X VARCHAR2 (35)
BUYING_ORG_CURRENCY VARCHAR2 (15)
BUYING_ORG_LOCATION_ID NUMBER (15)
BUYING_ORG_ADDR_LINE1 VARCHAR2 (240)
BUYING_ORG_ADDR_LINE2 VARCHAR2 (240)
BUYING_ORG_ADDR_LINE3 VARCHAR2 (240)
BUYING_ORG_CITY VARCHAR2 (30)
BUYING_ORG_COUNTRY VARCHAR2 (60)
BUYING_ORG_ZIP VARCHAR2 (30)
BUYING_ORG_STATE VARCHAR2 (120)
BUYING_ORG_PHONE1 VARCHAR2 (60)
BUYING_ORG_PHONE2 VARCHAR2 (60)
BUYING_ORG_PHONE3 VARCHAR2 (60)
BUYER_ID NUMBER (9)
BUYER_FULL_NAME VARCHAR2 (240)
BUYER_EMAIL VARCHAR2 (240)
BUYER_TELEPHONE VARCHAR2 (4000)
BILLTO_ORG_NAME VARCHAR2 (240)
BILLTO_ORG_OTF CHAR (1)
BILLTO_PARTNER_TYPE CHAR (6)
BILLTO_ORG_CURRENCY VARCHAR2 (15)
BILLTO_ORG_LOCATION_ID NUMBER (15)
BILLTO_ORG_ADDR_LINE1 VARCHAR2 (240)
BILLTO_ORG_ADDR_LINE2 VARCHAR2 (240)
BILLTO_ORG_ADDR_LINE3 VARCHAR2 (240)
BILLTO_ORG_CITY VARCHAR2 (30)
BILLTO_ORG_COUNTRY VARCHAR2 (60)
BILLTO_ORG_ZIP VARCHAR2 (30)
BILLTO_ORG_STATE VARCHAR2 (120)
BILLTO_ORG_PHONE1 VARCHAR2 (60)
BILLTO_ORG_PHONE2 VARCHAR2 (60)
BILLTO_ORG_PHONE3 VARCHAR2 (60)
CARRIER_ORG_NAME VARCHAR2 (25)
CARRIER_ORG_OTF VARCHAR2 (1)
CARRIER_PARTNER_TYPE CHAR (7)
PAYMENT_TERMS_ID NUMBER (15)
PAYMENT_TERMS_NAME VARCHAR2 (50)
PAYMENT_TERMS_DESCRIPTION VARCHAR2 (240)
FOB_CODE VARCHAR2 (30)
FOB_NAME VARCHAR2 (80)
FOB_DESC VARCHAR2 (240)
FREIGHT_CODE VARCHAR2 (30)
FREIGHT_NAME VARCHAR2 (80)
FREIGHT_DESC VARCHAR2 (240)
NOTE_TO_AUTHORIZER VARCHAR2 (240)
NOTE_TO_VENDOR VARCHAR2 (480)
NOTE_TO_RECEIVER VARCHAR2 (480)
COMMENTS VARCHAR2 (240)
START_DATE_ACTIVE DATE

END_DATE_ACTIVE DATE

CONFIRMING_ORDER_FLAG VARCHAR2 (1)
EXCHANGE_RATE NUMBER

EXCH_RATE_DATE DATE

DFF_HDR_ATTR1 VARCHAR2 (150)
DFF_HDR_ATTR2 VARCHAR2 (150)
DFF_HDR_ATTR3 VARCHAR2 (150)
DFF_HDR_ATTR4 VARCHAR2 (150)
DFF_HDR_ATTR5 VARCHAR2 (150)
DFF_HDR_ATTR6 VARCHAR2 (150)
DFF_HDR_ATTR7 VARCHAR2 (150)
DFF_HDR_ATTR8 VARCHAR2 (150)
DFF_HDR_ATTR9 VARCHAR2 (150)
DFF_HDR_ATTR10 VARCHAR2 (150)
DFF_HDR_ATTR11 VARCHAR2 (150)
DFF_HDR_ATTR12 VARCHAR2 (150)
DFF_HDR_ATTR13 VARCHAR2 (150)
DFF_HDR_ATTR14 VARCHAR2 (150)
DFF_HDR_ATTR15 VARCHAR2 (150)
DFF_HDR_ATTR16 VARCHAR2 (30)
CARD_NAME VARCHAR2 (80)
CARD_NUM VARCHAR2 (80)
CARD_EXP_DATE DATE

DFF_VEND_ATTR1 VARCHAR2 (150)
DFF_VEND_ATTR2 VARCHAR2 (150)
DFF_VEND_ATTR3 VARCHAR2 (150)
DFF_VEND_ATTR4 VARCHAR2 (150)
DFF_VEND_ATTR5 VARCHAR2 (150)
DFF_VEND_ATTR6 VARCHAR2 (150)
DFF_VEND_ATTR7 VARCHAR2 (150)
DFF_VEND_ATTR8 VARCHAR2 (150)
DFF_VEND_ATTR9 VARCHAR2 (150)
DFF_VEND_ATTR10 VARCHAR2 (150)
DFF_VEND_ATTR11 VARCHAR2 (150)
DFF_VEND_ATTR12 VARCHAR2 (150)
DFF_VEND_ATTR13 VARCHAR2 (150)
DFF_VEND_ATTR14 VARCHAR2 (150)
DFF_VEND_ATTR15 VARCHAR2 (150)
DFF_VEND_ATTR16 VARCHAR2 (30)
DFF_VEND_SITE_ATTR1 VARCHAR2 (150)
DFF_VEND_SITE_ATTR2 VARCHAR2 (150)
DFF_VEND_SITE_ATTR3 VARCHAR2 (150)
DFF_VEND_SITE_ATTR4 VARCHAR2 (150)
DFF_VEND_SITE_ATTR5 VARCHAR2 (150)
DFF_VEND_SITE_ATTR6 VARCHAR2 (150)
DFF_VEND_SITE_ATTR7 VARCHAR2 (150)
DFF_VEND_SITE_ATTR8 VARCHAR2 (150)
DFF_VEND_SITE_ATTR9 VARCHAR2 (150)
DFF_VEND_SITE_ATTR10 VARCHAR2 (150)
DFF_VEND_SITE_ATTR11 VARCHAR2 (150)
DFF_VEND_SITE_ATTR12 VARCHAR2 (150)
DFF_VEND_SITE_ATTR13 VARCHAR2 (150)
DFF_VEND_SITE_ATTR14 VARCHAR2 (150)
DFF_VEND_SITE_ATTR15 VARCHAR2 (150)
DFF_VEND_SITE_ATTR16 VARCHAR2 (30)
CUSTOMER_NUM VARCHAR2 (25)
SUPPLIER_FAX VARCHAR2 (25)
SUPPLIER_EMAIL VARCHAR2 (2000)
SUP_CONTACT_NAME VARCHAR2 (47)
SUP_CONTACT_PHONE VARCHAR2 (51)
LAST_UPDATE_DATE DATE

PCARD_ID NUMBER (15)
SUP_SITE_CODE VARCHAR2 (15)
NUM_1099 VARCHAR2 (20)
PO_REVISION_NUM NUMBER

Revision number of the po
LATEST_EXTERNAL_FLAG VARCHAR2 (1)
Flag to indicate the latest revision of the PO
SHIPPING_CONTROL VARCHAR2 (30)
Used to identify the party responsible for shipment of the order, buyer or supplier
POSTATUS VARCHAR2 (9)

[top of page]

APPS.ITG_PO_HEADER_ARCH_V references the following:

APPS
SYNONYM - AP_CARDS_ALL
SYNONYM - AP_TERMS
SYNONYM - FINANCIALS_SYSTEM_PARAMS_ALL
PACKAGE - FND_GLOBAL
VIEW - FND_LOOKUP_VALUES_VL
VIEW - GL_SETS_OF_BOOKS
SYNONYM - HR_ALL_ORGANIZATION_UNITS_TL
PACKAGE - HR_API
PACKAGE - HR_GENERAL
SYNONYM - HR_LOCATIONS_ALL
VIEW - HR_ORGANIZATION_UNITS_V
PACKAGE - HR_SECURITY
SYNONYM - PER_ALL_PEOPLE_F
PACKAGE - POGOT_S
SYNONYM - PO_DOC_STYLE_LINES_TL
SYNONYM - PO_HEADERS_ALL
SYNONYM - PO_HEADERS_ARCHIVE_ALL
SYNONYM - PO_RELEASES_ARCHIVE_ALL
VIEW - PO_VENDORS
VIEW - PO_VENDOR_CONTACTS
VIEW - PO_VENDOR_SITES_ALL

APPS.ITG_PO_HEADER_ARCH_V is not referenced by any database object

[top of page]

View: ITG_PO_LINE_ARCH_V

Comments

Used for XML mapping in the line level

Columns
Name Datatype Length Mandatory Comments
PO_HEADER_ID NUMBER

LINE_NUM NUMBER

PO_LINE_ID NUMBER

REVISION_NUM NUMBER

RELEASE_ID NUMBER

QUANTITY NUMBER

QUANT_UOM VARCHAR2 (3)
ITEMX VARCHAR2 (25)
ITEM VARCHAR2 (40)
DESCRIPTION VARCHAR2 (240)
HAZRDMTL VARCHAR2 (40)
ITEMRV VARCHAR2 (3)
NOTE_TO_VENDOR VARCHAR2 (480)
PRICE NUMBER

UNIT CHAR (4)
CATEGORYID VARCHAR2 (163)
CONTRACT VARCHAR2 (25)
TASKID NUMBER

PROJECTID NUMBER

CONTRACT_NUM VARCHAR2 (20)
VENDORQUOTENUM VARCHAR2 (25)
LISTPRICE NUMBER

MARKETPRICE NUMBER

PRICENOTTOEXCEED NUMBER

NEGPRICE VARCHAR2 (1)
TAXABLE VARCHAR2 (1)
TXNREASONCODE VARCHAR2 (25)
TYPE1099 VARCHAR2 (10)
LINEORDERTYPE VARCHAR2 (25)
HAZRDUNNUM VARCHAR2 (25)
HAZRDUNDESC VARCHAR2 (240)
DFF_LINE_ATTR1 VARCHAR2 (150)
DFF_LINE_ATTR2 VARCHAR2 (150)
DFF_LINE_ATTR3 VARCHAR2 (150)
DFF_LINE_ATTR4 VARCHAR2 (150)
DFF_LINE_ATTR5 VARCHAR2 (150)
DFF_LINE_ATTR6 VARCHAR2 (150)
DFF_LINE_ATTR7 VARCHAR2 (150)
DFF_LINE_ATTR8 VARCHAR2 (150)
DFF_LINE_ATTR9 VARCHAR2 (150)
DFF_LINE_ATTR10 VARCHAR2 (150)
DFF_LINE_ATTR11 VARCHAR2 (150)
DFF_LINE_ATTR12 VARCHAR2 (150)
DFF_LINE_ATTR13 VARCHAR2 (150)
DFF_LINE_ATTR14 VARCHAR2 (150)
DFF_LINE_ATTR15 VARCHAR2 (150)
DFF_LINE_ATTR16 VARCHAR2 (30)
DFF_ITEM_ATTR1 VARCHAR2 (150)
DFF_ITEM_ATTR2 VARCHAR2 (150)
DFF_ITEM_ATTR3 VARCHAR2 (150)
DFF_ITEM_ATTR4 VARCHAR2 (150)
DFF_ITEM_ATTR5 VARCHAR2 (150)
DFF_ITEM_ATTR6 VARCHAR2 (150)
DFF_ITEM_ATTR7 VARCHAR2 (150)
DFF_ITEM_ATTR8 VARCHAR2 (150)
DFF_ITEM_ATTR9 VARCHAR2 (150)
DFF_ITEM_ATTR10 VARCHAR2 (150)
DFF_ITEM_ATTR11 VARCHAR2 (150)
DFF_ITEM_ATTR12 VARCHAR2 (150)
DFF_ITEM_ATTR13 VARCHAR2 (150)
DFF_ITEM_ATTR14 VARCHAR2 (150)
DFF_ITEM_ATTR15 VARCHAR2 (150)
DFF_ITEM_ATTR16 VARCHAR2 (30)
KFF_ITEM_ATTR1 VARCHAR2 (40)
KFF_ITEM_ATTR2 VARCHAR2 (40)
KFF_ITEM_ATTR3 VARCHAR2 (40)
KFF_ITEM_ATTR4 VARCHAR2 (40)
KFF_ITEM_ATTR5 VARCHAR2 (40)
KFF_ITEM_ATTR6 VARCHAR2 (40)
KFF_ITEM_ATTR7 VARCHAR2 (40)
KFF_ITEM_ATTR8 VARCHAR2 (40)
KFF_ITEM_ATTR9 VARCHAR2 (40)
KFF_ITEM_ATTR10 VARCHAR2 (40)
KFF_ITEM_ATTR11 VARCHAR2 (40)
KFF_ITEM_ATTR12 VARCHAR2 (40)
KFF_ITEM_ATTR13 VARCHAR2 (40)
KFF_ITEM_ATTR14 VARCHAR2 (40)
KFF_ITEM_ATTR15 VARCHAR2 (40)
KFF_ITEM_ATTR16 VARCHAR2 (40)
KFF_ITEM_ATTR17 VARCHAR2 (40)
KFF_ITEM_ATTR18 VARCHAR2 (40)
KFF_ITEM_ATTR19 VARCHAR2 (40)
KFF_ITEM_ATTR20 VARCHAR2 (40)
ITEMRVX VARCHAR2 (3)
LATEST_EXTERNAL_FLAG VARCHAR2 (1)
Flag indicating the latest revision of the po line
CONTRACT_ID NUMBER

SUPPLIER_REF_NUMBER VARCHAR2 (150)
Configuration ID for the ordered item'
POLNSTATUS VARCHAR2 (9)
JOBTITLE VARCHAR2 (700)
CONTRACTORFIRSTNAME VARCHAR2 (240)
CONTRACTORLASTNAME VARCHAR2 (240)
STARTDATE DATE

ENDDATE DATE

AMOUNT_SERVICES NUMBER

[top of page]

APPS.ITG_PO_LINE_ARCH_V references the following:

APPS
SYNONYM - FINANCIALS_SYSTEM_PARAMS_ALL
SYNONYM - MTL_CATEGORIES_KFV
VIEW - MTL_SYSTEM_ITEMS_B_KFV
SYNONYM - MTL_UNITS_OF_MEASURE_TL
SYNONYM - PER_JOBS
VIEW - PO_DISTINCT_RELID_LINEID_V
SYNONYM - PO_HAZARD_CLASSES
SYNONYM - PO_HEADERS_ALL
SYNONYM - PO_LINES_ARCHIVE_ALL
SYNONYM - PO_LINE_TYPES
SYNONYM - PO_UN_NUMBERS_TL

APPS.ITG_PO_LINE_ARCH_V is not referenced by any database object

[top of page]

View: ITG_PO_LINE_LOC_ARCH_V

Comments

Used for XML mapping in the line locations level

Columns
Name Datatype Length Mandatory Comments
PO_HEADER_ID NUMBER
Y
REVISION_NUM NUMBER

PO_RELEASE_ID NUMBER

PO_LINE_ID NUMBER
Y
LINE_NUM NUMBER
Y
LINE_LOCATION_ID NUMBER
Y
SHIPMENT_NUM NUMBER

ORDERED_QUANTITY NUMBER

UOM VARCHAR2 (3) Y
NEED_BY_DATE DATE

SHIPTO_ORG_NAME VARCHAR2 (240)
SHIPTO_ORG_OTF CHAR (1)
SHIPTO_ORG_PARTNER_TYPE CHAR (6)
PARTNER_ID NUMBER

BUYING_ORG_CURRENCY VARCHAR2 (15)
PROMISED_DATE DATE

LAST_ACCEPT_DATE DATE

PRICE_OVERRIDE NUMBER

TAXABLE_FLAG VARCHAR2 (1)
TAX_CODE_ID NUMBER

SHIP_TO_LOC_ID NUMBER

CONSIGNED_FLAG VARCHAR2 (1)
Column to indicate consigned_flag
DROP_SHIP_FLAG VARCHAR2 (1)
The flag of drop shop location
PSCLNSTATUS VARCHAR2 (9)
AMOUNT_SERVICES NUMBER

[top of page]

APPS.ITG_PO_LINE_LOC_ARCH_V references the following:

APPS
SYNONYM - FINANCIALS_SYSTEM_PARAMS_ALL
PACKAGE - FND_GLOBAL
PACKAGE - HR_API
PACKAGE - HR_GENERAL
VIEW - HR_ORGANIZATION_UNITS_V
PACKAGE - HR_SECURITY
SYNONYM - MTL_UNITS_OF_MEASURE_TL
SYNONYM - PO_HEADERS_ALL
SYNONYM - PO_LINES_ALL
SYNONYM - PO_LINE_LOCATIONS_ARCHIVE_ALL

APPS.ITG_PO_LINE_LOC_ARCH_V is not referenced by any database object

[top of page]

View: ITG_REQ_DISTRIBUTIONS_V

Comments
View Type

A public view which may be useful for custom reporting or other data requirements.

This view is used for generating XML at requisition distribution level

Columns
Name Datatype Length Mandatory Comments
REQUISITION_HEADER_ID NUMBER
Y
REQ_LINE_ID NUMBER
Y
DISTRIBUTION_NUM NUMBER
Y
QUANTITY_ITEM NUMBER

PROPERTY1 VARCHAR2 (25)
PROPERTY2 VARCHAR2 (25)
PROPERTY3 VARCHAR2 (25)
PROPERTY4 VARCHAR2 (25)
PROPERTY5 VARCHAR2 (25)
PROPERTY6 VARCHAR2 (25)
PROPERTY7 VARCHAR2 (25)
PROPERTY8 VARCHAR2 (25)
PROPERTY9 VARCHAR2 (25)
PROPERTY10 VARCHAR2 (25)
PROPERTY11 VARCHAR2 (25)
PROPERTY12 VARCHAR2 (25)
PROPERTY13 VARCHAR2 (25)
PROPERTY14 VARCHAR2 (25)
PROPERTY15 VARCHAR2 (25)
PROPERTY16 VARCHAR2 (25)
PROPERTY17 VARCHAR2 (25)
PROPERTY18 VARCHAR2 (25)
PROPERTY19 VARCHAR2 (25)
PROPERTY20 VARCHAR2 (25)
PROPERTY21 VARCHAR2 (25)
PROPERTY22 VARCHAR2 (25)
PROPERTY23 VARCHAR2 (25)
PROPERTY24 VARCHAR2 (25)
PROPERTY25 VARCHAR2 (25)
PROPERTY26 VARCHAR2 (25)
PROPERTY27 VARCHAR2 (25)
PROPERTY28 VARCHAR2 (25)
PROPERTY29 VARCHAR2 (25)
PROPERTY30 VARCHAR2 (25)
DISTRIBUTION_ITEM VARCHAR2 (4000)
DESCRIPTN VARCHAR2 (240) Y
DISTLINE_UA_ATTRIBUTE1 VARCHAR2 (150)
DISTLINE_UA_ATTRIBUTE2 VARCHAR2 (150)
DISTLINE_UA_ATTRIBUTE3 VARCHAR2 (150)
DISTLINE_UA_ATTRIBUTE4 VARCHAR2 (150)
DISTLINE_UA_ATTRIBUTE5 VARCHAR2 (150)
DISTLINE_UA_ATTRIBUTE6 VARCHAR2 (150)
DISTLINE_UA_ATTRIBUTE7 VARCHAR2 (150)
DISTLINE_UA_ATTRIBUTE8 VARCHAR2 (150)
DISTLINE_UA_ATTRIBUTE9 VARCHAR2 (150)
DISTLINE_UA_ATTRIBUTE10 VARCHAR2 (150)
DISTLINE_UA_ATTRIBUTE11 VARCHAR2 (150)
DISTLINE_UA_ATTRIBUTE12 VARCHAR2 (150)
DISTLINE_UA_ATTRIBUTE13 VARCHAR2 (150)
DISTLINE_UA_ATTRIBUTE14 VARCHAR2 (150)
DISTLINE_UA_ATTRIBUTE15 VARCHAR2 (150)

[top of page]

APPS.ITG_REQ_DISTRIBUTIONS_V references the following:

APPS
SYNONYM - GL_CODE_COMBINATIONS
PACKAGE - ITG_X_UTILS
SYNONYM - MTL_SYSTEM_ITEMS
SYNONYM - PO_REQUISITION_LINES_ALL
SYNONYM - PO_REQ_DISTRIBUTIONS_ALL

APPS.ITG_REQ_DISTRIBUTIONS_V is not referenced by any database object

[top of page]

View: ITG_REQ_HEADERS_V

Comments
View Type

A public view which may be useful for custom reporting or other data requirements.

This is used to generate XML at requisition headers level

Columns
Name Datatype Length Mandatory Comments
REQ_HEADER_ID NUMBER
Y
CREATION_DATE DATE

SUM_REQLINES NUMBER

CURRENY_CODE VARCHAR2 (15)
REQUISITNID VARCHAR2 (20) Y
APPROVED NUMBER

DESCRIPTN VARCHAR2 (240)
HDRSTATUS VARCHAR2 (1)
POENTITY NUMBER

REQUESTER VARCHAR2 (30)
HEADER_UA_ATTRIBUTE1 VARCHAR2 (150)
HEADER_UA_ATTRIBUTE2 VARCHAR2 (150)
HEADER_UA_ATTRIBUTE3 VARCHAR2 (150)
HEADER_UA_ATTRIBUTE4 VARCHAR2 (150)
HEADER_UA_ATTRIBUTE5 VARCHAR2 (150)
HEADER_UA_ATTRIBUTE6 VARCHAR2 (150)
HEADER_UA_ATTRIBUTE7 VARCHAR2 (150)
HEADER_UA_ATTRIBUTE8 VARCHAR2 (150)
HEADER_UA_ATTRIBUTE9 VARCHAR2 (150)
HEADER_UA_ATTRIBUTE10 VARCHAR2 (150)
HEADER_UA_ATTRIBUTE11 VARCHAR2 (150)
HEADER_UA_ATTRIBUTE12 VARCHAR2 (150)
HEADER_UA_ATTRIBUTE13 VARCHAR2 (150)
HEADER_UA_ATTRIBUTE14 VARCHAR2 (150)
HEADER_UA_ATTRIBUTE15 VARCHAR2 (150)
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)

[top of page]

APPS.ITG_REQ_HEADERS_V references the following:

APPS
VIEW - GL_SETS_OF_BOOKS
PACKAGE - HR_GENERAL
PACKAGE - HR_PERSON_NAME
PACKAGE - HR_SECURITY
PACKAGE - ITG_X_UTILS
VIEW - ORG_ORGANIZATION_DEFINITIONS
VIEW - PER_PEOPLE_F
SYNONYM - PO_REQUISITION_HEADERS_ALL

APPS.ITG_REQ_HEADERS_V is not referenced by any database object

[top of page]

View: ITG_REQ_LINES_V

Comments
View Type

A public view which may be useful for custom reporting or other data requirements.

This view is used to generate the XML at the requisition lines level

Columns
Name Datatype Length Mandatory Comments
REQ_HEADER_ID NUMBER
Y
REQ_LINE_ID NUMBER
Y
DATETIME_NEED_BY_DATE DATE

QUANTITY_ORDERED NUMBER

UOM_CODE VARCHAR2 (3) Y
OPERAMT_UNIT_PRICE NUMBER

OPERAMT_CURRENCY_CODE VARCHAR2 (15)
OPERAMT_QUANTITY NUMBER

REQLINENUM VARCHAR2 (40)
BUYERID VARCHAR2 (240)
COMMODITY VARCHAR2 (4000)
DELIVERTO VARCHAR2 (30)
HAZARDMATL VARCHAR2 (40)
ITEMRV VARCHAR2 (3)
ITEMX VARCHAR2 (25)
NOTES VARCHAR2 (480)
POENTITY NUMBER

PROPERTY_1 VARCHAR2 (25)
PROPERTY_2 VARCHAR2 (40)
SITELEVEL_1 VARCHAR2 (240)
SITELEVEL_2 VARCHAR2 (10)
DESCRIPTN VARCHAR2 (240) Y
ITEM VARCHAR2 (4000)
LINE_UA_EXPENSE VARCHAR2 (1)
LINE_UA_ATTRIBUTE VARCHAR2 (150)
LINE_UA_ATTRIBUTE1 VARCHAR2 (150)
LINE_UA_ATTRIBUTE2 VARCHAR2 (150)
LINE_UA_ATTRIBUTE3 VARCHAR2 (150)
LINE_UA_ATTRIBUTE4 VARCHAR2 (150)
LINE_UA_ATTRIBUTE5 VARCHAR2 (150)
LINE_UA_ATTRIBUTE6 VARCHAR2 (150)
LINE_UA_ATTRIBUTE7 VARCHAR2 (150)
LINE_UA_ATTRIBUTE8 VARCHAR2 (150)
LINE_UA_ATTRIBUTE9 VARCHAR2 (150)
LINE_UA_ATTRIBUTE10 VARCHAR2 (150)
LINE_UA_ATTRIBUTE11 VARCHAR2 (150)
LINE_UA_ATTRIBUTE12 VARCHAR2 (150)
LINE_UA_ATTRIBUTE13 VARCHAR2 (150)
LINE_UA_ATTRIBUTE14 VARCHAR2 (150)
LINE_UA_ATTRIBUTE15 VARCHAR2 (150)
EMPLOYEE_NAME VARCHAR2 (60) Y
EMPLOYEE_PARTNID VARCHAR2 (30)
EMPLOYEE_PARTNRTYPE CHAR (8)
EMPLOYEE_PARTNRIDX VARCHAR2 (40)
EMP_UA_BILL_TO_SITE_FLAG VARCHAR2 (30)
EMP_UA_SHIP_TO_SITE_FLAG VARCHAR2 (30)
EMP_UA_RECV_SITE_FLAG VARCHAR2 (30)
EMPLOYEE_ADDR_LINE1 VARCHAR2 (240)
EMPLOYEE_ADDR_LINE2 VARCHAR2 (240)
EMPLOYEE_ADDR_LINE3 VARCHAR2 (240)
EMPLOYEE_ADDR_ADDRTYPE CHAR (8)
EMPLOYEE_ADDR_CITY VARCHAR2 (30)
EMPLOYEE_ADDR_COUNTRY VARCHAR2 (60)
EMPLOYEE_ADDR_COUNTY VARCHAR2 (4000)
EMPLOYEE_ADDR_DESCRIPTN VARCHAR2 (240)
EMPLOYEE_ADDR_POSTALCODE VARCHAR2 (30)
EMPLOYEE_ADDR_STATEPROVN VARCHAR2 (4000)
EMPLOYEE_ADDR_TELEPHONE1 VARCHAR2 (60)
EMPLOYEE_ADDR_TELEPHONE2 VARCHAR2 (60)
EMPLOYEE_ADDR_TELEPHONE3 VARCHAR2 (60)
EMPLOYEE_CONTACT_NAME VARCHAR2 (30)
EMPLOYEE_CONTACT_EMAIL VARCHAR2 (240)
EMPLOYEE_CONTACT_TELEPHONE1 VARCHAR2 (4000)
SHIPTO_NAME VARCHAR2 (240)
SHIPTO_PARTNRID VARCHAR2 (3)
SHIPTO_PARTNRTYPE CHAR (6)
SHIPTO_PARTNRIDX VARCHAR2 (40)
SHIPTO_TAXEXEMPT VARCHAR2 (1)
SHIPTO_TAXID VARCHAR2 (4000)
SHIPTO_UA_BILLFLG VARCHAR2 (30)
SHIPTO_UA_SHIPFLG VARCHAR2 (30)
SHIPTO_UA_RECFLG VARCHAR2 (30)
SHIPTO_ADDR_LINE1 VARCHAR2 (240)
SHIPTO_ADDR_LINE2 VARCHAR2 (240)
SHIPTO_ADDR_LINE3 VARCHAR2 (240)
SHIPTO_ADDR_ADDRTYPE CHAR (9)
SHIPTO_ADDR_CITY VARCHAR2 (30)
SHIPTO_ADDR_COUNTRY VARCHAR2 (60)
SHIPTO_ADDR_COUNTY VARCHAR2 (4000)
SHIPTO_ADDR_DESCRIPTN VARCHAR2 (240)
SHIPTO_ADDR_POSTALCODE VARCHAR2 (30)
SHIPTO_ADDR_STATEPROVN VARCHAR2 (4000)
SHIPTO_ADDR_TELEPHONE1 VARCHAR2 (60)
SHIPTO_ADDR_TELEPHONE2 VARCHAR2 (60)
SHIPTO_ADDR_TELEPHONE3 VARCHAR2 (60)
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)

[top of page]

APPS.ITG_REQ_LINES_V references the following:

APPS
VIEW - GL_SETS_OF_BOOKS
SYNONYM - HR_ALL_ORGANIZATION_UNITS
PACKAGE - HR_GENERAL
VIEW - HR_LOCATIONS
SYNONYM - HR_LOCATIONS_ALL
PACKAGE - HR_PERSON_NAME
PACKAGE - HR_SECURITY
PACKAGE - ITG_X_UTILS
SYNONYM - MTL_CATEGORIES
SYNONYM - MTL_SYSTEM_ITEMS
SYNONYM - MTL_UNITS_OF_MEASURE
VIEW - ORG_ORGANIZATION_DEFINITIONS
VIEW - PER_PEOPLE_F
SYNONYM - PO_HAZARD_CLASSES_TL
SYNONYM - PO_REQUISITION_HEADERS_ALL
SYNONYM - PO_REQUISITION_LINES_ALL
SYNONYM - PO_UN_NUMBERS_TL

APPS.ITG_REQ_LINES_V is not referenced by any database object

[top of page]

View: ITG_REQ_VENDORS_V

Comments
View Type

A public view which may be useful for custom reporting or other data requirements.

This view is used to generate XML segment containing requistion supplier information

Columns
Name Datatype Length Mandatory Comments
REQUISITION_LINE_ID NUMBER
Y
NU_VENDOR_NAME VARCHAR2 (240)
SUPPLIER_ONE_TIME VARCHAR2 (1)
SUPPLIER_PARTNRID VARCHAR2 (30) Y
SUPPLIER_CURRENCY VARCHAR2 (15)
SUPPLIER_DESCRIPTN VARCHAR2 (320)
SUPPLIER_PARTNRIDX VARCHAR2 (40)
SUPPLIER_TAXID VARCHAR2 (20)
SUPPLIER_UA_BANKNAM VARCHAR2 (0)
SUPPLIER_UA_BANKACT VARCHAR2 (0)

[top of page]

APPS.ITG_REQ_VENDORS_V references the following:

APPS
SYNONYM - PO_REQUISITION_LINES_ALL
VIEW - PO_VENDORS

APPS.ITG_REQ_VENDORS_V is not referenced by any database object

[top of page]

View: ITG_REQ_VENDOR_CONTACTS_V

Comments
View Type

A public view which may be useful for custom reporting or other data requirements.

This view is used to generate XML segment containing requistion supplier contact information

Columns
Name Datatype Length Mandatory Comments
REQUISITION_LINE_ID NUMBER
Y
VENDOR_SITE_ID NUMBER

SUPPLIER_ADDR_TELEPHONE1 VARCHAR2 (11)
SUPPLIER_CONTACT_NAME1 VARCHAR2 (47)
SUPPLIER_CONTACT_DESCRIPTN VARCHAR2 (31)
SUPPLIER_CONTACT_TELEPHONE1 VARCHAR2 (11)

[top of page]

APPS.ITG_REQ_VENDOR_CONTACTS_V references the following:

APPS
SYNONYM - PO_REQUISITION_LINES_ALL
VIEW - PO_VENDOR_CONTACTS

APPS.ITG_REQ_VENDOR_CONTACTS_V is not referenced by any database object

[top of page]

View: ITG_REQ_VENDOR_SITES_V

Comments
View Type

A public view which may be useful for custom reporting or other data requirements.

This view is used to generate XML segment containing requistion supplier location information

Columns
Name Datatype Length Mandatory Comments
REQUISITION_LINE_ID NUMBER
Y
VENDOR_ID NUMBER

VENDOR_SITE_ID NUMBER

SUPPLIER_ADDR_LINE1 VARCHAR2 (240)
SUPPLIER_ADDR_LINE2 VARCHAR2 (240)
SUPPLIER_ADDR_LINE3 VARCHAR2 (240)
SUPPLIER_ADDR_CITY VARCHAR2 (25)
SUPPLIER_ADDR_COUNTRY VARCHAR2 (25)
SUPPLIER_ADDR_COUNTY VARCHAR2 (150)
SUPPLIER_ADDR_DESCRIPTN VARCHAR2 (15)
SUPPLIER_ADDR_FAX VARCHAR2 (11)
SUPPLIER_ADDR_POSTALCODE VARCHAR2 (20)
SUPPLIER_ADDR_STATEPROVN VARCHAR2 (150)
SUPPLIER_ADDR_UA_VATCODE VARCHAR2 (0)
SUPPLIER_ADDR_UA_PURSITE VARCHAR2 (1)
SUPPLIER_ADDR_UA_PAYSITE VARCHAR2 (1)
SUPPLIER_ADDR_UA_RFQSITE VARCHAR2 (1)
SUPPLIER_ADDR_UA_PCSITE VARCHAR2 (1)

[top of page]

APPS.ITG_REQ_VENDOR_SITES_V references the following:

APPS
SYNONYM - PO_REQUISITION_LINES_ALL
VIEW - PO_VENDOR_SITES_ALL

APPS.ITG_REQ_VENDOR_SITES_V is not referenced by any database object

[top of page]

View: ITG_SP_PO_HEADERS_V

Comments

This view is used to generate XML at po headers level for use in Sync PO message

Columns
Name Datatype Length Mandatory Comments
PO_HEADER_ID NUMBER
Y
DATETIME_DOCUMENT DATE

OPERAMT_EXTENDED NUMBER

OPERAMT_CURRENCY VARCHAR2 (15)
POID VARCHAR2 (20) Y
BUYERID VARCHAR2 (240)
DELIVERTO VARCHAR2 (60)
NOTES VARCHAR2 (240)
POENTITY VARCHAR2 (40)
PORELEASE VARCHAR2 (0)
POSTATUS VARCHAR2 (25)
POTYPE VARCHAR2 (25) Y
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)

[top of page]

APPS.ITG_SP_PO_HEADERS_V references the following:

APPS
PACKAGE - HR_GENERAL
SYNONYM - HR_LOCATIONS_ALL
PACKAGE - HR_PERSON_NAME
PACKAGE - HR_SECURITY
PACKAGE - ITG_X_UTILS
VIEW - PER_PEOPLE_F
SYNONYM - PO_HEADERS_ALL

APPS.ITG_SP_PO_HEADERS_V is not referenced by any database object

[top of page]

View: ITG_SP_PO_LINE_DIST_V

Comments

This view is used to generate XML at PO line distribution level for Sync PO message

Columns
Name Datatype Length Mandatory Comments
PO_DISTRIBUTION_ID NUMBER
Y
PO_HEADER_ID NUMBER
Y
PO_LINE_ID NUMBER

LINE_LOCATION_ID NUMBER

OPERAMT_EXTENDED NUMBER

OPERAMT_CURRENCY VARCHAR2 (15)
OPERAMT_UOMVALUE NUMBER

OPERAMT_UOM VARCHAR2 (3)
COSTCENTER VARCHAR2 (25)
ELEMENT1 VARCHAR2 (25)
ELEMENT2 VARCHAR2 (25)
ELEMENT3 VARCHAR2 (25)
ELEMENT4 VARCHAR2 (25)
ELEMENT5 VARCHAR2 (25)
ELEMENT6 VARCHAR2 (25)
ELEMENT7 VARCHAR2 (25)
ELEMENT8 VARCHAR2 (25)
ELEMENT9 VARCHAR2 (25)
ELEMENT10 VARCHAR2 (25)
ELEMENT11 VARCHAR2 (25)
ELEMENT12 VARCHAR2 (25)
ELEMENT13 VARCHAR2 (25)
ELEMENT14 VARCHAR2 (25)
ELEMENT15 VARCHAR2 (25)
ELEMENT16 VARCHAR2 (25)
ELEMENT17 VARCHAR2 (25)
ELEMENT18 VARCHAR2 (25)
ELEMENT19 VARCHAR2 (25)
ELEMENT20 VARCHAR2 (25)
ELEMENT21 VARCHAR2 (25)
ELEMENT22 VARCHAR2 (25)
ELEMENT23 VARCHAR2 (25)
ELEMENT24 VARCHAR2 (25)
ELEMENT25 VARCHAR2 (25)
ELEMENT26 VARCHAR2 (25)
ELEMENT27 VARCHAR2 (25)
ELEMENT28 VARCHAR2 (25)
ELEMENT29 VARCHAR2 (25)
ELEMENT30 VARCHAR2 (25)
GLENTITYS VARCHAR2 (40)
GLNOMACCT VARCHAR2 (25)
PROJECT VARCHAR2 (40)
UNIT VARCHAR2 (240)
UA_DISTRID VARCHAR2 (40)
UA_SCHEDLID VARCHAR2 (40)
UA_LINENUM VARCHAR2 (40)
UA_DELIVERTO VARCHAR2 (30)
UA_DIST_ATTR1 VARCHAR2 (150)
UA_DIST_ATTR2 VARCHAR2 (150)
UA_DIST_ATTR3 VARCHAR2 (150)
UA_DIST_ATTR4 VARCHAR2 (150)
UA_DIST_ATTR5 VARCHAR2 (150)
UA_DIST_ATTR6 VARCHAR2 (150)
UA_DIST_ATTR7 VARCHAR2 (150)
UA_DIST_ATTR8 VARCHAR2 (150)
UA_DIST_ATTR9 VARCHAR2 (150)
UA_DIST_ATTR10 VARCHAR2 (150)
UA_DIST_ATTR11 VARCHAR2 (150)
UA_DIST_ATTR12 VARCHAR2 (150)
UA_DIST_ATTR13 VARCHAR2 (150)
UA_DIST_ATTR14 VARCHAR2 (150)
UA_DIST_ATTR15 VARCHAR2 (150)
UA_REQUISITNID VARCHAR2 (4000)
UA_REQLINENUM VARCHAR2 (4000)

[top of page]

APPS.ITG_SP_PO_LINE_DIST_V references the following:

APPS
SYNONYM - GL_CODE_COMBINATIONS
PACKAGE - HR_GENERAL
PACKAGE - HR_PERSON_NAME
PACKAGE - HR_SECURITY
PACKAGE - ITG_X_UTILS
SYNONYM - MTL_UNITS_OF_MEASURE
VIEW - ORG_ORGANIZATION_DEFINITIONS
VIEW - PER_PEOPLE_F
SYNONYM - PO_DISTRIBUTIONS_ALL
SYNONYM - PO_HEADERS_ALL
SYNONYM - PO_LINE_LOCATIONS_ALL

APPS.ITG_SP_PO_LINE_DIST_V is not referenced by any database object

[top of page]

View: ITG_SP_PO_LINE_PART_EMPL_V

Comments

This view is used to generate the partner employee XML segment in the PO line for Sync PO

Columns
Name Datatype Length Mandatory Comments
PO_DISTRIBUTION_ID NUMBER
Y
PO_HEADER_ID NUMBER
Y
PO_LINE_ID NUMBER

LINE_LOCATION_ID NUMBER

DELIVER_TO_LOCATION_ID NUMBER

DELIVER_TO_PERSON_ID NUMBER (9)
NAME VARCHAR2 (60)
PARTNRID VARCHAR2 (30)
PARTNRTYPE CHAR (8)
DESCRIPTN_PARTNER VARCHAR2 (240)
PARTNRIDX VARCHAR2 (40)
TAXEXEMPT NUMBER

UA_REF_SCHEDLID VARCHAR2 (40)
UA_REF_DISTRID VARCHAR2 (40)
UA_REQUISITNID VARCHAR2 (4000)
ADDRESS_LINE_1 VARCHAR2 (240)
ADDRESS_LINE_2 VARCHAR2 (240)
ADDRESS_LINE_3 VARCHAR2 (240)
CITY VARCHAR2 (30)
COUNTRY VARCHAR2 (60)
COUNTY VARCHAR2 (4000)
DESCRIPTN_ADDRS VARCHAR2 (240)
POSTAL_CODE VARCHAR2 (30)
STATEPROVN VARCHAR2 (4000)
TELEPHONE VARCHAR2 (60)
CONTACT_NAME VARCHAR2 (240)
CONTACT_EMAIL VARCHAR2 (240)
CONTACT_PHONE VARCHAR2 (4000)

[top of page]

APPS.ITG_SP_PO_LINE_PART_EMPL_V references the following:

APPS
PACKAGE - HR_GENERAL
SYNONYM - HR_LOCATIONS_ALL
SYNONYM - HR_LOCATIONS_ALL_TL
PACKAGE - HR_PERSON_NAME
PACKAGE - HR_SECURITY
PACKAGE - ITG_X_UTILS
VIEW - PER_PEOPLE_F
SYNONYM - PO_DISTRIBUTIONS_ALL

APPS.ITG_SP_PO_LINE_PART_EMPL_V is not referenced by any database object

[top of page]

View: ITG_SP_PO_LINE_PART_SHIPTO_V

Comments

This view is used to generate the partner shipto segment in the Sync PO XML

Columns
Name Datatype Length Mandatory Comments
PO_HEADER_ID NUMBER
Y
PO_LINE_ID NUMBER
Y
LINE_LOCATION_ID NUMBER
Y
SHIP_TO_LOCATION_ID NUMBER

SHIP_TO_ORGANIZATION_ID NUMBER

NAME VARCHAR2 (240)
PARTNRID VARCHAR2 (3)
PARTNRTYPE CHAR (6)
DESCRIPTN_PARTNER VARCHAR2 (60)
PARTNRIDX VARCHAR2 (40)
TAXEXEMPT NUMBER

TAXID VARCHAR2 (4000)
UA_REF_SCHEDLID VARCHAR2 (40)
ADDRESS_LINE_1 VARCHAR2 (240)
ADDRESS_LINE_2 VARCHAR2 (240)
ADDRESS_LINE_3 VARCHAR2 (240)
CITY VARCHAR2 (30)
COUNTRY VARCHAR2 (60)
COUNTY VARCHAR2 (4000)
DESCRIPTN_ADDRS VARCHAR2 (240)
POSTAL_CODE VARCHAR2 (30)
STATEPROVN VARCHAR2 (4000)
TELEPHONE VARCHAR2 (60)
DROP_SHIP_FLAG VARCHAR2 (1)

[top of page]

APPS.ITG_SP_PO_LINE_PART_SHIPTO_V references the following:

APPS
PACKAGE - HR_GENERAL
SYNONYM - HR_LOCATIONS_ALL
SYNONYM - HR_LOCATIONS_ALL_TL
PACKAGE - HR_SECURITY
PACKAGE - ITG_X_UTILS
VIEW - ORG_ORGANIZATION_DEFINITIONS
SYNONYM - PO_LINE_LOCATIONS_ALL

APPS.ITG_SP_PO_LINE_PART_SHIPTO_V is not referenced by any database object

[top of page]

View: ITG_SP_PO_LINE_SCHED_V

Comments

This view is used to generate XML for Sync PO at line schedule level

Columns
Name Datatype Length Mandatory Comments
PO_HEADER_ID NUMBER
Y
PO_LINE_ID NUMBER
Y
LINE_LOCATION_ID NUMBER
Y
DATETIME_NEEDDELV DATE

ORDERED_QUANTITY NUMBER

ORDERED_UOM VARCHAR2 (3) Y
SHIPMENT_NUM NUMBER

UA_SCHEDLID VARCHAR2 (40)
UA_SCHED_ATTR1 VARCHAR2 (150)
UA_SCHED_ATTR2 VARCHAR2 (150)
UA_SCHED_ATTR3 VARCHAR2 (150)
UA_SCHED_ATTR4 VARCHAR2 (150)
UA_SCHED_ATTR5 VARCHAR2 (150)
UA_SCHED_ATTR6 VARCHAR2 (150)
UA_SCHED_ATTR7 VARCHAR2 (150)
UA_SCHED_ATTR8 VARCHAR2 (150)
UA_SCHED_ATTR9 VARCHAR2 (150)
UA_SCHED_ATTR10 VARCHAR2 (150)
UA_SCHED_ATTR11 VARCHAR2 (150)
UA_SCHED_ATTR12 VARCHAR2 (150)
UA_SCHED_ATTR13 VARCHAR2 (150)
UA_SCHED_ATTR14 VARCHAR2 (150)
UA_SCHED_ATTR15 VARCHAR2 (150)
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)
DROP_SHIP_FLAG VARCHAR2 (1)

[top of page]

APPS.ITG_SP_PO_LINE_SCHED_V references the following:

APPS
SYNONYM - MTL_UNITS_OF_MEASURE
SYNONYM - PO_LINES_ALL
SYNONYM - PO_LINE_LOCATIONS_ALL

APPS.ITG_SP_PO_LINE_SCHED_V is not referenced by any database object

[top of page]

View: ITG_SP_PO_PART_SHIPTO_V

Comments

This view is used to generate partner ship-to segment in Sync PO XML

Columns
Name Datatype Length Mandatory Comments
PO_HEADER_ID NUMBER
Y
VENDOR_ID NUMBER

AGENT_ID NUMBER (9) Y
SHIP_TO_LOCATION_ID NUMBER

NAME VARCHAR2 (60)
PARTNRID VARCHAR2 (30)
PARTNRTYPE CHAR (6)
DESCRIPTION VARCHAR2 (240)
PARTNRIDX NUMBER

TAXEXEMPT VARCHAR2 (1)
TAXID VARCHAR2 (20)
UA_SOLD_BILLFLAG VARCHAR2 (30)
UA_SOLD_SHIPFLAG VARCHAR2 (30)
UA_SOLD_RECFLAG VARCHAR2 (30)
ADDRESS_LINE_1 VARCHAR2 (240)
ADDRESS_LINE_2 VARCHAR2 (240)
ADDRESS_LINE_3 VARCHAR2 (240)
ADDRTYPE VARCHAR2 (0)
CITY VARCHAR2 (30)
COUNTRY VARCHAR2 (60)
COUNTY VARCHAR2 (4000)
SITE_DESCRIPTN VARCHAR2 (240)
POSTAL_CODE VARCHAR2 (30)
STATEPROVN VARCHAR2 (4000)
TELEPHONE VARCHAR2 (60)
CONTACT_NAME VARCHAR2 (240)
CONTACT_EMAIL VARCHAR2 (240)
CONTACT_PHONE VARCHAR2 (4000)

[top of page]

APPS.ITG_SP_PO_PART_SHIPTO_V references the following:

APPS
PACKAGE - HR_GENERAL
SYNONYM - HR_LOCATIONS_ALL
SYNONYM - HR_LOCATIONS_ALL_TL
PACKAGE - HR_PERSON_NAME
PACKAGE - HR_SECURITY
PACKAGE - ITG_X_UTILS
VIEW - PER_PEOPLE_F
SYNONYM - PO_HEADERS_ALL
VIEW - PO_VENDORS

APPS.ITG_SP_PO_PART_SHIPTO_V is not referenced by any database object

[top of page]

View: ITG_SP_PO_PART_SOLDTO_V

Comments

This view is used to generate partner sold to segment in Sync PO XML

Columns
Name Datatype Length Mandatory Comments
PO_HEADER_ID NUMBER
Y
BILL_TO_LOCATION_ID NUMBER

AGENT_ID NUMBER (9) Y
INVORGID NUMBER (15)
SET_OF_BOOKS_ID NUMBER (15) Y
ORGANIZATION_NAME VARCHAR2 (240) Y
PARTNRID VARCHAR2 (3)
PARTNRTYPE CHAR (6)
CURRENCY VARCHAR2 (15) Y
PARTNRIDX NUMBER (15)
UA_SOLD_BILLFLAG VARCHAR2 (30)
UA_SOLD_SHIPFLAG VARCHAR2 (30)
UA_SOLD_RECFLAG VARCHAR2 (30)
ADDRESS_LINE_1 VARCHAR2 (240)
ADDRESS_LINE_2 VARCHAR2 (240)
ADDRESS_LINE_3 VARCHAR2 (240)
ADDRTYPE VARCHAR2 (0)
CITY VARCHAR2 (30)
COUNTRY VARCHAR2 (60)
COUNTY VARCHAR2 (4000)
SITE_DESCRIPTN VARCHAR2 (240)
POSTAL_CODE VARCHAR2 (30)
STATEPROVN VARCHAR2 (4000)
TELEPHONE VARCHAR2 (60)
CONTACT_NAME VARCHAR2 (240)
CONTACT_EMAIL VARCHAR2 (240)
CONTACT_PHONE VARCHAR2 (4000)

[top of page]

APPS.ITG_SP_PO_PART_SOLDTO_V references the following:

APPS
VIEW - GL_SETS_OF_BOOKS
PACKAGE - HR_GENERAL
SYNONYM - HR_LOCATIONS_ALL
SYNONYM - HR_LOCATIONS_ALL_TL
PACKAGE - HR_PERSON_NAME
PACKAGE - HR_SECURITY
PACKAGE - ITG_X_UTILS
VIEW - ORG_ORGANIZATION_DEFINITIONS
VIEW - PER_PEOPLE_F
SYNONYM - PO_HEADERS_ALL

APPS.ITG_SP_PO_PART_SOLDTO_V is not referenced by any database object

[top of page]

View: ITG_SP_PO_PART_SUPPL_V

Comments

This view is used to generate the partner supplier segment in the Sync PO XML

Columns
Name Datatype Length Mandatory Comments
PO_HEADER_ID NUMBER
Y
VENDOR_ID NUMBER

VENDOR_SITE_ID NUMBER

VENDOR_CONTACT_ID NUMBER

VENDOR_NAME VARCHAR2 (240)
ONETIME NUMBER

PARTNRID VARCHAR2 (30)
PARTNRTYPE CHAR (8)
CURRENCY VARCHAR2 (15)
VEN_DESCRIPTN VARCHAR2 (320)
PARTNRIDX VARCHAR2 (40)
TAXEXEMPT NUMBER

TAXID VARCHAR2 (20)
UA_SUP_USFLAG VARCHAR2 (1)
ADDRESS_LINE1 VARCHAR2 (240)
ADDRESS_LINE2 VARCHAR2 (240)
ADDRESS_LINE3 VARCHAR2 (240)
ADDRESS_LINE4 VARCHAR2 (240)
ADDRTYPE VARCHAR2 (0)
CITY VARCHAR2 (25)
COUNTRY VARCHAR2 (25)
COUNTY VARCHAR2 (150)
SITE_DESCRIPTN VARCHAR2 (15)
FAX VARCHAR2 (26)
POSTALCODE VARCHAR2 (20)
STATEPROVN VARCHAR2 (150)
TELEPHONE VARCHAR2 (26)
UA_VATCODE VARCHAR2 (0)
UA_SITE_PURSITE VARCHAR2 (1)
UA_SITE_PAYSITE VARCHAR2 (1)
UA_SITE_RFQSITE VARCHAR2 (1)
UA_SITE_PCSITE VARCHAR2 (1)
CONTACT_NAME VARCHAR2 (48)
CONTACT_DESCRIPTN VARCHAR2 (31)
CONTACT_EMAIL VARCHAR2 (0)
CONTACT_FAX VARCHAR2 (26)
CONTACT_PHONE VARCHAR2 (51)

[top of page]

APPS.ITG_SP_PO_PART_SUPPL_V references the following:

APPS
SYNONYM - PO_HEADERS_ALL
VIEW - PO_VENDORS
VIEW - PO_VENDOR_CONTACTS
VIEW - PO_VENDOR_SITES_ALL

APPS.ITG_SP_PO_PART_SUPPL_V is not referenced by any database object

[top of page]

View: ITG_SP_PO_POLINE_V

Comments

This view is used to generate the XML for Sync PO at the po line level

Columns
Name Datatype Length Mandatory Comments
PO_HEADER_ID NUMBER
Y
PO_LINE_ID NUMBER
Y
UNIT_AMOUNT NUMBER

UNIT_CURRENCY VARCHAR2 (15)
UNIT_QUANTITY NUMBER

UNIT_UOM VARCHAR2 (3)
ORDERED_QUANTITY NUMBER

POLINENUM VARCHAR2 (40)
COMMODITY VARCHAR2 (4000)
CONTRACTS VARCHAR2 (20)
FRGHTCLS VARCHAR2 (25)
HAZRDMATL VARCHAR2 (40)
ITEMRV VARCHAR2 (3)
ITEMTYPE VARCHAR2 (240)
NOTES VARCHAR2 (480)
POENTITY VARCHAR2 (40)
ITEM VARCHAR2 (4000)
ITEMX VARCHAR2 (25)
UA_REF_STATUS VARCHAR2 (4)
UA_REF_EXP VARCHAR2 (1)
UA_REF_ATTR VARCHAR2 (150)
UA_LINE_ATTR1 VARCHAR2 (150)
UA_LINE_ATTR2 VARCHAR2 (150)
UA_LINE_ATTR3 VARCHAR2 (150)
UA_LINE_ATTR4 VARCHAR2 (150)
UA_LINE_ATTR5 VARCHAR2 (150)
UA_LINE_ATTR6 VARCHAR2 (150)
UA_LINE_ATTR7 VARCHAR2 (150)
UA_LINE_ATTR8 VARCHAR2 (150)
UA_LINE_ATTR9 VARCHAR2 (150)
UA_LINE_ATTR10 VARCHAR2 (150)
UA_LINE_ATTR11 VARCHAR2 (150)
UA_LINE_ATTR12 VARCHAR2 (150)
UA_LINE_ATTR13 VARCHAR2 (150)
UA_LINE_ATTR14 VARCHAR2 (150)
UA_LINE_ATTR15 VARCHAR2 (150)
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)

[top of page]

APPS.ITG_SP_PO_POLINE_V references the following:

APPS
PACKAGE - ITG_X_UTILS
SYNONYM - MTL_CATEGORIES
SYNONYM - MTL_SYSTEM_ITEMS
SYNONYM - MTL_UNITS_OF_MEASURE
SYNONYM - PO_HAZARD_CLASSES_TL
SYNONYM - PO_HEADERS_ALL
SYNONYM - PO_LINES_ALL

APPS.ITG_SP_PO_POLINE_V is not referenced by any database object

[top of page]

View: ITG_SP_PO_POTERM_V

Comments

This view is used to generate the PO terms segment of the XML for Sync PO

Columns
Name Datatype Length Mandatory Comments
PO_HEADER_ID NUMBER
Y
TERMS_ID NUMBER

DESCRIPTION VARCHAR2 (240)
TERMID VARCHAR2 (50)
DAYOFMONTH VARCHAR2 (40)
PROXMONTH VARCHAR2 (40)
OPERAMT NUMBER

[top of page]

APPS.ITG_SP_PO_POTERM_V references the following:

APPS
SYNONYM - AP_TERMS
SYNONYM - AP_TERMS_LINES
SYNONYM - PO_HEADERS_ALL

APPS.ITG_SP_PO_POTERM_V is not referenced by any database object

[top of page]

View: ITG_SP_REL_HEADERS_V

Comments

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

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

OPERAMT_EXTENDED NUMBER

OPERAMT_CURRENCY VARCHAR2 (15)
POID VARCHAR2 (20) Y
BUYERID VARCHAR2 (240)
DELIVERTO VARCHAR2 (60)
NOTES VARCHAR2 (240)
POENTITY VARCHAR2 (40)
PORELEASE NUMBER
Y
POSTATUS VARCHAR2 (25)
POTYPE VARCHAR2 (25) Y
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)

[top of page]

APPS.ITG_SP_REL_HEADERS_V references the following:

APPS
PACKAGE - HR_GENERAL
SYNONYM - HR_LOCATIONS_ALL
PACKAGE - HR_PERSON_NAME
PACKAGE - HR_SECURITY
PACKAGE - ITG_X_UTILS
VIEW - PER_PEOPLE_F
SYNONYM - PO_HEADERS_ALL
SYNONYM - PO_RELEASES_ALL

APPS.ITG_SP_REL_HEADERS_V is not referenced by any database object

[top of page]

View: ITG_SP_REL_LINE_DIST_V

Comments

This view is used to generate XML and at po release lines distributions level

Columns
Name Datatype Length Mandatory Comments
PO_DISTRIBUTION_ID NUMBER
Y
PO_HEADER_ID NUMBER
Y
PO_RELEASE_ID NUMBER

PO_LINE_ID NUMBER

LINE_LOCATION_ID NUMBER

OPERAMT_EXTENDED NUMBER

OPERAMT_CURRENCY VARCHAR2 (15)
OPERAMT_UOMVALUE NUMBER

OPERAMT_UOM VARCHAR2 (3)
COSTCENTER VARCHAR2 (25)
ELEMENT1 VARCHAR2 (25)
ELEMENT2 VARCHAR2 (25)
ELEMENT3 VARCHAR2 (25)
ELEMENT4 VARCHAR2 (25)
ELEMENT5 VARCHAR2 (25)
ELEMENT6 VARCHAR2 (25)
ELEMENT7 VARCHAR2 (25)
ELEMENT8 VARCHAR2 (25)
ELEMENT9 VARCHAR2 (25)
ELEMENT10 VARCHAR2 (25)
ELEMENT11 VARCHAR2 (25)
ELEMENT12 VARCHAR2 (25)
ELEMENT13 VARCHAR2 (25)
ELEMENT14 VARCHAR2 (25)
ELEMENT15 VARCHAR2 (25)
ELEMENT16 VARCHAR2 (25)
ELEMENT17 VARCHAR2 (25)
ELEMENT18 VARCHAR2 (25)
ELEMENT19 VARCHAR2 (25)
ELEMENT20 VARCHAR2 (25)
ELEMENT21 VARCHAR2 (25)
ELEMENT22 VARCHAR2 (25)
ELEMENT23 VARCHAR2 (25)
ELEMENT24 VARCHAR2 (25)
ELEMENT25 VARCHAR2 (25)
ELEMENT26 VARCHAR2 (25)
ELEMENT27 VARCHAR2 (25)
ELEMENT28 VARCHAR2 (25)
ELEMENT29 VARCHAR2 (25)
ELEMENT30 VARCHAR2 (25)
GLENTITYS VARCHAR2 (40)
GLNOMACCT VARCHAR2 (25)
PROJECT VARCHAR2 (40)
UNIT VARCHAR2 (240)
UA_DISTRID VARCHAR2 (40)
UA_SCHEDLID VARCHAR2 (40)
UA_LINENUM VARCHAR2 (40)
UA_DELIVERTO VARCHAR2 (30)
UA_DIST_ATTR1 VARCHAR2 (150)
UA_DIST_ATTR2 VARCHAR2 (150)
UA_DIST_ATTR3 VARCHAR2 (150)
UA_DIST_ATTR4 VARCHAR2 (150)
UA_DIST_ATTR5 VARCHAR2 (150)
UA_DIST_ATTR6 VARCHAR2 (150)
UA_DIST_ATTR7 VARCHAR2 (150)
UA_DIST_ATTR8 VARCHAR2 (150)
UA_DIST_ATTR9 VARCHAR2 (150)
UA_DIST_ATTR10 VARCHAR2 (150)
UA_DIST_ATTR11 VARCHAR2 (150)
UA_DIST_ATTR12 VARCHAR2 (150)
UA_DIST_ATTR13 VARCHAR2 (150)
UA_DIST_ATTR14 VARCHAR2 (150)
UA_DIST_ATTR15 VARCHAR2 (150)
UA_REQUISITNID VARCHAR2 (4000)
UA_REQLINENUM VARCHAR2 (4000)

[top of page]

APPS.ITG_SP_REL_LINE_DIST_V references the following:

APPS
SYNONYM - GL_CODE_COMBINATIONS
PACKAGE - HR_GENERAL
PACKAGE - HR_PERSON_NAME
PACKAGE - HR_SECURITY
PACKAGE - ITG_X_UTILS
SYNONYM - MTL_UNITS_OF_MEASURE
VIEW - ORG_ORGANIZATION_DEFINITIONS
VIEW - PER_PEOPLE_F
SYNONYM - PO_DISTRIBUTIONS_ALL
SYNONYM - PO_HEADERS_ALL
SYNONYM - PO_LINE_LOCATIONS_ALL

APPS.ITG_SP_REL_LINE_DIST_V is not referenced by any database object

[top of page]

View: ITG_SP_REL_LINE_PART_EMPL_V

Comments

This view is used to generate partner employee segment at po release line level

Columns
Name Datatype Length Mandatory Comments
PO_DISTRIBUTION_ID NUMBER
Y
PO_HEADER_ID NUMBER
Y
PO_LINE_ID NUMBER

LINE_LOCATION_ID NUMBER

DELIVER_TO_LOCATION_ID NUMBER

DELIVER_TO_PERSON_ID NUMBER (9)
NAME VARCHAR2 (60)
PARTNRID VARCHAR2 (30)
PARTNRTYPE CHAR (8)
DESCRIPTN_PARTNER VARCHAR2 (240)
PARTNRIDX VARCHAR2 (40)
TAXEXEMPT NUMBER

UA_REF_SCHEDLID VARCHAR2 (40)
UA_REF_DISTRID VARCHAR2 (40)
UA_REQUISITNID VARCHAR2 (4000)
ADDRESS_LINE_1 VARCHAR2 (240)
ADDRESS_LINE_2 VARCHAR2 (240)
ADDRESS_LINE_3 VARCHAR2 (240)
CITY VARCHAR2 (30)
COUNTRY VARCHAR2 (60)
COUNTY VARCHAR2 (4000)
DESCRIPTN_ADDRS VARCHAR2 (240)
POSTAL_CODE VARCHAR2 (30)
STATEPROVN VARCHAR2 (4000)
TELEPHONE VARCHAR2 (60)
CONTACT_NAME VARCHAR2 (240)
CONTACT_EMAIL VARCHAR2 (240)
CONTACT_PHONE VARCHAR2 (4000)

[top of page]

APPS.ITG_SP_REL_LINE_PART_EMPL_V references the following:

APPS
PACKAGE - HR_GENERAL
SYNONYM - HR_LOCATIONS_ALL
SYNONYM - HR_LOCATIONS_ALL_TL
PACKAGE - HR_PERSON_NAME
PACKAGE - HR_SECURITY
PACKAGE - ITG_X_UTILS
VIEW - PER_PEOPLE_F
SYNONYM - PO_DISTRIBUTIONS_ALL

APPS.ITG_SP_REL_LINE_PART_EMPL_V is not referenced by any database object

[top of page]

View: ITG_SP_REL_LINE_PART_SHIPTO_V

Comments

This view is used to generate the partner shipto segment in the PO Release line of the PO Release XML

Columns
Name Datatype Length Mandatory Comments
PO_HEADER_ID NUMBER
Y
PO_LINE_ID NUMBER
Y
LINE_LOCATION_ID NUMBER
Y
SHIP_TO_LOCATION_ID NUMBER

SHIP_TO_ORGANIZATION_ID NUMBER

NAME VARCHAR2 (240)
PARTNRID VARCHAR2 (3)
PARTNRTYPE CHAR (6)
DESCRIPTN_PARTNER VARCHAR2 (60)
PARTNRIDX VARCHAR2 (40)
TAXEXEMPT NUMBER

TAXID VARCHAR2 (4000)
UA_REF_SCHEDLID VARCHAR2 (40)
ADDRESS_LINE_1 VARCHAR2 (240)
ADDRESS_LINE_2 VARCHAR2 (240)
ADDRESS_LINE_3 VARCHAR2 (240)
CITY VARCHAR2 (30)
COUNTRY VARCHAR2 (60)
COUNTY VARCHAR2 (4000)
DESCRIPTN_ADDRS VARCHAR2 (240)
POSTAL_CODE VARCHAR2 (30)
STATEPROVN VARCHAR2 (4000)
TELEPHONE VARCHAR2 (60)

[top of page]

APPS.ITG_SP_REL_LINE_PART_SHIPTO_V references the following:

APPS
PACKAGE - HR_GENERAL
SYNONYM - HR_LOCATIONS_ALL
SYNONYM - HR_LOCATIONS_ALL_TL
PACKAGE - HR_SECURITY
PACKAGE - ITG_X_UTILS
VIEW - ORG_ORGANIZATION_DEFINITIONS
SYNONYM - PO_LINE_LOCATIONS_ALL

APPS.ITG_SP_REL_LINE_PART_SHIPTO_V is not referenced by any database object

[top of page]

View: ITG_SP_REL_LINE_SCHED_V

Comments

This view is used to generate XML at po release line schedules level

Columns
Name Datatype Length Mandatory Comments
PO_HEADER_ID NUMBER
Y
PO_RELEASE_ID NUMBER

PO_LINE_ID NUMBER
Y
LINE_LOCATION_ID NUMBER
Y
DATETIME_NEEDDELV DATE

ORDERED_QUANTITY NUMBER

ORDERED_UOM VARCHAR2 (3) Y
SHIPMENT_NUM NUMBER

UA_SCHEDLID VARCHAR2 (40)
UA_SCHED_ATTR1 VARCHAR2 (150)
UA_SCHED_ATTR2 VARCHAR2 (150)
UA_SCHED_ATTR3 VARCHAR2 (150)
UA_SCHED_ATTR4 VARCHAR2 (150)
UA_SCHED_ATTR5 VARCHAR2 (150)
UA_SCHED_ATTR6 VARCHAR2 (150)
UA_SCHED_ATTR7 VARCHAR2 (150)
UA_SCHED_ATTR8 VARCHAR2 (150)
UA_SCHED_ATTR9 VARCHAR2 (150)
UA_SCHED_ATTR10 VARCHAR2 (150)
UA_SCHED_ATTR11 VARCHAR2 (150)
UA_SCHED_ATTR12 VARCHAR2 (150)
UA_SCHED_ATTR13 VARCHAR2 (150)
UA_SCHED_ATTR14 VARCHAR2 (150)
UA_SCHED_ATTR15 VARCHAR2 (150)

[top of page]

APPS.ITG_SP_REL_LINE_SCHED_V references the following:

APPS
SYNONYM - MTL_UNITS_OF_MEASURE
SYNONYM - PO_LINES_ALL
SYNONYM - PO_LINE_LOCATIONS_ALL

APPS.ITG_SP_REL_LINE_SCHED_V is not referenced by any database object

[top of page]

View: ITG_SP_REL_PART_SHIPTO_V

Comments

This view is used to generate partner shipto segment for the PO release XML

Columns
Name Datatype Length Mandatory Comments
PO_HEADER_ID NUMBER
Y
VENDOR_ID NUMBER

AGENT_ID NUMBER (9) Y
SHIP_TO_LOCATION_ID NUMBER

NAME VARCHAR2 (60)
PARTNRID VARCHAR2 (30)
PARTNRTYPE CHAR (6)
DESCRIPTION VARCHAR2 (240)
PARTNRIDX NUMBER

TAXEXEMPT VARCHAR2 (1)
TAXID VARCHAR2 (20)
UA_SOLD_BILLFLAG VARCHAR2 (30)
UA_SOLD_SHIPFLAG VARCHAR2 (30)
UA_SOLD_RECFLAG VARCHAR2 (30)
ADDRESS_LINE_1 VARCHAR2 (240)
ADDRESS_LINE_2 VARCHAR2 (240)
ADDRESS_LINE_3 VARCHAR2 (240)
ADDRTYPE VARCHAR2 (0)
CITY VARCHAR2 (30)
COUNTRY VARCHAR2 (60)
COUNTY VARCHAR2 (4000)
SITE_DESCRIPTN VARCHAR2 (240)
POSTAL_CODE VARCHAR2 (30)
STATEPROVN VARCHAR2 (4000)
TELEPHONE VARCHAR2 (60)
CONTACT_NAME VARCHAR2 (240)
CONTACT_EMAIL VARCHAR2 (240)
CONTACT_PHONE VARCHAR2 (4000)

[top of page]

APPS.ITG_SP_REL_PART_SHIPTO_V references the following:

APPS
PACKAGE - HR_GENERAL
SYNONYM - HR_LOCATIONS_ALL
SYNONYM - HR_LOCATIONS_ALL_TL
PACKAGE - HR_PERSON_NAME
PACKAGE - HR_SECURITY
PACKAGE - ITG_X_UTILS
VIEW - PER_PEOPLE_F
SYNONYM - PO_HEADERS_ALL
VIEW - PO_VENDORS

APPS.ITG_SP_REL_PART_SHIPTO_V is not referenced by any database object

[top of page]

View: ITG_SP_REL_PART_SOLDTO_V

Comments

This view is used to generate the partner sold to segment in the PO release XML

Columns
Name Datatype Length Mandatory Comments
PO_HEADER_ID NUMBER
Y
BILL_TO_LOCATION_ID NUMBER

AGENT_ID NUMBER (9) Y
INVORGID NUMBER (15)
SET_OF_BOOKS_ID NUMBER (15) Y
ORGANIZATION_NAME VARCHAR2 (240) Y
PARTNRID VARCHAR2 (3)
PARTNRTYPE CHAR (6)
CURRENCY VARCHAR2 (15) Y
PARTNRIDX NUMBER (15)
UA_SOLD_BILLFLAG VARCHAR2 (30)
UA_SOLD_SHIPFLAG VARCHAR2 (30)
UA_SOLD_RECFLAG VARCHAR2 (30)
ADDRESS_LINE_1 VARCHAR2 (240)
ADDRESS_LINE_2 VARCHAR2 (240)
ADDRESS_LINE_3 VARCHAR2 (240)
ADDRTYPE VARCHAR2 (0)
CITY VARCHAR2 (30)
COUNTRY VARCHAR2 (60)
COUNTY VARCHAR2 (4000)
SITE_DESCRIPTN VARCHAR2 (240)
POSTAL_CODE VARCHAR2 (30)
STATEPROVN VARCHAR2 (4000)
TELEPHONE VARCHAR2 (60)
CONTACT_NAME VARCHAR2 (240)
CONTACT_EMAIL VARCHAR2 (240)
CONTACT_PHONE VARCHAR2 (4000)

[top of page]

APPS.ITG_SP_REL_PART_SOLDTO_V references the following:

APPS
VIEW - GL_SETS_OF_BOOKS
PACKAGE - HR_GENERAL
SYNONYM - HR_LOCATIONS_ALL
SYNONYM - HR_LOCATIONS_ALL_TL
PACKAGE - HR_PERSON_NAME
PACKAGE - HR_SECURITY
PACKAGE - ITG_X_UTILS
VIEW - ORG_ORGANIZATION_DEFINITIONS
VIEW - PER_PEOPLE_F
SYNONYM - PO_HEADERS_ALL

APPS.ITG_SP_REL_PART_SOLDTO_V is not referenced by any database object

[top of page]

View: ITG_SP_REL_PART_SUPPL_V

Comments

This view is used to generate the partner supplier segment in the po release XML

Columns
Name Datatype Length Mandatory Comments
PO_HEADER_ID NUMBER
Y
VENDOR_ID NUMBER

VENDOR_SITE_ID NUMBER

VENDOR_CONTACT_ID NUMBER

VENDOR_NAME VARCHAR2 (240)
ONETIME NUMBER

PARTNRID VARCHAR2 (30)
PARTNRTYPE CHAR (8)
CURRENCY VARCHAR2 (15)
VEN_DESCRIPTN VARCHAR2 (320)
PARTNRIDX VARCHAR2 (40)
TAXEXEMPT VARCHAR2 (1)
TAXID VARCHAR2 (20)
UA_SUP_USFLAG VARCHAR2 (1)
ADDRESS_LINE1 VARCHAR2 (240)
ADDRESS_LINE2 VARCHAR2 (240)
ADDRESS_LINE3 VARCHAR2 (240)
ADDRESS_LINE4 VARCHAR2 (240)
ADDRTYPE VARCHAR2 (0)
CITY VARCHAR2 (25)
COUNTRY VARCHAR2 (25)
COUNTY VARCHAR2 (150)
SITE_DESCRIPTN VARCHAR2 (15)
FAX VARCHAR2 (26)
POSTALCODE VARCHAR2 (20)
STATEPROVN VARCHAR2 (150)
TELEPHONE VARCHAR2 (26)
UA_VATCODE VARCHAR2 (30)
UA_SITE_PURSITE VARCHAR2 (1)
UA_SITE_PAYSITE VARCHAR2 (1)
UA_SITE_RFQSITE VARCHAR2 (1)
UA_SITE_PCSITE VARCHAR2 (1)
CONTACT_NAME VARCHAR2 (48)
CONTACT_DESCRIPTN VARCHAR2 (31)
CONTACT_EMAIL VARCHAR2 (0)
CONTACT_FAX VARCHAR2 (26)
CONTACT_PHONE VARCHAR2 (51)

[top of page]

APPS.ITG_SP_REL_PART_SUPPL_V references the following:

APPS
SYNONYM - PO_HEADERS_ALL
VIEW - PO_VENDORS
VIEW - PO_VENDOR_CONTACTS
VIEW - PO_VENDOR_SITES_ALL

APPS.ITG_SP_REL_PART_SUPPL_V is not referenced by any database object

[top of page]

View: ITG_SP_REL_POLINE_V

Comments

This view is used to generate the PO release line segment in the Sync PO Release XML

Columns
Name Datatype Length Mandatory Comments
PO_HEADER_ID NUMBER
Y
PO_LINE_ID NUMBER
Y
LINE_LOCATION_ID NUMBER
Y
PO_RELEASE_ID NUMBER
Y
UNIT_AMOUNT NUMBER

UNIT_CURRENCY VARCHAR2 (15)
UNIT_QUANTITY NUMBER

UNIT_UOM VARCHAR2 (3)
ORDERED_QUANTITY NUMBER

POLINENUM VARCHAR2 (40)
COMMODITY VARCHAR2 (4000)
CONTRACTS VARCHAR2 (20)
FRGHTCLS VARCHAR2 (25)
HAZRDMATL VARCHAR2 (40)
ITEMRV VARCHAR2 (3)
ITEMTYPE VARCHAR2 (240)
NOTES VARCHAR2 (480)
POENTITY VARCHAR2 (40)
ITEM VARCHAR2 (4000)
ITEMX VARCHAR2 (25)
UA_REF_STATUS VARCHAR2 (4)
UA_REF_EXP VARCHAR2 (1)
UA_REF_ATTR VARCHAR2 (150)
UA_LINE_ATTR1 VARCHAR2 (150)
UA_LINE_ATTR2 VARCHAR2 (150)
UA_LINE_ATTR3 VARCHAR2 (150)
UA_LINE_ATTR4 VARCHAR2 (150)
UA_LINE_ATTR5 VARCHAR2 (150)
UA_LINE_ATTR6 VARCHAR2 (150)
UA_LINE_ATTR7 VARCHAR2 (150)
UA_LINE_ATTR8 VARCHAR2 (150)
UA_LINE_ATTR9 VARCHAR2 (150)
UA_LINE_ATTR10 VARCHAR2 (150)
UA_LINE_ATTR11 VARCHAR2 (150)
UA_LINE_ATTR12 VARCHAR2 (150)
UA_LINE_ATTR13 VARCHAR2 (150)
UA_LINE_ATTR14 VARCHAR2 (150)
UA_LINE_ATTR15 VARCHAR2 (150)
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)

[top of page]

APPS.ITG_SP_REL_POLINE_V references the following:

APPS
PACKAGE - ITG_X_UTILS
SYNONYM - MTL_CATEGORIES
SYNONYM - MTL_SYSTEM_ITEMS
SYNONYM - MTL_UNITS_OF_MEASURE
SYNONYM - PO_HAZARD_CLASSES_TL
SYNONYM - PO_HEADERS_ALL
SYNONYM - PO_LINES_ALL
SYNONYM - PO_LINE_LOCATIONS_ALL
SYNONYM - PO_RELEASES_ALL

APPS.ITG_SP_REL_POLINE_V is not referenced by any database object

[top of page]

View: ITG_SP_REL_POTERM_V

Comments

This view is used to generate the XML for the PO release terms segment in Sync PO Release XML

Columns
Name Datatype Length Mandatory Comments
PO_HEADER_ID NUMBER
Y
TERMS_ID NUMBER

DESCRIPTION VARCHAR2 (240)
TERMID VARCHAR2 (50)
DAYOFMONTH VARCHAR2 (40)
PROXMONTH VARCHAR2 (40)
OPERAMT NUMBER

[top of page]

APPS.ITG_SP_REL_POTERM_V references the following:

APPS
SYNONYM - AP_TERMS
SYNONYM - AP_TERMS_LINES
SYNONYM - PO_HEADERS_ALL

APPS.ITG_SP_REL_POTERM_V is not referenced by any database object

[top of page]

View: ITG_UPDEL_HEADERS_V

Comments

This view is used to generate XML at header level for Update Delivery XML

Columns
Name Datatype Length Mandatory Comments
SHIPMENT_HEADER_ID NUMBER
Y
CREATION_DATE DATE
Y
RECEIPTID VARCHAR2 (30)
SITELEVEL_1 NUMBER (15)
EMPLOYEEID VARCHAR2 (240)
EMPLOYEE_EMAIL VARCHAR2 (240)
NOTES VARCHAR2 (4000)
SITELEVEL_2 NUMBER

BILLOLADING VARCHAR2 (25)
DATETIME_SHIP DATE

UA_RCPTSOURCE VARCHAR2 (25) Y
UA_SHIPMENTNO VARCHAR2 (30)
UA_PACKINGSLIP VARCHAR2 (25)
UA_CARRIER VARCHAR2 (25)
UA_SUPPLIER VARCHAR2 (30)
VENDOR_NAME VARCHAR2 (240)
UA_WAYBILL VARCHAR2 (20)
UA_ATTRIBUTE1 VARCHAR2 (150)
UA_ATTRIBUTE2 VARCHAR2 (150)
UA_ATTRIBUTE3 VARCHAR2 (150)
UA_ATTRIBUTE4 VARCHAR2 (150)
UA_ATTRIBUTE5 VARCHAR2 (150)
UA_ATTRIBUTE6 VARCHAR2 (150)
UA_ATTRIBUTE7 VARCHAR2 (150)
UA_ATTRIBUTE8 VARCHAR2 (150)
UA_ATTRIBUTE9 VARCHAR2 (150)
UA_ATTRIBUTE10 VARCHAR2 (150)
UA_ATTRIBUTE11 VARCHAR2 (150)
UA_ATTRIBUTE12 VARCHAR2 (150)
UA_ATTRIBUTE13 VARCHAR2 (150)
UA_ATTRIBUTE14 VARCHAR2 (150)
UA_ATTRIBUTE15 VARCHAR2 (150)
HR_ORGANIZATION_NAME VARCHAR2 (240)
HR_ADDRESS_LINE_1 VARCHAR2 (240)
HR_ADDRESS_LINE_2 VARCHAR2 (240)
HR_ADDRESS_LINE_3 VARCHAR2 (240)
HR_CITY VARCHAR2 (30)
HR_COUNTRY VARCHAR2 (60)
HR_POSTAL_CODE VARCHAR2 (30)
PO_CONTACT_NAME VARCHAR2 (47)
PO_PHONE VARCHAR2 (51)
PO_EMAIL_ADDRESS VARCHAR2 (2000)
PO_ADDRESS_LINE_1 VARCHAR2 (240)
PO_ADDRESS_LINE_2 VARCHAR2 (240)
PO_ADDRESS_LINE_3 VARCHAR2 (240)
PO_CITY VARCHAR2 (25)
PO_COUNTRY VARCHAR2 (25)
PO_ZIP VARCHAR2 (20)
PO_EDI_LOCATION_CODE VARCHAR2 (60)
VENDOR_ID NUMBER

VENDOR_SITE_ID NUMBER

[top of page]

APPS.ITG_UPDEL_HEADERS_V references the following:

APPS
PACKAGE - FND_GLOBAL
PACKAGE - HR_API
PACKAGE - HR_GENERAL
VIEW - HR_ORGANIZATION_UNITS_V
PACKAGE - HR_PERSON_NAME
PACKAGE - HR_SECURITY
VIEW - ORG_ORGANIZATION_DEFINITIONS
VIEW - PER_PEOPLE_F
VIEW - PO_VENDORS
VIEW - PO_VENDOR_CONTACTS
VIEW - PO_VENDOR_SITES_ALL
SYNONYM - RCV_SHIPMENT_HEADERS

APPS.ITG_UPDEL_HEADERS_V is not referenced by any database object

[top of page]

View: ITG_UPDEL_LINES_V

Comments
View Type

A public view which may be useful for custom reporting or other data requirements.

This view is used to generate XML at line level for Update Delivery XML

Columns
Name Datatype Length Mandatory Comments
SHIPMENT_HEADER_ID NUMBER

LINE_NUM NUMBER
Y
TRANSACTION_ID NUMBER

REQUEST_ID NUMBER

QUANT_RECV_QUANTITY NUMBER

QUANT_RECV_UOMCODE VARCHAR2 (3) Y
TRANSACTION_DATE_DELIVACT DATE

ITEM VARCHAR2 (4000)
RECLINENUM VARCHAR2 (40)
DECSRIPTN VARCHAR2 (240)
ITEMRV VARCHAR2 (3)
ITEMX VARCHAR2 (25)
LINE_NOTES VARCHAR2 (4000)
POID VARCHAR2 (20)
POLINENUM VARCHAR2 (40)
PORELEASE VARCHAR2 (40)
PSCLINENUM VARCHAR2 (40)
RECEPTDISP VARCHAR2 (25)
LINE_UA_ORG VARCHAR2 (240)
LINE_UA_SUBINV VARCHAR2 (10)
LINE_UA_LOCATOR VARCHAR2 (4000)
LINE_UA_DELIVERTO VARCHAR2 (240)
LINE_UA_DELVLOC VARCHAR2 (60)
LINE_UA_RCVTRANID NUMBER

LINE_UA_DESTTYPE VARCHAR2 (25)
LINE_UA_INSPSTS VARCHAR2 (25)
LINE_UA_PACKINGSLIP VARCHAR2 (25)
LINE_UA_RMA VARCHAR2 (30)
LINE_UA_XREF VARCHAR2 (4000)
LINE_UA_SHIPTOLOC VARCHAR2 (60)
LINE_UA_REASONCODE VARCHAR2 (30)
LINE_UA_ATTRIBUTE1 VARCHAR2 (150)
LINE_UA_ATTRIBUTE2 VARCHAR2 (150)
LINE_UA_ATTRIBUTE3 VARCHAR2 (150)
LINE_UA_ATTRIBUTE4 VARCHAR2 (150)
LINE_UA_ATTRIBUTE5 VARCHAR2 (150)
LINE_UA_ATTRIBUTE6 VARCHAR2 (150)
LINE_UA_ATTRIBUTE7 VARCHAR2 (150)
LINE_UA_ATTRIBUTE8 VARCHAR2 (150)
LINE_UA_ATTRIBUTE9 VARCHAR2 (150)
LINE_UA_ATTRIBUTE10 VARCHAR2 (150)
LINE_UA_ATTRIBUTE11 VARCHAR2 (150)
LINE_UA_ATTRIBUTE12 VARCHAR2 (150)
LINE_UA_ATTRIBUTE13 VARCHAR2 (150)
LINE_UA_ATTRIBUTE14 VARCHAR2 (150)
LINE_UA_ATTRIBUTE15 VARCHAR2 (150)
TXN_UOM VARCHAR2 (25)
SHIP_VIA_LOOKUP_CODE VARCHAR2 (25)
SEGMENT1 VARCHAR2 (40)

[top of page]

APPS.ITG_UPDEL_LINES_V references the following:

APPS
PACKAGE - HR_GENERAL
SYNONYM - HR_LOCATIONS_ALL_TL
PACKAGE - HR_PERSON_NAME
PACKAGE - HR_SECURITY
PACKAGE - ITG_X_UTILS
SYNONYM - MTL_ITEM_LOCATIONS
SYNONYM - MTL_SYSTEM_ITEMS
SYNONYM - MTL_TRANSACTION_REASONS
SYNONYM - MTL_UNITS_OF_MEASURE
VIEW - ORG_ORGANIZATION_DEFINITIONS
VIEW - PER_PEOPLE_F
SYNONYM - PO_HEADERS_ALL
SYNONYM - PO_LINES_ALL
SYNONYM - PO_LINE_LOCATIONS_ALL
SYNONYM - PO_RELEASES_ALL
SYNONYM - RCV_SHIPMENT_HEADERS
SYNONYM - RCV_SHIPMENT_LINES
SYNONYM - RCV_TRANSACTIONS

APPS.ITG_UPDEL_LINES_V is not referenced by any database object

[top of page]
Copyright (c) 2001 - 2005, Oracle - Use Restricted by Contract