[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | PO_LINES_DRAFT_ALL |
|---|---|
| Object Type: | TABLE |
| Owner: | PO |
| FND Design Data: |  PO.PO_LINES_DRAFT_ALL
|
| Subobject Name: | |
| Status: | VALID |
PO_LINES_DRAFT_ALL stores draft changes to PO lines that have not been accepted by buyer. A record in this table contains the proposed values for the corresponding record in the transaction table PO_LINES_ALL. When the draft changes are accepted, the record is moved to PO_LINES_ALL. Changes from buyer are automatically accepted.
PO_LINES_DRAFT_ALL contains all columns from PO_LINES_ALL, as well as the following additional columns:
DRAFT_ID: primary key of the table; foreign key to PO_DRAFTS;
CHANGE_ACCEPTED_FLAG: acceptance status of the draft record;
DELETE_FLAG: flag indicating whether the corresponding record in transaction table should be deleted when the draft change is accepted.
| Tablespace: |  APPS_TS_TX_DATA |
|---|---|
| PCT Free: | 10 |
| PCT Used: |
| Index | Type | Uniqueness | Tablespace | Column |
|---|---|---|---|---|
| PO_LINES_DRAFT_U1 | NORMAL | UNIQUE |
APPS_TS_TX_IDX
|
 PO_LINE_ID
DRAFT_ID
|
| PO_LINES_DRAFT_N0 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
DRAFT_ID
|
| PO_LINES_DRAFT_N1 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
ITEM_ID
|
| PO_LINES_DRAFT_N10 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
LAST_UPDATE_DATE
|
| PO_LINES_DRAFT_N11 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
CONTRACT_ID
|
| PO_LINES_DRAFT_N12 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
JOB_ID
|
| PO_LINES_DRAFT_N13 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
FROM_HEADER_ID
|
| PO_LINES_DRAFT_N14 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
PO_HEADER_ID
LINE_NUM
DRAFT_ID
|
| PO_LINES_DRAFT_N15 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
MOD_DRAFT_ID
|
| PO_LINES_DRAFT_N2 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
CREATION_DATE
|
| PO_LINES_DRAFT_N3 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
CATEGORY_ID
|
| PO_LINES_DRAFT_N4 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
FROM_LINE_ID
|
| PO_LINES_DRAFT_N5 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
ITEM_DESCRIPTION
|
| PO_LINES_DRAFT_N6 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
VENDOR_PRODUCT_NUM
|
| PO_LINES_DRAFT_N7 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
CONTRACT_NUM
|
| PO_LINES_DRAFT_N8 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
CLOSED_BY
|
| PO_LINES_DRAFT_N9 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
CANCELLED_BY
|
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| PO_LINE_ID | NUMBER | Yes | Unique identifier for PO line | |
| LAST_UPDATE_DATE | DATE | Yes | Standard Who column - date when a user last updated this row. | |
| LAST_UPDATED_BY | NUMBER | Yes | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). | |
| PO_HEADER_ID | NUMBER | Yes | Document header unique identifier. (References PO_HEADERS_ALL.po_header_id.) | |
| LINE_TYPE_ID | NUMBER | Line type unique identifier (References PO_LINE_TYPES_B.line_type_id.) | ||
| LINE_NUM | NUMBER | Yes | Line number | |
| LAST_UPDATE_LOGIN | NUMBER | Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID). | ||
| CREATION_DATE | DATE | Standard who column - date when this row was created. | ||
| CREATED_BY | NUMBER | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). | ||
| ITEM_ID | NUMBER | Item unique identifier. (References MTL_SYSTEM_ITEMS_B.inventory_item_id.) | ||
| ITEM_REVISION | VARCHAR2 | (3) | Item revision. (References MTL_ITEM_REVISIONS_B.revision.) | |
| CATEGORY_ID | NUMBER | Item category unique identifier. (References MTL_CATEGORIES_B.category_id.) | ||
| ITEM_DESCRIPTION | VARCHAR2 | (240) | Item description. (Defaulted from MTL_SYSTEM_ITEMS_TL.description.) | |
| UNIT_MEAS_LOOKUP_CODE | VARCHAR2 | (25) | Unit of measure for the quantity ordered. (References MTL_UNITS_OF_MEASURE.unit_of_measure.) | |
| QUANTITY_COMMITTED | NUMBER | Blankets only: Quantity agreed for an agreement line | ||
| COMMITTED_AMOUNT | NUMBER | Blankets only: Amount agreed for an agreement line | ||
| ALLOW_PRICE_OVERRIDE_FLAG | VARCHAR2 | (1) | Blankets or planned POs only: Indicates whether you can change the price on release shipments | |
| NOT_TO_EXCEED_PRICE | NUMBER | Blankets or planned POs only: Price limit that you cannot exceed on a release shipment | ||
| LIST_PRICE_PER_UNIT | NUMBER | List price for the item on the line. (Defaulted from MTL_SYSTEM_ITEMS_B.list_price_per_unit.) | ||
| UNIT_PRICE | NUMBER | Unit price for the line. (Defaulted from MTL_SYSTEM_ITEMS_B.list_price_per_unit, converted to the document's currency.) | ||
| QUANTITY | NUMBER | Quantity ordered on the line | ||
| UN_NUMBER_ID | NUMBER | UN number unique identifier. (References PO_UN_NUMBERS_B.un_number_id.) | ||
| HAZARD_CLASS_ID | NUMBER | Hazard class unique identifier. (References PO_HAZARD_CLASSES_B.hazard_class_id.) | ||
| NOTE_TO_VENDOR | VARCHAR2 | (480) | Short note to supplier | |
| FROM_HEADER_ID | NUMBER | Unique identifier of the quotation (standard or planned POs only) or global agreement (standard POs only) referenced by this line. (References PO_HEADERS_ALL.po_header_id.) | ||
| FROM_LINE_ID | NUMBER | Unique identifier of the quotation line (standard or planned POs only) or global agreement line (standard POs only) referenced by this line. (References PO_LINES_ALL.po_line_id.) | ||
| FROM_LINE_LOCATION_ID | NUMBER | Unique identifier of the Price Break (standard POs only) referenced by this line. (References PO_LINE_LOCATIONS_ALL.line_location_id.) | ||
| MIN_ORDER_QUANTITY | NUMBER | Quotations only: Minimum order quantity for a quotation line | ||
| MAX_ORDER_QUANTITY | NUMBER | Quotations only: Maximum order quantity for a quotation line | ||
| QTY_RCV_TOLERANCE | NUMBER | Quantity received tolerance percentage | ||
| OVER_TOLERANCE_ERROR_FLAG | VARCHAR2 | (25) | Indicates whether or not you reject receipts exceeding the tolerance | |
| MARKET_PRICE | NUMBER | Market price for the item on the line. (Defaulted from MTL_SYSTEM_ITEMS_B.market_price.) | ||
| UNORDERED_FLAG | VARCHAR2 | (1) | Indicates whether or not the line was created from unordered receipts | |
| CLOSED_FLAG | VARCHAR2 | (1) | Indicates whether the line is closed or not | |
| USER_HOLD_FLAG | VARCHAR2 | (1) | Indicates whether the line is on hold or not (Unused since release version 5.0) | |
| CANCEL_FLAG | VARCHAR2 | (1) | Indicates whether the line is cancelled or not | |
| CANCELLED_BY | NUMBER | (9) | Unique identifier of the employee who cancelled the line. (References HR_EMPLOYEES.employee_id.) | |
| CANCEL_DATE | DATE | Cancellation date | ||
| CANCEL_REASON | VARCHAR2 | (240) | Cancellation reason provided by employee | |
| FIRM_STATUS_LOOKUP_CODE | VARCHAR2 | (30) | Firming status of the line (Unused since release version 7.0) | |
| FIRM_DATE | DATE | Date the line becomes firmed (Unused since release version 7.0) | ||
| VENDOR_PRODUCT_NUM | VARCHAR2 | (25) | Supplier item number | |
| CONTRACT_NUM | VARCHAR2 | (25) | Contract number referenced on the line. (Obsoleted in PO FPJ 11.5.10 - use CONTRACT_ID instead.) | |
| TAXABLE_FLAG | VARCHAR2 | (1) | Indicates whether the document line is taxable or not | |
| TAX_NAME | VARCHAR2 | (30) | Tax code applying to the line. (References AP_TAX_CODES_ALL.name.) | |
| TYPE_1099 | VARCHAR2 | (10) | 1099 type for the purchase order line | |
| CAPITAL_EXPENSE_FLAG | VARCHAR2 | (1) | Indicates whether the line is for a capital expense or not | |
| NEGOTIATED_BY_PREPARER_FLAG | VARCHAR2 | (1) | Indicates whether the buyer negotiated the price or not | |
| ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Descriptive flexfield structure definition column. | |
| ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| REFERENCE_NUM | VARCHAR2 | (25) | Reference number (Unused since release version 7.0) | |
| ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| MIN_RELEASE_AMOUNT | NUMBER | Blankets or planned POs only: Minimum amount that can be released against a planned or blanket agreement line. | ||
| PRICE_TYPE_LOOKUP_CODE | VARCHAR2 | (25) | Price type of the line. (References PO_LOOKUP_CODES.lookup_code with LOOKUP_TYPE='PRICE TYPE'.) | |
| CLOSED_CODE | VARCHAR2 | (25) | Describes closure status of the line | |
| PRICE_BREAK_LOOKUP_CODE | VARCHAR2 | (25) | Blankets only: Pricing scheme for the price breaks of this line (cumulative or non-cumulative). | |
| USSGL_TRANSACTION_CODE | VARCHAR2 | (30) | United States standard general ledger transaction code. (References GL_USSGL_TRANSACTION_CODES.USSGL_TRANSACTION_CODE.) | |
| GOVERNMENT_CONTEXT | VARCHAR2 | (30) | USSGL descriptive flexfield context column | |
| REQUEST_ID | NUMBER | Concurrent Program who column - concurrent request id of the program that last updated this row (foreign key to FND_CONCURRENT_REQUESTS.REQUEST_ID). | ||
| PROGRAM_APPLICATION_ID | NUMBER | Concurrent Program who column - application id of the program that last updated this row (foreign key to FND_APPLICATION.APPLICATION_ID). | ||
| PROGRAM_ID | NUMBER | Concurrent Program who column - program id of the program that last updated this row (foreign key to FND_CONCURRENT_PROGRAM.CONCURRENT_PROGRAM_ID). | ||
| PROGRAM_UPDATE_DATE | DATE | Concurrent Program who column - date when a program last updated this row). | ||
| CLOSED_DATE | DATE | Date the line is closed | ||
| CLOSED_REASON | VARCHAR2 | (240) | Describes why the line is closed | |
| CLOSED_BY | NUMBER | (9) | Unique identifier of the employee who closed the line. (References HR_EMPLOYEES.employee_id.) | |
| TRANSACTION_REASON_CODE | VARCHAR2 | (25) | Transaction reason. (References PO_LOOKUP_CODES.lookup_code with LOOKUP_TYPE='TRANSACTION REASON'.) | |
| ORG_ID | NUMBER | Organization identifier | ||
| QC_GRADE | VARCHAR2 | (25) | OPM: Stores the quality control grade wanted on the purchase order line | |
| BASE_UOM | VARCHAR2 | (25) | OPM: Stores the base unit of measure (UOM) for the item ordered | |
| BASE_QTY | NUMBER | OPM: Ordered quantity converted from transaction UOM to base UOM | ||
| SECONDARY_UOM | VARCHAR2 | (25) | OPM: Stores the dual unit of measure for the item ordered | |
| SECONDARY_QTY | NUMBER | OPM: Converted quantity from BASE UOM to DUAL UOM for the item ordered | ||
| GLOBAL_ATTRIBUTE_CATEGORY | VARCHAR2 | (150) | Reserved for country-specific functionality | |
| GLOBAL_ATTRIBUTE1 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
| GLOBAL_ATTRIBUTE2 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
| GLOBAL_ATTRIBUTE3 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
| GLOBAL_ATTRIBUTE4 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
| GLOBAL_ATTRIBUTE5 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
| GLOBAL_ATTRIBUTE6 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
| GLOBAL_ATTRIBUTE7 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
| GLOBAL_ATTRIBUTE8 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
| GLOBAL_ATTRIBUTE9 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
| GLOBAL_ATTRIBUTE10 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
| GLOBAL_ATTRIBUTE11 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
| GLOBAL_ATTRIBUTE12 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
| GLOBAL_ATTRIBUTE13 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
| GLOBAL_ATTRIBUTE14 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
| GLOBAL_ATTRIBUTE15 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
| GLOBAL_ATTRIBUTE16 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
| GLOBAL_ATTRIBUTE17 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
| GLOBAL_ATTRIBUTE18 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
| GLOBAL_ATTRIBUTE19 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
| GLOBAL_ATTRIBUTE20 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
| LINE_REFERENCE_NUM | VARCHAR2 | (25) | Audit Trail Reference (needed for 832 EDI transaction) | |
| PROJECT_ID | NUMBER | Project accounting project unique identifier. (References PA_PROJECTS_ALL.project_id or PJM_SEIBAN_NUMBERS.project_id.) | ||
| TASK_ID | NUMBER | Project accounting task unique identifier. (References PA_TASKS.task_id.) | ||
| EXPIRATION_DATE | DATE | Blanket, quotation, or RFQ only: Date after which the item on this catalog line can no longer be ordered | ||
| TAX_CODE_ID | NUMBER | Unique identifier for the tax code. (References AP_TAX_CODES.tax_id.) | ||
| OKE_CONTRACT_HEADER_ID | NUMBER | Contract identifier from Oracle Contracts. (References OKC_K_HEADERS_B.id.) | ||
| OKE_CONTRACT_VERSION_ID | NUMBER | Version identifier for contract. | ||
| SECONDARY_QUANTITY | NUMBER | OPM: Secondary Quantity ordered on the line | ||
| SECONDARY_UNIT_OF_MEASURE | VARCHAR2 | (25) | OPM: Secondary unit of measure for the quantity ordered | |
| PREFERRED_GRADE | VARCHAR2 | (150) | Preferred quality grade for the item ordered | |
| AUCTION_HEADER_ID | NUMBER | Reference to the negotiation id in sourcing. (References PON_AUCTION_HEADERS_ALL.auction_header_id.) | ||
| AUCTION_DISPLAY_NUMBER | VARCHAR2 | (40) | Reference to the negotiation number in sourcing | |
| AUCTION_LINE_NUMBER | NUMBER | Reference to the negotiation line number in Sourcing | ||
| BID_NUMBER | NUMBER | Reference to the bid number in sourcing | ||
| BID_LINE_NUMBER | NUMBER | Reference to the Bid line in sourcing | ||
| RETROACTIVE_DATE | DATE | Column used to store the timestamp of a retroactive price change | ||
| SUPPLIER_REF_NUMBER | VARCHAR2 | (150) | Tracking code for a specific configuration of an item. Generated by a configuration engine maintained by suppliers. | |
| CONTRACT_ID | NUMBER | Standard POs only: Contract PA reference of a line. (References PO_HEADERS_ALL.po_header_id.) | ||
| START_DATE | DATE | Assignment start Date for the contingent worker | ||
| AMOUNT | NUMBER | Budget Amout for temp labor standard PO lines | ||
| JOB_ID | NUMBER | Stores the HR Job identifier | ||
| CONTRACTOR_FIRST_NAME | VARCHAR2 | (240) | First name of the contingent worker | |
| CONTRACTOR_LAST_NAME | VARCHAR2 | (240) | Last name of the contingent worker | |
| ORDER_TYPE_LOOKUP_CODE | VARCHAR2 | (25) | Value basis of the line | |
| PURCHASE_BASIS | VARCHAR2 | (30) | Purchase basis of the line type | |
| MATCHING_BASIS | VARCHAR2 | (30) | Matching basis of the line type | |
| SVC_AMOUNT_NOTIF_SENT | VARCHAR2 | (1) | Temp Labor lines (i.e. PURCHASE_BASIS='TEMP LABOR') on Standard POs only: Y if an Amount Billed Approaching Budget reminder notification has been sent for this line, NULL otherwise. | |
| SVC_COMPLETION_NOTIF_SENT | VARCHAR2 | (1) | Temp Labor lines (i.e. PURCHASE_BASIS='TEMP LABOR') on Standard POs only: Y if a Contractor Assignment Nearing Completion reminder notification has been sent for this line, NULL otherwise. | |
| BASE_UNIT_PRICE | NUMBER | Base Unit Price | ||
| MANUAL_PRICE_CHANGE_FLAG | VARCHAR2 | (1) | Only for Standard PO lines referencing a Global Agreement, Contract, or Quotation: Y if the user has manually entered a price overriding the source document price, N or null otherwise. | |
| DRAFT_ID | NUMBER | Yes | The primary key of PO_DRAFTS table. It may be interpreted as a the version of the draft change | |
| CHANGE_ACCEPTED_FLAG | VARCHAR2 | (1) | Acceptance status of the draft record | |
| DELETE_FLAG | VARCHAR2 | (1) | Flag to indicate the corresponding record in PO_LINES_ALL table should be deleted | |
| RETAINAGE_RATE | NUMBER | Maximum percentage that can be withheld from an invoice as Retainage | ||
| MAX_RETAINAGE_AMOUNT | NUMBER | The maximum amount that can be withheld as Retainage against a contract line | ||
| CATALOG_NAME | VARCHAR2 | (255) | This is to support the replacement of catalogs for CIF format | |
| PROGRESS_PAYMENT_RATE | NUMBER | Percentage applied to the completed work on a financing Pay Item to determine the amount eligible for payment | ||
| SUPPLIER_PART_AUXID | VARCHAR2 | (255) | Supplier Part Auxiliary Id | |
| RECOUPMENT_RATE | NUMBER | Maximum percentage of the invoice amount against which previous prepayments can be applied | ||
| IP_CATEGORY_ID | NUMBER | IP Category Id for GBPA Lines (-2 stored for null values) | ||
| TAX_ATTRIBUTE_UPDATE_CODE | VARCHAR2 | (15) | Keeps track of create/update actions on this entity | |
| ORIGINAL_INTERFACE_LINE_ID | NUMBER | This column is only used by PDOI to indicate the interface line record that creates the draft line record. | ||
| CLM_EXERCISED_FLAG | VARCHAR2 | (1) | Indicate if option line is exercised or not. Has values Y / N / null | |
| CLM_EXERCISED_DATE | DATE | Indicates option line exercised date | ||
| GROUP_LINE_ID | NUMBER | PO Line Id of the Parent CLIN | ||
| LINE_NUM_DISPLAY | VARCHAR2 | (240) | CLIN / SLIN line number | |
| CLM_INFO_FLAG | VARCHAR2 | (1) | Inidcates if its an Informational line or not. Has values Y / N / null | |
| CLM_OPTION_INDICATOR | VARCHAR2 | (1) | Inidcates if its an Option line or not. Has values O / B / null | |
| CLM_BASE_LINE_NUM | NUMBER | PO Line Id of the Base CLIN / SLIN | ||
| CLM_OPTION_NUM | NUMBER | Option number | ||
| CLM_OPTION_FROM_DATE | DATE | Option line From Date | ||
| CLM_OPTION_TO_DATE | DATE | Option line To Date | ||
| CLM_FUNDED_FLAG | VARCHAR2 | (1) | Funded flag has values Y / N / null | |
| CONTRACT_TYPE | VARCHAR2 | (240) | contains contract type lookup code used for complex pricing | |
| COST_CONSTRAINT | VARCHAR2 | (240) | contains cost constraint lookup code used for complex pricing | |
| CLM_IDC_TYPE | VARCHAR2 | (240) | contains IDC type lookup code used for complex pricing | |
| USER_DOCUMENT_STATUS | VARCHAR2 | (30) | User extensible status for the modification | |
| CONTROL_ACTION | VARCHAR2 | (30) | The control action which is resulted in the modification | |
| CHANGE_STATUS | VARCHAR2 | (30) | This is to indicate the reason this record is created in the draft table. | |
| UDA_TEMPLATE_ID | NUMBER | Represents UDA template id | ||
| CLM_MIN_TOTAL_AMOUNT | NUMBER | Minimum Total Amount used for Ordering Constraints | ||
| CLM_MAX_TOTAL_AMOUNT | NUMBER | Maximum Total Amount used for Ordering Constraints | ||
| CLM_MIN_TOTAL_QUANTITY | NUMBER | Minimum Total Quantity used for Ordering Constraints | ||
| CLM_MAX_TOTAL_QUANTITY | NUMBER | Maximum Total Quantity used for Ordering Constraints | ||
| CLM_MIN_ORDER_AMOUNT | NUMBER | Minimum Order Amount used for Ordering Constraints | ||
| CLM_MAX_ORDER_AMOUNT | NUMBER | Maximum Order Amount used for Ordering Constraints | ||
| CLM_MIN_ORDER_QUANTITY | NUMBER | Minimum Order Quantity used for Ordering Constraints | ||
| CLM_MAX_ORDER_QUANTITY | NUMBER | Maximum Order Quantity used for Ordering Constraints | ||
| CLM_TOTAL_AMOUNT_ORDERED | NUMBER | Total Amount Ordered used for Ordering Constraints | ||
| CLM_TOTAL_QUANTITY_ORDERED | NUMBER | Total Quantity Ordered used for Ordering Constraints | ||
| CLM_FSC_PSC | VARCHAR2 | (200) | FSC PSC Code. Used for searching based on UDA data | |
| CLM_MDAPS_MAIS | VARCHAR2 | (200) | MDAPS MAIS Code. Used for searching based on UDA data | |
| CLM_NAICS | VARCHAR2 | (200) | NAICS code. Used for searching based on UDA data | |
| CLM_ORDER_START_DATE | DATE | Order Start Date used for Ordering Constraints | ||
| CLM_ORDER_END_DATE | DATE | Order End Date used for Ordering Constraints | ||
| OLD_QUANTITY | NUMBER | Original Quantity of the Base Document Line | ||
| OLD_AMOUNT | NUMBER | |||
| REVISION_NUM | NUMBER | |||
| CLM_APPROVED_UNDEF_AMOUNT | NUMBER | |||
| CLM_DELIVERY_EVENT_CODE | VARCHAR2 | (30) | ||
| CLM_EXHIBIT_NAME | VARCHAR2 | (10) | ||
| CLM_PAYMENT_INSTR_CODE | VARCHAR2 | (30) | ||
| CLM_POP_EXCEPTION_REASON | VARCHAR2 | (4000) | ||
| CLM_UDA_PRICING_TOTAL | NUMBER | |||
| CLM_UNDEF_ACTION_CODE | VARCHAR2 | (10) | ||
| CLM_UNDEF_FLAG | VARCHAR2 | (1) | ||
| COMMENTS | VARCHAR2 | (2000) | ||
| DRAFT_LINE_STATUS | VARCHAR2 | (25) | ||
| MOD_DRAFT_ID | NUMBER | |||
| OLD_UNIT_PRICE | NUMBER | |||
| OLD_UOM_LOOKUP_CODE | VARCHAR2 | (25) | ||
| MOD_LINE_ID | NUMBER | Line Id of Mod on which PAR Line is placed |
Cut, paste (and edit) the following text to query this object:
SELECT PO_LINE_ID
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, PO_HEADER_ID
, LINE_TYPE_ID
, LINE_NUM
, LAST_UPDATE_LOGIN
, CREATION_DATE
, CREATED_BY
, ITEM_ID
, ITEM_REVISION
, CATEGORY_ID
, ITEM_DESCRIPTION
, UNIT_MEAS_LOOKUP_CODE
, QUANTITY_COMMITTED
, COMMITTED_AMOUNT
, ALLOW_PRICE_OVERRIDE_FLAG
, NOT_TO_EXCEED_PRICE
, LIST_PRICE_PER_UNIT
, UNIT_PRICE
, QUANTITY
, UN_NUMBER_ID
, HAZARD_CLASS_ID
, NOTE_TO_VENDOR
, FROM_HEADER_ID
, FROM_LINE_ID
, FROM_LINE_LOCATION_ID
, MIN_ORDER_QUANTITY
, MAX_ORDER_QUANTITY
, QTY_RCV_TOLERANCE
, OVER_TOLERANCE_ERROR_FLAG
, MARKET_PRICE
, UNORDERED_FLAG
, CLOSED_FLAG
, USER_HOLD_FLAG
, CANCEL_FLAG
, CANCELLED_BY
, CANCEL_DATE
, CANCEL_REASON
, FIRM_STATUS_LOOKUP_CODE
, FIRM_DATE
, VENDOR_PRODUCT_NUM
, CONTRACT_NUM
, TAXABLE_FLAG
, TAX_NAME
, TYPE_1099
, CAPITAL_EXPENSE_FLAG
, NEGOTIATED_BY_PREPARER_FLAG
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, REFERENCE_NUM
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, MIN_RELEASE_AMOUNT
, PRICE_TYPE_LOOKUP_CODE
, CLOSED_CODE
, PRICE_BREAK_LOOKUP_CODE
, USSGL_TRANSACTION_CODE
, GOVERNMENT_CONTEXT
, REQUEST_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, CLOSED_DATE
, CLOSED_REASON
, CLOSED_BY
, TRANSACTION_REASON_CODE
, ORG_ID
, QC_GRADE
, BASE_UOM
, BASE_QTY
, SECONDARY_UOM
, SECONDARY_QTY
, GLOBAL_ATTRIBUTE_CATEGORY
, GLOBAL_ATTRIBUTE1
, GLOBAL_ATTRIBUTE2
, GLOBAL_ATTRIBUTE3
, GLOBAL_ATTRIBUTE4
, GLOBAL_ATTRIBUTE5
, GLOBAL_ATTRIBUTE6
, GLOBAL_ATTRIBUTE7
, GLOBAL_ATTRIBUTE8
, GLOBAL_ATTRIBUTE9
, GLOBAL_ATTRIBUTE10
, GLOBAL_ATTRIBUTE11
, GLOBAL_ATTRIBUTE12
, GLOBAL_ATTRIBUTE13
, GLOBAL_ATTRIBUTE14
, GLOBAL_ATTRIBUTE15
, GLOBAL_ATTRIBUTE16
, GLOBAL_ATTRIBUTE17
, GLOBAL_ATTRIBUTE18
, GLOBAL_ATTRIBUTE19
, GLOBAL_ATTRIBUTE20
, LINE_REFERENCE_NUM
, PROJECT_ID
, TASK_ID
, EXPIRATION_DATE
, TAX_CODE_ID
, OKE_CONTRACT_HEADER_ID
, OKE_CONTRACT_VERSION_ID
, SECONDARY_QUANTITY
, SECONDARY_UNIT_OF_MEASURE
, PREFERRED_GRADE
, AUCTION_HEADER_ID
, AUCTION_DISPLAY_NUMBER
, AUCTION_LINE_NUMBER
, BID_NUMBER
, BID_LINE_NUMBER
, RETROACTIVE_DATE
, SUPPLIER_REF_NUMBER
, CONTRACT_ID
, START_DATE
, AMOUNT
, JOB_ID
, CONTRACTOR_FIRST_NAME
, CONTRACTOR_LAST_NAME
, ORDER_TYPE_LOOKUP_CODE
, PURCHASE_BASIS
, MATCHING_BASIS
, SVC_AMOUNT_NOTIF_SENT
, SVC_COMPLETION_NOTIF_SENT
, BASE_UNIT_PRICE
, MANUAL_PRICE_CHANGE_FLAG
, DRAFT_ID
, CHANGE_ACCEPTED_FLAG
, DELETE_FLAG
, RETAINAGE_RATE
, MAX_RETAINAGE_AMOUNT
, CATALOG_NAME
, PROGRESS_PAYMENT_RATE
, SUPPLIER_PART_AUXID
, RECOUPMENT_RATE
, IP_CATEGORY_ID
, TAX_ATTRIBUTE_UPDATE_CODE
, ORIGINAL_INTERFACE_LINE_ID
, CLM_EXERCISED_FLAG
, CLM_EXERCISED_DATE
, GROUP_LINE_ID
, LINE_NUM_DISPLAY
, CLM_INFO_FLAG
, CLM_OPTION_INDICATOR
, CLM_BASE_LINE_NUM
, CLM_OPTION_NUM
, CLM_OPTION_FROM_DATE
, CLM_OPTION_TO_DATE
, CLM_FUNDED_FLAG
, CONTRACT_TYPE
, COST_CONSTRAINT
, CLM_IDC_TYPE
, USER_DOCUMENT_STATUS
, CONTROL_ACTION
, CHANGE_STATUS
, UDA_TEMPLATE_ID
, CLM_MIN_TOTAL_AMOUNT
, CLM_MAX_TOTAL_AMOUNT
, CLM_MIN_TOTAL_QUANTITY
, CLM_MAX_TOTAL_QUANTITY
, CLM_MIN_ORDER_AMOUNT
, CLM_MAX_ORDER_AMOUNT
, CLM_MIN_ORDER_QUANTITY
, CLM_MAX_ORDER_QUANTITY
, CLM_TOTAL_AMOUNT_ORDERED
, CLM_TOTAL_QUANTITY_ORDERED
, CLM_FSC_PSC
, CLM_MDAPS_MAIS
, CLM_NAICS
, CLM_ORDER_START_DATE
, CLM_ORDER_END_DATE
, OLD_QUANTITY
, OLD_AMOUNT
, REVISION_NUM
, CLM_APPROVED_UNDEF_AMOUNT
, CLM_DELIVERY_EVENT_CODE
, CLM_EXHIBIT_NAME
, CLM_PAYMENT_INSTR_CODE
, CLM_POP_EXCEPTION_REASON
, CLM_UDA_PRICING_TOTAL
, CLM_UNDEF_ACTION_CODE
, CLM_UNDEF_FLAG
, COMMENTS
, DRAFT_LINE_STATUS
, MOD_DRAFT_ID
, OLD_UNIT_PRICE
, OLD_UOM_LOOKUP_CODE
, MOD_LINE_ID
FROM PO.PO_LINES_DRAFT_ALL;
PO.PO_LINES_DRAFT_ALL does not reference any database object
PO.PO_LINES_DRAFT_ALL is referenced by following:
PO
PO_LINES_DRAFT_ALL#
|
|
|
|