FND Design Data [Home] [Help]

Table: JAI_PO_OSP_HDRS

Product: JA - Asia/Pacific Localizations
Description: Stores 57F4 Header Information for Purchase Orders of type OSP.
Implementation/DBA Data: TableJA.JAI_PO_OSP_HDRS
Primary Key: JAI_PO_OSP_HDRS_PK
  1. ColumnFORM_ID
Primary Key: JAI_PO_OSP_HDRS_UK1
  1. ColumnORGANIZATION_ID
  2. ColumnLOCATION_ID
  3. ColumnFORM_NUMBER
  4. ColumnPO_HEADER_ID
  5. ColumnOTH_DOC_ID
Foreign Keys
Table
Foreign Table Foreign Key Column
JAI_PO_OSP_HDRS FK Joins to TableHZ_PARTIES JAI_PO_OSP_HDRS.VENDOR_ID
JAI_PO_OSP_HDRS FK Joins to TableHZ_PARTY_SITES JAI_PO_OSP_HDRS.VENDOR_SITE_ID
JAI_PO_OSP_HDRS FK Joins to TableHR_ALL_ORGANIZATION_UNITS JAI_PO_OSP_HDRS.ORGANIZATION_ID
JAI_PO_OSP_HDRS FK Joins to TableHR_LOCATIONS_ALL JAI_PO_OSP_HDRS.LOCATION_ID
JAI_PO_OSP_HDRS FK Joins to TablePO_HEADERS_ALL JAI_PO_OSP_HDRS.PO_HEADER_ID
JAI_PO_OSP_HDRS FK Joins to TablePO_RELEASES_ALL JAI_PO_OSP_HDRS.OTH_DOC_ID
JAI_PO_OSP_HDRS FK Joins to TableJAI_PO_OSP_HDRS JAI_PO_OSP_HDRS.PRIMARY_FORM_ID
TableJAI_PO_OSP_HDRS FK Joins to JAI_PO_OSP_HDRS JAI_PO_OSP_HDRS.PRIMARY_FORM_ID