FND Design Data [Home] [Help]

View: POFV_PO_LINES

Product: PO - Purchasing
Description:
Implementation/DBA Data: ViewAPPS.POFV_PO_LINES
View Text

SELECT PL.PO_LINE_ID
, PL.LINE_NUM
, PL.PO_HEADER_ID
, PH.SEGMENT1
, PL.ORG_ID
, OP.NAME
, '_LA:PH.TYPE_LOOKUP_CODE:PO_LOOKUP_CODES:DOCUMENT SUBTYPE:DISPLAYED_FIELD'
, LT.LINE_TYPE
, PL.ITEM_DESCRIPTION
, PL.QUANTITY
, PL.UNIT_PRICE
, PL.LIST_PRICE_PER_UNIT
, PL.MARKET_PRICE
, '_LA:PL.PRICE_TYPE_LOOKUP_CODE:PO_LOOKUP_CODES:PRICE TYPE:DISPLAYED_FIELD'
, '_LA:PL.PRICE_BREAK_LOOKUP_CODE:PO_LOOKUP_CODES:PRICE BREAK TYPE:DISPLAYED_FIELD'
, PL.COMMITTED_AMOUNT
, PL.QUANTITY_COMMITTED
, '_LA:PL.ALLOW_PRICE_OVERRIDE_FLAG:PO_LOOKUP_CODES:YES/NO:DISPLAYED_FIELD'
, PL.NOT_TO_EXCEED_PRICE
, PL.MIN_RELEASE_AMOUNT
, '_LA:PL.CANCEL_FLAG:PO_LOOKUP_CODES:YES/NO:DISPLAYED_FIELD'
, PL.CANCEL_DATE
, PL.CANCEL_REASON
, '_LA:NVL(PL.CLOSED_CODE
, ''OPEN''):PO_LOOKUP_CODES:DOCUMENT STATE:DISPLAYED_FIELD'
, PL.CLOSED_DATE
, PL.CLOSED_REASON
, '_LA:PL.NEGOTIATED_BY_PREPARER_FLAG:PO_LOOKUP_CODES:YES/NO:DISPLAYED_FIELD'
, '_LA:PL.CAPITAL_EXPENSE_FLAG:PO_LOOKUP_CODES:YES/NO:DISPLAYED_FIELD'
, PL.NOTE_TO_VENDOR
, PL.VENDOR_PRODUCT_NUM
, '_LA:PL.TAXABLE_FLAG:PO_LOOKUP_CODES:YES/NO:DISPLAYED_FIELD'
, PL.TYPE_1099
, PL.TRANSACTION_REASON_CODE
, PL.EXPIRATION_DATE
, PL.USSGL_TRANSACTION_CODE
, '_DF:PO:PO_LINES:PL'
, PL.ITEM_ID
, '_KF:INV:MSTK:SI'
, PL.ITEM_REVISION
, SI.ORGANIZATION_ID
, MP.ORGANIZATION_CODE
, PL.CATEGORY_ID
, '_KF:INV:MCAT:CT'
, PL.UNIT_MEAS_LOOKUP_CODE
, UM.UOM_CLASS
, UM.DESCRIPTION
, CI.SEGMENT1
, PL.HAZARD_CLASS_ID
, HC.HAZARD_CLASS
, PL.UN_NUMBER_ID
, UN.UN_NUMBER
, PL.FROM_HEADER_ID
, FH.SEGMENT1
, '_LA:PH.TYPE_LOOKUP_CODE:PO_LOOKUP_CODES:SOURCE DOCUMENT TYPE:DISPLAYED_FIELD'
, PL.FROM_LINE_ID
, FL.LINE_NUM
, PL.CANCELLED_BY
, CA.EMPLOYEE_NUMBER
, CA.FULL_NAME
, PL.CLOSED_BY
, CL.EMPLOYEE_NUMBER
, CL.FULL_NAME
, PL.TAX_CODE_ID
, TX.NAME
, PL.CREATION_DATE
, PL.CREATED_BY
, PL.LAST_UPDATE_DATE
, PL.LAST_UPDATED_BY
, PL.SECONDARY_QUANTITY
, PL.SECONDARY_UNIT_OF_MEASURE
, PL.PREFERRED_GRADE
, PL.AUCTION_DISPLAY_NUMBER
, PL.AUCTION_HEADER_ID
, PL.AUCTION_LINE_NUMBER
, PL.BID_NUMBER
, PL.BID_LINE_NUMBER
, PL.RETROACTIVE_DATE
, PL.OKE_CONTRACT_HEADER_ID
, PL.OKE_CONTRACT_VERSION_ID
, OKH.CONTRACT_NUMBER
, OKV.MAJOR_VERSION
, OKL.LINE_NUMBER
, PL.SUPPLIER_REF_NUMBER
, CI.PO_HEADER_ID
, CI.ORG_ID
, PL.SVC_AMOUNT_NOTIF_SENT
, PL.SVC_COMPLETION_NOTIF_SENT
, PL.BASE_UNIT_PRICE
, PL.JOB_ID
, PJVL.NAME
, PL.AMOUNT
, PL.PURCHASE_BASIS
, PL.MATCHING_BASIS
, PL.ORDER_TYPE_LOOKUP_CODE
, PL.MANUAL_PRICE_CHANGE_FLAG
FROM PO_LINES_ALL PL
, PO_HEADERS_ALL PH
, HR_ALL_ORGANIZATION_UNITS OP
, PO_HAZARD_CLASSES HC
, PO_UN_NUMBERS UN
, PER_PEOPLE_F CA
, PER_PEOPLE_F CL
, PO_HEADERS_ALL CI
, MTL_CATEGORIES CT
, MTL_ITEM_REVISIONS IR
, MTL_SYSTEM_ITEMS SI
, FINANCIALS_SYSTEM_PARAMS_ALL FP
, MTL_PARAMETERS MP
, PO_LINE_TYPES LT
, MTL_UNITS_OF_MEASURE UM
, PO_HEADERS_ALL FH
, PO_LINES_ALL FL
, AP_TAX_CODES_ALL TX
, OKC_K_HEADERS_B OKH
, OKC_K_VERS_NUMBERS_V OKV
, OKC_K_LINES_B OKL
, PER_JOBS_VL PJVL
WHERE PL.ORG_ID = FP.ORG_ID
AND FP.INVENTORY_ORGANIZATION_ID = MP.ORGANIZATION_ID
AND PL.PO_HEADER_ID = PH.PO_HEADER_ID
AND PL.ORG_ID = OP.ORGANIZATION_ID
AND PL.HAZARD_CLASS_ID = HC.HAZARD_CLASS_ID(+)
AND PL.UN_NUMBER_ID = UN.UN_NUMBER_ID(+)
AND PL.CANCELLED_BY = CA.PERSON_ID(+)
AND CA.EFFECTIVE_START_DATE(+) <= TRUNC(SYSDATE)
AND CA.EFFECTIVE_END_DATE(+) >= TRUNC(SYSDATE)
AND PL.CLOSED_BY = CL.PERSON_ID(+)
AND CL.EFFECTIVE_START_DATE(+) <= TRUNC(SYSDATE)
AND CL.EFFECTIVE_END_DATE(+) >= TRUNC(SYSDATE)
AND PL.CONTRACT_ID = CI.PO_HEADER_ID (+)
AND CI.TYPE_LOOKUP_CODE(+) = 'CONTRACT'
AND PL.CATEGORY_ID = CT.CATEGORY_ID(+)
AND PL.ITEM_REVISION = IR.REVISION(+)
AND PL.ITEM_ID = IR.INVENTORY_ITEM_ID(+)
AND NVL(IR.ORGANIZATION_ID
, FP.INVENTORY_ORGANIZATION_ID) = FP.INVENTORY_ORGANIZATION_ID
AND PL.ITEM_ID = SI.INVENTORY_ITEM_ID(+)
AND NVL(SI.ORGANIZATION_ID
, FP.INVENTORY_ORGANIZATION_ID) = FP.INVENTORY_ORGANIZATION_ID
AND PL.LINE_TYPE_ID = LT.LINE_TYPE_ID(+)
AND PL.UNIT_MEAS_LOOKUP_CODE = UM.UNIT_OF_MEASURE(+)
AND PL.FROM_HEADER_ID = FH.PO_HEADER_ID(+)
AND PL.FROM_LINE_ID = FL.PO_LINE_ID(+)
AND PL.TAX_CODE_ID = TX.TAX_ID(+)
AND PL.OKE_CONTRACT_HEADER_ID = OKH.ID(+)
AND OKH.ID = OKL.CHR_ID(+)
AND OKH.ID = OKV.CHR_ID(+)
AND PJVL.JOB_ID (+) = PL.JOB_ID
AND '_SEC:PL.ORG_ID' IS NOT NULL WITH READ ONLY

Columns

Name
PO_LINE_ID
LINE_NUMBER
PURCHASE_ORDER_ID
PO_DOCUMENT_NUMBER
OPERATING_UNIT_ID
OPERATING_UNIT_NAME
"_LA:DOCUMENT_TYPE"
LINE_TYPE
ITEM_DESCRIPTION
ORDERED_QUANTITY
UNIT_PRICE
LIST_PRICE
MARKET_PRICE
"_LA:PRICE_TYPE"
"_LA:PRICE_BREAK_TYPE"
AGREED_AMOUNT
AGREED_QUANTITY
"_LA:ALLOW_PRICE_OVERRIDE"
PRICE_LIMIT
MINIMUM_RELEASE_AMOUNT
"_LA:CANCEL_FLAG"
CANCEL_DATE
CANCEL_REASON
"_LA:CLOSURE_STATUS"
CLOSED_DATE
CLOSED_REASON
"_LA:NEGOTIATED_BY_BUYER_FLAG"
"_LA:CAPITAL_EXPENSE_FLAG"
SUPPLIER_NOTE
SUPPLIER_PRODUCT_NUMBER
"_LA:TAXABLE_FLAG"
TYPE_OF_1099
TRANSACTION_REASON
EXPIRATION_DATE
USSGL_TRANSACTION_CODE
"_DF"
ITEM_ID
"_KF:ITEM_NUMBER::_CO"
ITEM_REVISION
ITEM_ORGANIZATION_ID
ITEM_ORGANIZATION_CODE
CATEGORY_ID
"_KF:CATEGORY::_CO"
UNIT_OF_MEASURE
UOM_CLASS
UOM_DESCRIPTION
CONTRACT_NUMBER
HAZARD_CLASS_ID
HAZARD_CLASS
UN_NUMBER_ID
UN_NUMBER
SOURCE_DOCUMENT_ID
SOURCE_DOCUMENT_NUMBER
"_LA:SOURCE_DOCUMENT_TYPE"
SOURCE_DOCUMENT_LINE_ID
SOURCE_DOCUMENT_LINE_NUMBER
CANCELLED_BY
CANCELLED_BY_EMPLOYEE_NUMBER
CANCELLED_BY_EMPLOYEE_NAME
CLOSED_BY
CLOSED_BY_EMPLOYEE_NUMBER
CLOSED_BY_EMPLOYEE_NAME
TAX_CODE_ID
TAX_CODE_NAME
CREATED_DATE
CREATED_BY
LAST_UPDATED_DATE
LAST_UPDATED_BY
SECONDARY_QUANTITY
SECONDARY_UNIT_OF_MEASURE
PREFERRED_GRADE
AUCTION_DISPLAY_NUMBER
AUCTION_HEADER_ID
AUCTION_LINE_NUMBER
BID_NUMBER
BID_LINE_NUMBER
RETROACTIVE_DATE
OKE_CONTRACT_HEADER_ID
OKE_CONTRACT_VERSION_ID
OKE_CONTRACT_NUM
OKE_CONTRACT_VERSION_NUM
OKE_CONTRACT_LINE_NUM
SUPPLIER_REF_NUMBER
CONTRACT_ID
CONTRACT_OWNING_ORG_ID
SVC_AMOUNT_NOTIF_SENT
SVC_COMPLETION_NOTIF_SENT
BASE_UNIT_PRICE
JOB_ID
JOB_NAME
AMOUNT
PURCHASE_BASIS
MATCHING_BASIS
ORDER_TYPE_LOOKUP_CODE
MANUAL_PRICE_CHANGE_FLAG