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

TABLE: GML.PO_BPOS_HDR

Object Details
Object Name: PO_BPOS_HDR
Object Type: TABLE
Owner: GML
FND Design Data: TableGML.PO_BPOS_HDR
Subobject Name:
Status: VALID


PO_BPOS_HDR contains the header information for your blanket purchase order documents. You need one row for each blanket purchase order you create. This table is updated when Planned Purchase Orders entered in Oracle Purchasing are approved and transferred into OPM via the CPG_PURCHASING_INTERFACE table.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
PO_BPOS_HDR_PK NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnBPO_ID
PO_BPOS_HDR_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnORGN_CODE
ColumnBPO_NO
Columns
Name Datatype Length Mandatory Comments
BPO_ID NUMBER
Yes Unique surrogate.
ORGN_CODE VARCHAR2 (4) Yes Fk to sy_orgn_mst.
BPO_NO VARCHAR2 (32) Yes Blanket po number.
REL_COUNT NUMBER
Yes Number of releases against bpo.
PAYVEND_ID NUMBER
Yes Fk to po_vend_mst. Vendor to pay.
CONTRACT_NO VARCHAR2 (32)
User defined contract number.
CONTRACT_VALUE NUMBER

Max that can be spent on bpo.
CONTRACT_CURRENCY VARCHAR2 (4) Yes Currency of contract_value.
CURRENCY_BGHT_FWD NUMBER
Yes Currency bought forward flag (1=cbf).
CONTRACT_EXCHANGE_RATE NUMBER
Yes Home/contract_currency exchange rate.
MUL_DIV_SIGN NUMBER
Yes 0 - multiply exhange rate; 1 - divide exchange rate
AMOUNT_PURCHASED NUMBER

Amount spent on bpo.
CONTRACT_START_DATE DATE
Yes Date line item prices effective.
CONTRACT_END_DATE DATE
Yes Last date line item prices effective.
SHIPVEND_ID NUMBER
Yes Fk to po_vend_mst (vendor that ships).
SHIPPER_CODE VARCHAR2 (4)
Fk to op_ship_mst.
RECV_DESC VARCHAR2 (40)
Free form ship-to destination.
SHIP_MTHD VARCHAR2 (4)
Fk to op_ship_mth.
FRTBILL_MTHD VARCHAR2 (4)
Fk to op_frgt_mth.
TERMS_CODE VARCHAR2 (4)
Fk to op_term_mst.
BPO_STATUS NUMBER
Yes 0=not closed; 20=closed.
BPOHOLD_CODE VARCHAR2 (4)
Fk to sy_reas_cds.
CANCELLATION_CODE VARCHAR2 (4)
Fk to sy_reas_cds.
CLOSURE_CODE VARCHAR2 (4)
Fk to sy_reas_cds.
ACTIVITY_IND NUMBER
Yes 1 if po has been cut, otherwise 0.
FOB_CODE VARCHAR2 (4)
Fk to op_fobc_mst.
BUYER_CODE VARCHAR2 (35)
Fk to po_buyr_mst.
ICPURCH_CLASS VARCHAR2 (8)
Fk to ic_prch_cls.
VENDSO_NO VARCHAR2 (32)
Vendor sales order number.
PROJECT_NO VARCHAR2 (16)
Not currently supported
DATE_PRINTED DATE
Yes Date printed onto form for vendor.
REVISION_COUNT NUMBER

Number of times revised.
IN_USE NUMBER

Not currently used
PRINT_COUNT NUMBER
Yes Number of times printed.
CREATION_DATE DATE
Yes Standard who column
CREATED_BY NUMBER (15) Yes Standard who column
LAST_UPDATE_DATE DATE
Yes Standard who column
LAST_UPDATED_BY NUMBER (15) Yes Standard who column
LAST_UPDATE_LOGIN NUMBER (15)
Standard who column
DELETE_MARK NUMBER
Yes Standard: 0=Active record (default); 1=Marked for (logical) deletion.
TEXT_CODE NUMBER (10)
ID which joins any rows of text in this table to the Text Table for this Module
ORGNADDR_ID NUMBER

Fk to sy_addr_mst. Address of the organization creating the bpo.
ATTRIBUTE1 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE2 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE3 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE4 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE5 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE6 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE7 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE8 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE9 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE10 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE11 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE12 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE13 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE14 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE15 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE16 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE17 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE18 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE19 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE20 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE21 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE22 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE23 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE24 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE25 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE26 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE27 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE28 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE29 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE30 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE_CATEGORY VARCHAR2 (30)
Descriptive flexfield segment
PURCH_CATEGORY_ID NUMBER

Category Id for PURCH_CLASS
Query Text

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


SELECT BPO_ID
,      ORGN_CODE
,      BPO_NO
,      REL_COUNT
,      PAYVEND_ID
,      CONTRACT_NO
,      CONTRACT_VALUE
,      CONTRACT_CURRENCY
,      CURRENCY_BGHT_FWD
,      CONTRACT_EXCHANGE_RATE
,      MUL_DIV_SIGN
,      AMOUNT_PURCHASED
,      CONTRACT_START_DATE
,      CONTRACT_END_DATE
,      SHIPVEND_ID
,      SHIPPER_CODE
,      RECV_DESC
,      SHIP_MTHD
,      FRTBILL_MTHD
,      TERMS_CODE
,      BPO_STATUS
,      BPOHOLD_CODE
,      CANCELLATION_CODE
,      CLOSURE_CODE
,      ACTIVITY_IND
,      FOB_CODE
,      BUYER_CODE
,      ICPURCH_CLASS
,      VENDSO_NO
,      PROJECT_NO
,      DATE_PRINTED
,      REVISION_COUNT
,      IN_USE
,      PRINT_COUNT
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      DELETE_MARK
,      TEXT_CODE
,      ORGNADDR_ID
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      ATTRIBUTE16
,      ATTRIBUTE17
,      ATTRIBUTE18
,      ATTRIBUTE19
,      ATTRIBUTE20
,      ATTRIBUTE21
,      ATTRIBUTE22
,      ATTRIBUTE23
,      ATTRIBUTE24
,      ATTRIBUTE25
,      ATTRIBUTE26
,      ATTRIBUTE27
,      ATTRIBUTE28
,      ATTRIBUTE29
,      ATTRIBUTE30
,      ATTRIBUTE_CATEGORY
,      PURCH_CATEGORY_ID
FROM GML.PO_BPOS_HDR;

Dependencies

[top of page]

GML.PO_BPOS_HDR does not reference any database object

GML.PO_BPOS_HDR is referenced by following:

SchemaAPPS
SynonymPO_BPOS_HDR