[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | POA_DBI_POD_F |
|---|---|
| Object Type: | TABLE |
| Owner: | POA |
| Subobject Name: | |
| Status: | VALID |
PO Distribution base table for DBI - only update and insert are allowed.
| Tablespace: |  APPS_TS_SUMMARY |
|---|---|
| PCT Free: | 10 |
| PCT Used: |
| Index | Type | Uniqueness | Tablespace | Column |
|---|---|---|---|---|
| POA_DBI_POD_F_U1 | NORMAL | UNIQUE |
APPS_TS_SUMMARY
|
 PO_DISTRIBUTION_ID
|
| POA_DBI_POD_F_N1 | NORMAL | NONUNIQUE |
APPS_TS_SUMMARY
|
APPROVED_DATE
CATEGORY_ID
PO_ITEM_ID
|
| POA_DBI_POD_F_N2 | NORMAL | NONUNIQUE |
APPS_TS_SUMMARY
|
APPROVED_DATE
SUPPLIER_ID
SUPPLIER_SITE_ID
|
| POA_DBI_POD_F_N3 | NORMAL | NONUNIQUE |
APPS_TS_SUMMARY
|
APPROVED_DATE
BUYER_ID
CREATION_OPERATING_UNIT_ID
|
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| PO_DISTRIBUTION_ID | NUMBER | Yes | primary key | |
| PO_HEADER_ID | NUMBER | Yes | PO Header Id | |
| PO_LINE_ID | NUMBER | Yes | PO Line Id | |
| PO_RELEASE_ID | NUMBER | PO Release Id | ||
| CREATION_OPERATING_UNIT_ID | NUMBER | Operating Unit where the PO was created | ||
| SHIP_TO_ORG_ID | NUMBER | Ship-to Organization | ||
| APPROVED_DATE | DATE | Ealiest approval date for the PO Distribution | ||
| DISTRIBUTION_CREATION_DATE | DATE | Yes | Creation Date of the PO Distribution | |
| SUPPLIER_ID | NUMBER | Supplier ID | ||
| SUPPLIER_SITE_ID | NUMBER | Supplier Site Id | ||
| PO_ITEM_ID | NUMBER | Yes | Purchased Item ID | |
| CATEGORY_ID | NUMBER | Category on the PO Line | ||
| BUYER_ID | NUMBER | Yes | Buyer Id | |
| CODE_COMBINATION_ID | NUMBER | Code Combination Id | ||
| FUNC_CUR_CODE | VARCHAR2 | (25) | Functional Currency Code | |
| GLOBAL_CUR_CONV_RATE | NUMBER | Functional to Global conversion rate | ||
| BASE_UOM_CONV_RATE | NUMBER | Conversion rate to the base Unit of Measure of an item | ||
| PURCHASE_AMOUNT_B | NUMBER | purchase amount in functional currency | ||
| CONTRACT_AMOUNT_B | NUMBER | contract amount in functional currency | ||
| NON_CONTRACT_AMOUNT_B | NUMBER | non-contract purchases amount in functional currency | ||
| POT_CONTRACT_AMOUNT_B | NUMBER | Contract Leakage amount in functional currency | ||
| POT_SAVINGS_AMOUNT_B | NUMBER | Potential Savings amount in functional currency | ||
| UNIT_PRICE | NUMBER | Unit Price | ||
| QUANTITY | NUMBER | Quantity | ||
| CREATION_MODE | VARCHAR2 | (10) | Creation Mode | |
| ORDER_TYPE | VARCHAR2 | (25) | Order Type | |
| CATALOG_TYPE | VARCHAR2 | (30) | Catalog Type | |
| DESTINATION_TYPE_CODE | VARCHAR2 | (25) | Destination Type Code | |
| AMT_BILLED | NUMBER | Amount Billed | ||
| QTY_BILLED | NUMBER | Quantity Billed | ||
| QTY_CANCELLED | NUMBER | Quantity Cancelled | ||
| START_DATE_ACTIVE | DATE | Date when this row became active | ||
| LAST_UPDATE_LOGIN | NUMBER | standard WHO column | ||
| CREATION_DATE | DATE | Yes | standard WHO column | |
| LAST_UPDATED_BY | NUMBER | Yes | standard WHO column | |
| LAST_UPDATE_DATE | DATE | Yes | standard WHO column | |
| POTENTIAL_CONTRACT_ID | NUMBER | Potential Contract Id | ||
| SHIPMENT_TYPE | VARCHAR2 | (25) | Shipment Type | |
| APPS_SOURCE_CODE | VARCHAR2 | (25) | Apps Source Code - PO, POR | |
| FROM_DOCUMENT_TYPE | VARCHAR2 | (25) | From Document Type | |
| FROM_DOCUMENT_ID | NUMBER | From Document Id | ||
| CONSIGNED_CODE | NUMBER | Consigned Code - 0 for normal shipment, 1 for consigned shipment, 2 for consumption advice | ||
| BASE_UOM | VARCHAR2 | (25) | Base UOM | |
| TRANSACTION_UOM | VARCHAR2 | (25) | Transaction UOM | |
| REQUESTOR_ID | NUMBER | Requestor Id | ||
| FUNC_CUR_CONV_RATE | NUMBER | Conversion Rate from Transactional Currency to Functional (OU) currency | ||
| SGLOBAL_CUR_CONV_RATE | NUMBER | Conversion Rate from Functional to Secondary Global Currency | ||
| EXPECTED_DATE | DATE | Expected Date | ||
| DAYS_LATE_RECEIPT_ALLOWED | NUMBER | Days Late Receipt Allowed | ||
| DAYS_EARLY_RECEIPT_ALLOWED | NUMBER | Days Early Receipt Allowed | ||
| PRICE_OVERRIDE | NUMBER | PO Price | ||
| LINE_LOCATION_ID | NUMBER | PO Shipment Id | ||
| ITEM_ID | NUMBER | Item Id | ||
| MATCHING_BASIS | VARCHAR2 | (30) | Matching Basis | |
| RECEIVING_ROUTING_ID | NUMBER | Receiving Routing Id | ||
| COMPANY_ID | NUMBER | Company Id | ||
| COST_CENTER_ID | NUMBER | Cost Center Id | ||
| QTY_FINANCED | NUMBER | Quantity Financed | ||
| AMT_FINANCED | NUMBER | Amount Financed | ||
| QTY_RECOUPED | NUMBER | Quantity Recouped | ||
| AMT_RECOUPED | NUMBER | Amount Recouped | ||
| PAYMENT_TYPE | VARCHAR2 | (30) | Payment Type | |
| COMPLEX_WORK_FLAG | VARCHAR2 | (1) | Complex Work Flag indicating a Complex Work Procurement | |
| NON_ZERO_QUANTITY | NUMBER | Number of units having NON-zero PO Purchase Price | ||
| AUCTION_HEADER_ID | NUMBER | Auction Header Identifier | ||
| AUCTION_LINE_NUMBER | NUMBER | Auction Line Number | ||
| BID_NUMBER | NUMBER | Bid Number | ||
| BID_LINE_NUMBER | NUMBER | Bid Line Number | ||
| NEGOTIATION_CREATOR_ID | NUMBER | Negotiation Creator Identifier | ||
| DOCTYPE_ID | NUMBER | Document Type Identifier | ||
| NEG_CURRENT_PRICE | NUMBER | Current Price | ||
| NEG_FUNC_CUR_CODE | VARCHAR2 | (25) | Functional Currency Code | |
| NEG_FUNC_CUR_CONV_RATE | NUMBER | Functional Currency Conversion Rate | ||
| NEG_GLOBAL_CUR_CONV_RATE | NUMBER | Global Currency Conversion Rate | ||
| NEG_SGLOBAL_CUR_CONV_RATE | NUMBER | Secondary Global Currency Conversion Rate | ||
| NEG_TRANSACTION_UOM | VARCHAR2 | (25) | Transaction UOM | |
| NEG_BASE_UOM | VARCHAR2 | (25) | Base UOM | |
| NEG_BASE_UOM_CONV_RATE | NUMBER | Conversion Rate from Transaction UOM to Base UOM | ||
| NEGOTIATED_BY_PREPARER_FLAG | VARCHAR2 | (1) | Negotiated by Preparer Flag |
Cut, paste (and edit) the following text to query this object:
SELECT PO_DISTRIBUTION_ID
, PO_HEADER_ID
, PO_LINE_ID
, PO_RELEASE_ID
, CREATION_OPERATING_UNIT_ID
, SHIP_TO_ORG_ID
, APPROVED_DATE
, DISTRIBUTION_CREATION_DATE
, SUPPLIER_ID
, SUPPLIER_SITE_ID
, PO_ITEM_ID
, CATEGORY_ID
, BUYER_ID
, CODE_COMBINATION_ID
, FUNC_CUR_CODE
, GLOBAL_CUR_CONV_RATE
, BASE_UOM_CONV_RATE
, PURCHASE_AMOUNT_B
, CONTRACT_AMOUNT_B
, NON_CONTRACT_AMOUNT_B
, POT_CONTRACT_AMOUNT_B
, POT_SAVINGS_AMOUNT_B
, UNIT_PRICE
, QUANTITY
, CREATION_MODE
, ORDER_TYPE
, CATALOG_TYPE
, DESTINATION_TYPE_CODE
, AMT_BILLED
, QTY_BILLED
, QTY_CANCELLED
, START_DATE_ACTIVE
, LAST_UPDATE_LOGIN
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, POTENTIAL_CONTRACT_ID
, SHIPMENT_TYPE
, APPS_SOURCE_CODE
, FROM_DOCUMENT_TYPE
, FROM_DOCUMENT_ID
, CONSIGNED_CODE
, BASE_UOM
, TRANSACTION_UOM
, REQUESTOR_ID
, FUNC_CUR_CONV_RATE
, SGLOBAL_CUR_CONV_RATE
, EXPECTED_DATE
, DAYS_LATE_RECEIPT_ALLOWED
, DAYS_EARLY_RECEIPT_ALLOWED
, PRICE_OVERRIDE
, LINE_LOCATION_ID
, ITEM_ID
, MATCHING_BASIS
, RECEIVING_ROUTING_ID
, COMPANY_ID
, COST_CENTER_ID
, QTY_FINANCED
, AMT_FINANCED
, QTY_RECOUPED
, AMT_RECOUPED
, PAYMENT_TYPE
, COMPLEX_WORK_FLAG
, NON_ZERO_QUANTITY
, AUCTION_HEADER_ID
, AUCTION_LINE_NUMBER
, BID_NUMBER
, BID_LINE_NUMBER
, NEGOTIATION_CREATOR_ID
, DOCTYPE_ID
, NEG_CURRENT_PRICE
, NEG_FUNC_CUR_CODE
, NEG_FUNC_CUR_CONV_RATE
, NEG_GLOBAL_CUR_CONV_RATE
, NEG_SGLOBAL_CUR_CONV_RATE
, NEG_TRANSACTION_UOM
, NEG_BASE_UOM
, NEG_BASE_UOM_CONV_RATE
, NEGOTIATED_BY_PREPARER_FLAG
FROM POA.POA_DBI_POD_F;
POA.POA_DBI_POD_F does not reference any database object
POA.POA_DBI_POD_F is referenced by following:
APPS
POA_API_BS_J_MV
POA_DBI_PLL_MV
POA_DBI_POD_F
POA_POD_BS_J_MV
POA_PQC_BS_J_MV
|
|
|
|