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

VIEW: APPS.PO_LINES_MERGE_V

Object Details
Object Name: PO_LINES_MERGE_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewPO.PO_LINES_MERGE_V
Subobject Name:
Status: VALID

***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

[View Source]

Columns
Name Datatype Length Mandatory Comments
OWNER_USER_ID NUMBER

The user_id of the user that created the draft changes
OWNER_ROLE VARCHAR2 (10)
The role of the user that created the draft changes. It could be BUYER, SUPPLIER or CATALOG_ADMIN
STATUS VARCHAR2 (15)
Status of the draft change request
DRAFT_ID NUMBER

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
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
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.)
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
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
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
PO_LINE_ID NUMBER

Document line unique identifier
LAST_UPDATE_DATE DATE

Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY NUMBER

Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
PO_HEADER_ID NUMBER

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

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.)
GLOBAL_ATTRIBUTE_CATEGORY VARCHAR2 (150)
Global Descriptive Flexfield Structure Defining Column
GLOBAL_ATTRIBUTE1 VARCHAR2 (150)
Global Descriptive Flexfield Segment
GLOBAL_ATTRIBUTE2 VARCHAR2 (150)
Global Descriptive Flexfield Segment
GLOBAL_ATTRIBUTE3 VARCHAR2 (150)
Global Descriptive Flexfield Segment
GLOBAL_ATTRIBUTE4 VARCHAR2 (150)
Global Descriptive Flexfield Segment
GLOBAL_ATTRIBUTE5 VARCHAR2 (150)
Global Descriptive Flexfield Segment
GLOBAL_ATTRIBUTE6 VARCHAR2 (150)
Global Descriptive Flexfield Segment
GLOBAL_ATTRIBUTE7 VARCHAR2 (150)
Global Descriptive Flexfield Segment
GLOBAL_ATTRIBUTE8 VARCHAR2 (150)
Global Descriptive Flexfield Segment
GLOBAL_ATTRIBUTE9 VARCHAR2 (150)
Global Descriptive Flexfield Segment
GLOBAL_ATTRIBUTE10 VARCHAR2 (150)
Global Descriptive Flexfield Segment
GLOBAL_ATTRIBUTE11 VARCHAR2 (150)
Global Descriptive Flexfield Segment
GLOBAL_ATTRIBUTE12 VARCHAR2 (150)
Global Descriptive Flexfield Segment
GLOBAL_ATTRIBUTE13 VARCHAR2 (150)
Global Descriptive Flexfield Segment
GLOBAL_ATTRIBUTE14 VARCHAR2 (150)
Global Descriptive Flexfield Segment
GLOBAL_ATTRIBUTE15 VARCHAR2 (150)
Global Descriptive Flexfield Segment
GLOBAL_ATTRIBUTE16 VARCHAR2 (150)
Global Descriptive Flexfield Segment
GLOBAL_ATTRIBUTE17 VARCHAR2 (150)
Global Descriptive Flexfield Segment
GLOBAL_ATTRIBUTE18 VARCHAR2 (150)
Global Descriptive Flexfield Segment
GLOBAL_ATTRIBUTE19 VARCHAR2 (150)
Global Descriptive Flexfield Segment
GLOBAL_ATTRIBUTE20 VARCHAR2 (150)
Global Descriptive Flexfield Segment
LINE_REFERENCE_NUM VARCHAR2 (25)
Audit Trail Reference (needed by 832)
PROJECT_ID NUMBER

Project Accounting project unique identifier
TASK_ID NUMBER

Project Accounting task unique identifier
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.
TAX_NAME VARCHAR2 (30)
Tax code applying to the line. (References AP_TAX_CODES_ALL.name.)
SECONDARY_UNIT_OF_MEASURE VARCHAR2 (25)
OPM: Secondary unit of measure for the quantity ordered
SECONDARY_QUANTITY NUMBER

OPM: Secondary Quantity ordered on the line
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 that links to a specific configuration of an item. Generated by a configuration engine maintained by suppliers.
CONTRACT_ID NUMBER

Contract PA reference of a line. Apply to Standard PO only. Foreign to po_header_id in PO_HEADERS_ALL
JOB_ID NUMBER

HR job identifier for temp labor lines
AMOUNT NUMBER

Amount for service lines
START_DATE DATE

assignment start date for the contingent worker
CONTRACTOR_FIRST_NAME VARCHAR2 (240)
Contingent worker first name
CONTRACTOR_LAST_NAME VARCHAR2 (240)
Contingent worker last name
ORDER_TYPE_LOOKUP_CODE VARCHAR2 (25)
Value basis of the line type
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 only (i.e. PURCHASE_BASIS='TEMP LABOR'): Indicates whether an Amount Billed Approaching Budget reminder notification has been sent for this line.
SVC_COMPLETION_NOTIF_SENT VARCHAR2 (1)
Temp Labor lines only (i.e. PURCHASE_BASIS='TEMP LABOR'): Indicates whether a Contractor Assignment Nearing Completion reminder notification has been sent for this line.
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.)
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.
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
PROGRESS_PAYMENT_RATE NUMBER

Percentage applied to the completed work on a financing Pay Item to determine the amount eligible for payment
RECOUPMENT_RATE NUMBER

Maximum percentage of the invoice amount against which previous prepayments can be applied
SUPPLIER_PART_AUXID VARCHAR2 (255)
Supplier Part Aux ID
IP_CATEGORY_ID NUMBER

iP Category ID
TAX_ATTRIBUTE_UPDATE_CODE VARCHAR2 (15)
Keeps track of create/update actions on this entity
CATALOG_NAME VARCHAR2 (255)
This is to support the replacement of catalogs for CIF format
GROUP_LINE_ID NUMBER

LINE_NUM_DISPLAY VARCHAR2 (240)
CLM_INFO_FLAG VARCHAR2 (1)
CLM_OPTION_INDICATOR VARCHAR2 (1)
CLM_BASE_LINE_NUM NUMBER

CLM_OPTION_NUM NUMBER

CLM_OPTION_FROM_DATE DATE

CLM_OPTION_TO_DATE DATE

CLM_FUNDED_FLAG VARCHAR2 (1)
CONTRACT_TYPE VARCHAR2 (240)
COST_CONSTRAINT VARCHAR2 (240)
CLM_IDC_TYPE VARCHAR2 (240)
USER_DOCUMENT_STATUS VARCHAR2 (30)
CONTROL_ACTION VARCHAR2 (30)
CHANGE_STATUS VARCHAR2 (30)
UDA_TEMPLATE_ID NUMBER

CLM_MIN_TOTAL_AMOUNT NUMBER

CLM_MAX_TOTAL_AMOUNT NUMBER

CLM_MIN_TOTAL_QUANTITY NUMBER

CLM_MAX_TOTAL_QUANTITY NUMBER

CLM_MIN_ORDER_AMOUNT NUMBER

CLM_MAX_ORDER_AMOUNT NUMBER

CLM_MIN_ORDER_QUANTITY NUMBER

CLM_MAX_ORDER_QUANTITY NUMBER

CLM_TOTAL_AMOUNT_ORDERED NUMBER

CLM_TOTAL_QUANTITY_ORDERED NUMBER

CLM_FSC_PSC VARCHAR2 (200)
CLM_MDAPS_MAIS VARCHAR2 (200)
CLM_NAICS VARCHAR2 (200)
CLM_ORDER_START_DATE DATE

CLM_ORDER_END_DATE DATE

CLM_EXERCISED_FLAG VARCHAR2 (1)
CLM_EXERCISED_DATE DATE

OLD_QUANTITY NUMBER

CLM_EXHIBIT_NAME VARCHAR2 (10)
OLD_UOM_LOOKUP_CODE VARCHAR2 (25)
CLM_UNDEF_ACTION_CODE VARCHAR2 (10)
OLD_AMOUNT NUMBER

DRAFT_LINE_STATUS VARCHAR2 (25)
PAR Line Status
COMMENTS VARCHAR2 (2000)
Comments from Requestor to Buyer for PAR Line changes
MOD_DRAFT_ID NUMBER

For a PAR Line, stores the MOD draft id.
CLM_DELIVERY_EVENT_CODE VARCHAR2 (30)
CLM_PAYMENT_INSTR_CODE VARCHAR2 (30)
CLM_UNDEF_FLAG VARCHAR2 (1)
CLM_APPROVED_UNDEF_AMOUNT NUMBER

CLM_UDA_PRICING_TOTAL NUMBER

OLD_UNIT_PRICE NUMBER

CLM_POP_EXCEPTION_REASON VARCHAR2 (4000)
MOD_LINE_ID NUMBER

For PAR Line stores mod line id on which PAR line is placed
Query Text

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


SELECT OWNER_USER_ID
,      OWNER_ROLE
,      STATUS
,      DRAFT_ID
,      CHANGE_ACCEPTED_FLAG
,      DELETE_FLAG
,      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
,      HAZARD_CLASS_ID
,      NOTE_TO_VENDOR
,      FROM_HEADER_ID
,      FROM_LINE_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
,      TYPE_1099
,      CAPITAL_EXPENSE_FLAG
,      NEGOTIATED_BY_PREPARER_FLAG
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      QC_GRADE
,      BASE_UOM
,      BASE_QTY
,      SECONDARY_UOM
,      SECONDARY_QTY
,      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
,      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
,      TAX_NAME
,      SECONDARY_UNIT_OF_MEASURE
,      SECONDARY_QUANTITY
,      PREFERRED_GRADE
,      AUCTION_HEADER_ID
,      AUCTION_DISPLAY_NUMBER
,      AUCTION_LINE_NUMBER
,      BID_NUMBER
,      BID_LINE_NUMBER
,      RETROACTIVE_DATE
,      SUPPLIER_REF_NUMBER
,      CONTRACT_ID
,      JOB_ID
,      AMOUNT
,      START_DATE
,      CONTRACTOR_FIRST_NAME
,      CONTRACTOR_LAST_NAME
,      ORDER_TYPE_LOOKUP_CODE
,      PURCHASE_BASIS
,      MATCHING_BASIS
,      SVC_AMOUNT_NOTIF_SENT
,      SVC_COMPLETION_NOTIF_SENT
,      FROM_LINE_LOCATION_ID
,      BASE_UNIT_PRICE
,      MANUAL_PRICE_CHANGE_FLAG
,      RETAINAGE_RATE
,      MAX_RETAINAGE_AMOUNT
,      PROGRESS_PAYMENT_RATE
,      RECOUPMENT_RATE
,      SUPPLIER_PART_AUXID
,      IP_CATEGORY_ID
,      TAX_ATTRIBUTE_UPDATE_CODE
,      CATALOG_NAME
,      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
,      CLM_EXERCISED_FLAG
,      CLM_EXERCISED_DATE
,      OLD_QUANTITY
,      CLM_EXHIBIT_NAME
,      OLD_UOM_LOOKUP_CODE
,      CLM_UNDEF_ACTION_CODE
,      OLD_AMOUNT
,      DRAFT_LINE_STATUS
,      COMMENTS
,      MOD_DRAFT_ID
,      CLM_DELIVERY_EVENT_CODE
,      CLM_PAYMENT_INSTR_CODE
,      CLM_UNDEF_FLAG
,      CLM_APPROVED_UNDEF_AMOUNT
,      CLM_UDA_PRICING_TOTAL
,      OLD_UNIT_PRICE
,      CLM_POP_EXCEPTION_REASON
,      MOD_LINE_ID
FROM APPS.PO_LINES_MERGE_V;

Dependencies

[top of page]

APPS.PO_LINES_MERGE_V references the following:

SchemaAPPS
SynonymPO_DRAFTS
SynonymPO_LINES_ALL
SynonymPO_LINES_DRAFT_ALL
APPS.PO_LINES_MERGE_V is referenced by following:

SchemaAPPS
Package BodyOKC_REP_UDA_FUNCTIONS - show dependent code
Package BodyPO_ACCOUNT_HELPER - show dependent code
Package BodyPO_AME_SETUP_PVT - show dependent code
Package BodyPO_AUTOCREATE_GROUPING_PVT - show dependent code
Package BodyPO_AUTOCREATE_MAINPROC_PVT - show dependent code
Package BodyPO_AUTOCREATE_POSTPROC_PVT - show dependent code
Package BodyPO_AUTO_LINE_PROCESS_PVT - show dependent code
Package BodyPO_CLM_CLO_UTIL - show dependent code
Package BodyPO_CLM_COLS_SUB_CHECK - show dependent code
Package BodyPO_CORE_S - show dependent code
Package BodyPO_DOCUMENT_ACTION_UTIL - show dependent code
Package BodyPO_DOCUMENT_CHECKS_PVT - show dependent code
Package BodyPO_DOCUMENT_CONTROL_PVT - show dependent code
Package BodyPO_DOCUMENT_FUNDS_PVT - show dependent code
Package BodyPO_DOCUMENT_TOTALS_PVT - show dependent code
Package BodyPO_DRAFTS_PVT - show dependent code
Package BodyPO_EDA_DATATEMPLATE_PKG - show dependent code
Package BodyPO_EXHIBITS_PVT - show dependent code
Package BodyPO_GA_PVT - show dependent code
Package BodyPO_ITEMS_SV - show dependent code
Package BodyPO_LINES_DRAFT_PKG - show dependent code
Package BodyPO_LINES_DRAFT_PVT - show dependent code
Package BodyPO_LINK_REQ_DIST_PVT - show dependent code
Package BodyPO_MOD_CONTROL_PVT - show dependent code
Package BodyPO_PDOI_PREPROC_PVT - show dependent code
Package BodyPO_UDA_DEFAULTING_PKG - show dependent code
Package BodyPO_VALIDATION_HELPER - show dependent code
Package BodyPO_VAL_LINES - show dependent code
Package BodyPO_VERIFY_VENDOR_ELIGIBILITY - show dependent code