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


VIEW: APPS.ITG_PO_HEADER_ARCH_V

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


Used for XML mapping in the header level


[View Source]

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)
Query Text

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


SELECT POID
,      CONTRACTB
,      REVISION_NUM
,      RELEASE_ID
,      RELEASE_NUM
,      TYPE_LOOKUP_CODE
,      STYLE_NAME
,      PO_CURRENCY
,      ACCEPTANCE_REQUIRED_FLAG
,      ACCEPTANCE_DUE_DATE
,      CREATION_DATE
,      SUPPLIER_ORDER_NUM
,      SUPP_ORG_NAME
,      SUPP_OTF
,      SUPP_PARTNER_TYPE
,      SUPPLIER_PARTNER_ID
,      SUPPLIER_PARTNER_ID_X
,      ORDER_TOTAL
,      SUPP_CURRENCY
,      VAT_REGISTRATION_NUM
,      SUPP_ADDR_LINE1
,      SUPP_ADDR_LINE2
,      SUPP_ADDR_LINE3
,      SUPP_CITY
,      SUPP_COUNTRY
,      SUPP_ZIP
,      SUPP_STATE
,      SUPP_PHONE
,      BUYING_ORG_NAME
,      BUYING_ORG_OTF
,      BUYING_ORG_PARTNER_TYPE
,      PARTNER_ID
,      PARTNER_ID_X
,      BUYING_ORG_CURRENCY
,      BUYING_ORG_LOCATION_ID
,      BUYING_ORG_ADDR_LINE1
,      BUYING_ORG_ADDR_LINE2
,      BUYING_ORG_ADDR_LINE3
,      BUYING_ORG_CITY
,      BUYING_ORG_COUNTRY
,      BUYING_ORG_ZIP
,      BUYING_ORG_STATE
,      BUYING_ORG_PHONE1
,      BUYING_ORG_PHONE2
,      BUYING_ORG_PHONE3
,      BUYER_ID
,      BUYER_FULL_NAME
,      BUYER_EMAIL
,      BUYER_TELEPHONE
,      BILLTO_ORG_NAME
,      BILLTO_ORG_OTF
,      BILLTO_PARTNER_TYPE
,      BILLTO_ORG_CURRENCY
,      BILLTO_ORG_LOCATION_ID
,      BILLTO_ORG_ADDR_LINE1
,      BILLTO_ORG_ADDR_LINE2
,      BILLTO_ORG_ADDR_LINE3
,      BILLTO_ORG_CITY
,      BILLTO_ORG_COUNTRY
,      BILLTO_ORG_ZIP
,      BILLTO_ORG_STATE
,      BILLTO_ORG_PHONE1
,      BILLTO_ORG_PHONE2
,      BILLTO_ORG_PHONE3
,      CARRIER_ORG_NAME
,      CARRIER_ORG_OTF
,      CARRIER_PARTNER_TYPE
,      PAYMENT_TERMS_ID
,      PAYMENT_TERMS_NAME
,      PAYMENT_TERMS_DESCRIPTION
,      FOB_CODE
,      FOB_NAME
,      FOB_DESC
,      FREIGHT_CODE
,      FREIGHT_NAME
,      FREIGHT_DESC
,      NOTE_TO_AUTHORIZER
,      NOTE_TO_VENDOR
,      NOTE_TO_RECEIVER
,      COMMENTS
,      START_DATE_ACTIVE
,      END_DATE_ACTIVE
,      CONFIRMING_ORDER_FLAG
,      EXCHANGE_RATE
,      EXCH_RATE_DATE
,      DFF_HDR_ATTR1
,      DFF_HDR_ATTR2
,      DFF_HDR_ATTR3
,      DFF_HDR_ATTR4
,      DFF_HDR_ATTR5
,      DFF_HDR_ATTR6
,      DFF_HDR_ATTR7
,      DFF_HDR_ATTR8
,      DFF_HDR_ATTR9
,      DFF_HDR_ATTR10
,      DFF_HDR_ATTR11
,      DFF_HDR_ATTR12
,      DFF_HDR_ATTR13
,      DFF_HDR_ATTR14
,      DFF_HDR_ATTR15
,      DFF_HDR_ATTR16
,      CARD_NAME
,      CARD_NUM
,      CARD_EXP_DATE
,      DFF_VEND_ATTR1
,      DFF_VEND_ATTR2
,      DFF_VEND_ATTR3
,      DFF_VEND_ATTR4
,      DFF_VEND_ATTR5
,      DFF_VEND_ATTR6
,      DFF_VEND_ATTR7
,      DFF_VEND_ATTR8
,      DFF_VEND_ATTR9
,      DFF_VEND_ATTR10
,      DFF_VEND_ATTR11
,      DFF_VEND_ATTR12
,      DFF_VEND_ATTR13
,      DFF_VEND_ATTR14
,      DFF_VEND_ATTR15
,      DFF_VEND_ATTR16
,      DFF_VEND_SITE_ATTR1
,      DFF_VEND_SITE_ATTR2
,      DFF_VEND_SITE_ATTR3
,      DFF_VEND_SITE_ATTR4
,      DFF_VEND_SITE_ATTR5
,      DFF_VEND_SITE_ATTR6
,      DFF_VEND_SITE_ATTR7
,      DFF_VEND_SITE_ATTR8
,      DFF_VEND_SITE_ATTR9
,      DFF_VEND_SITE_ATTR10
,      DFF_VEND_SITE_ATTR11
,      DFF_VEND_SITE_ATTR12
,      DFF_VEND_SITE_ATTR13
,      DFF_VEND_SITE_ATTR14
,      DFF_VEND_SITE_ATTR15
,      DFF_VEND_SITE_ATTR16
,      CUSTOMER_NUM
,      SUPPLIER_FAX
,      SUPPLIER_EMAIL
,      SUP_CONTACT_NAME
,      SUP_CONTACT_PHONE
,      LAST_UPDATE_DATE
,      PCARD_ID
,      SUP_SITE_CODE
,      NUM_1099
,      PO_REVISION_NUM
,      LATEST_EXTERNAL_FLAG
,      SHIPPING_CONTROL
,      POSTATUS
FROM APPS.ITG_PO_HEADER_ARCH_V;

Dependencies

[top of page]

APPS.ITG_PO_HEADER_ARCH_V references the following:

SchemaAPPS
SynonymAP_CARDS_ALL
SynonymAP_TERMS
SynonymFINANCIALS_SYSTEM_PARAMS_ALL
PL/SQL PackageFND_GLOBAL - show dependent code
ViewFND_LOOKUP_VALUES_VL
ViewGL_SETS_OF_BOOKS
SynonymHR_ALL_ORGANIZATION_UNITS_TL
PL/SQL PackageHR_API - show dependent code
PL/SQL PackageHR_GENERAL - show dependent code
SynonymHR_LOCATIONS_ALL
ViewHR_ORGANIZATION_UNITS_V
PL/SQL PackageHR_SECURITY - show dependent code
SynonymPER_ALL_PEOPLE_F
PL/SQL PackagePOGOT_S - show dependent code
SynonymPO_DOC_STYLE_LINES_TL
SynonymPO_HEADERS_ALL
SynonymPO_HEADERS_ARCHIVE_ALL
SynonymPO_RELEASES_ARCHIVE_ALL
ViewPO_VENDORS
ViewPO_VENDOR_CONTACTS
ViewPO_VENDOR_SITES_ALL

APPS.ITG_PO_HEADER_ARCH_V is not referenced by any database object