View: POFV_REQUISITION_LINES

Product:	PO - Purchasing
Description:	- Retrofitted
Implementation/DBA Data:	APPS.POFV_REQUISITION_LINES

View Text

SELECT RL.REQUISITION_LINE_ID
, RL.LINE_NUM
, RL.REQUISITION_HEADER_ID
, RH.SEGMENT1
, RL.ORG_ID
, OP.NAME
, '_LA:RH.TYPE_LOOKUP_CODE:PO_LOOKUP_CODES:REQUISITION TYPE:DISPLAYED_FIELD'
, LT.LINE_TYPE
, RL.ITEM_DESCRIPTION
, RL.UNIT_PRICE
, RL.QUANTITY
, RL.QUANTITY_DELIVERED
, RL.QUANTITY_RECEIVED
, RL.QUANTITY_CANCELLED
, RL.NEED_BY_DATE
, '_LA:RL.DESTINATION_TYPE_CODE:PO_LOOKUP_CODES:DESTINATION TYPE:DISPLAYED_FIELD'
, '_LA:RL.CANCEL_FLAG:PO_LOOKUP_CODES:YES/NO:DISPLAYED_FIELD'
, RL.CANCEL_DATE
, RL.CANCEL_REASON
, '_LA:RL.CLOSED_CODE:PO_LOOKUP_CODES:DOCUMENT STATE:DISPLAYED_FIELD'
, RL.CLOSED_DATE
, RL.CLOSED_REASON
, RL.RATE
, RL.RATE_DATE
, RL.CURRENCY_UNIT_PRICE
, '_LA:RL.ENCUMBERED_FLAG:PO_LOOKUP_CODES:YES/NO:DISPLAYED_FIELD'
, RL.JUSTIFICATION
, '_LA:RL.MODIFIED_BY_AGENT_FLAG:PO_LOOKUP_CODES:YES/NO:DISPLAYED_FIELD'
, '_LA:RL.ON_RFQ_FLAG:PO_LOOKUP_CODES:YES/NO:DISPLAYED_FIELD'
, RL.NOTE_TO_AGENT
, RL.NOTE_TO_RECEIVER
, RL.REFERENCE_NUM
, '_LA:RL.RFQ_REQUIRED_FLAG:PO_LOOKUP_CODES:YES/NO:DISPLAYED_FIELD'
, '_LA:RL.DOCUMENT_TYPE_CODE:PO_LOOKUP_CODES:SOURCE DOCUMENT TYPE:DISPLAYED_FIELD'
, '_LA:RL.SOURCE_TYPE_CODE:PO_LOOKUP_CODES:REQUISITION SOURCE TYPE:DISPLAYED_FIELD'
, RL.SUGGESTED_VENDOR_NAME
, RL.SUGGESTED_VENDOR_LOCATION
, RL.SUGGESTED_VENDOR_CONTACT
, RL.SUGGESTED_VENDOR_PHONE
, RL.SUGGESTED_VENDOR_CONTACT_FAX
, RL.SUGGESTED_VENDOR_CONTACT_EMAIL
, RL.SUGGESTED_VENDOR_PRODUCT_CODE
, RL.SOURCE_SUBINVENTORY
, RL.TRANSACTION_REASON_CODE
, '_LA:RL.URGENT_FLAG:PO_LOOKUP_CODES:YES/NO:DISPLAYED_FIELD'
, RL.USSGL_TRANSACTION_CODE
, '_DF:PO:PO_REQUISITION_LINES:RL'
, RL.ITEM_ID
, '_KF:INV:MSTK:SI'
, RL.ITEM_REVISION
, SI.ORGANIZATION_ID
, MP.ORGANIZATION_CODE
, RL.CATEGORY_ID
, '_KF:INV:MCAT:CT'
, RL.UNIT_MEAS_LOOKUP_CODE
, UM.UOM_CLASS
, UM.DESCRIPTION
, RL.DESTINATION_ORGANIZATION_ID
, DC.ORGANIZATION_CODE
, DO.NAME
, RL.DESTINATION_SUBINVENTORY
, RL.HAZARD_CLASS_ID
, HC.HAZARD_CLASS
, RL.UN_NUMBER_ID
, UN.UN_NUMBER
, RL.CURRENCY_CODE
, CU.NAME
, RL.RATE_TYPE
, RT.USER_CONVERSION_TYPE
, RT.DESCRIPTION
, RL.DELIVER_TO_LOCATION_ID
, DL.LOCATION_CODE
, RL.TO_PERSON_ID
, DP.FULL_NAME
, RL.SUGGESTED_BUYER_ID
, SA.EMPLOYEE_NUMBER
, SA.FULL_NAME
, RL.SOURCE_ORGANIZATION_ID
, SC.ORGANIZATION_CODE
, SO.NAME
, RL.PURCHASING_AGENT_ID
, PA.EMPLOYEE_NUMBER
, PA.FULL_NAME
, RL.BLANKET_PO_HEADER_ID
, SH.SEGMENT1
, RL.BLANKET_PO_LINE_NUM
, RL.LINE_LOCATION_ID
, PS.SHIPMENT_NUM
, RL.PARENT_REQ_LINE_ID
, PL.LINE_NUM
, RL.BOM_RESOURCE_ID
, BR.RESOURCE_CODE
, RL.WIP_ENTITY_ID
, WE.WIP_ENTITY_NAME
, RL.WIP_LINE_ID
, WL.LINE_CODE
, RL.WIP_REPETITIVE_SCHEDULE_ID
, RL.WIP_OPERATION_SEQ_NUM
, RL.WIP_RESOURCE_SEQ_NUM
, RL.CREATION_DATE
, RL.CREATED_BY
, RL.LAST_UPDATE_DATE
, RL.LAST_UPDATED_BY
, RL.SECONDARY_QUANTITY
, RL.SECONDARY_UNIT_OF_MEASURE
, RL.PREFERRED_GRADE
, RL.SECONDARY_QUANTITY_RECEIVED
, RL.SECONDARY_QUANTITY_CANCELLED
, RL.AUCTION_DISPLAY_NUMBER
, RL.AUCTION_HEADER_ID
, RL.AUCTION_LINE_NUMBER
, RL.BID_NUMBER
, RL.BID_LINE_NUMBER
, '_LA:RL.REQS_IN_POOL_FLAG:PO_LOOKUP_CODES:YES/NO:DISPLAYED_FIELD'
, RL.OKE_CONTRACT_HEADER_ID
, RL.OKE_CONTRACT_VERSION_ID
, OKH.CONTRACT_NUMBER
, OKV.MAJOR_VERSION
, OKL.LINE_NUMBER
, '_LA:RL.VMI_FLAG:PO_LOOKUP_CODES:YES/NO:DISPLAYED_FIELD'
, RL.NOTE_TO_VENDOR
, '_LA:RL.PCARD_FLAG:PO_LOOKUP_CODES:YES/NO:DISPLAYED_FIELD'
, '_LA:RL.TAX_USER_OVERRIDE_FLAG:PO_LOOKUP_CODES:YES/NO:DISPLAYED_FIELD'
, RL.SHIP_METHOD
, RL.ESTIMATED_PICKUP_DATE
, RL.SUPPLIER_NOTIFIED_FOR_CANCEL
, RL.BASE_UNIT_PRICE
, RL.NEGOTIATED_BY_PREPARER_FLAG
, RL.DROP_SHIP_FLAG
, PS.SALES_ORDER_UPDATE_DATE
, RL.AMOUNT
, RL.CURRENCY_AMOUNT
, RL.LABOR_REQ_LINE_ID
, RL.JOB_ID
, PJVL.NAME
, RL.JOB_LONG_DESCRIPTION
, RL.CONTRACTOR_STATUS
, RL.CONTACT_INFORMATION
, RL.CANDIDATE_SCREENING_REQD_FLAG
, RL.CANDIDATE_FIRST_NAME
, RL.CANDIDATE_LAST_NAME
, RL.ASSIGNMENT_END_DATE
, RL.OVERTIME_ALLOWED_FLAG
, RL.CONTRACTOR_REQUISITION_FLAG
, RL.ASSIGNMENT_START_DATE
, RL.ORDER_TYPE_LOOKUP_CODE
, RL.PURCHASE_BASIS
, RL.MATCHING_BASIS
FROM PO_REQUISITION_LINES_ALL RL
, PO_REQUISITION_HEADERS_ALL RH
, HR_ALL_ORGANIZATION_UNITS OP
, BOM_RESOURCES BR
, FND_CURRENCIES_VL CU
, GL_DAILY_CONVERSION_TYPES RT
, PER_PEOPLE_F DP
, HR_LOCATIONS DL
, PER_PEOPLE_F PA
, 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
, HR_ALL_ORGANIZATION_UNITS SO
, MTL_PARAMETERS SC
, HR_ALL_ORGANIZATION_UNITS DO
, MTL_PARAMETERS DC
, MTL_SECONDARY_INVENTORIES SU
, PER_PEOPLE_F SA
, PO_HEADERS_ALL SH
, PO_LINES_ALL SL
, PO_LINE_LOCATIONS_ALL PS
, PO_REQUISITION_LINES_ALL PL
, PO_HAZARD_CLASSES HC
, PO_UN_NUMBERS UN
, WIP_ENTITIES WE
, WIP_LINES WL
, WIP_OPERATIONS WO
, WIP_OPERATION_RESOURCES WR
, OKC_K_HEADERS_B OKH
, OKC_K_VERS_NUMBERS_V OKV
, OKC_K_LINES_B OKL
, PER_JOBS_VL PJVL
WHERE RL.REQUISITION_HEADER_ID = RH.REQUISITION_HEADER_ID
AND RL.ORG_ID = FP.ORG_ID
AND FP.INVENTORY_ORGANIZATION_ID = MP.ORGANIZATION_ID
AND RL.ORG_ID = OP.ORGANIZATION_ID
AND RL.BOM_RESOURCE_ID = BR.RESOURCE_ID(+)
AND RL.CURRENCY_CODE = CU.CURRENCY_CODE(+)
AND RL.RATE_TYPE = RT.CONVERSION_TYPE(+)
AND RL.TO_PERSON_ID = DP.PERSON_ID(+)
AND DP.EFFECTIVE_START_DATE(+) <= TRUNC(SYSDATE)
AND DP.EFFECTIVE_END_DATE(+) >= TRUNC(SYSDATE)
AND RL.DELIVER_TO_LOCATION_ID = DL.LOCATION_ID(+)
AND RL.PURCHASING_AGENT_ID = PA.PERSON_ID(+)
AND PA.EFFECTIVE_START_DATE(+) <= TRUNC(SYSDATE)
AND PA.EFFECTIVE_END_DATE(+) >= TRUNC(SYSDATE)
AND RL.CATEGORY_ID = CT.CATEGORY_ID(+)
AND RL.ITEM_REVISION = IR.REVISION(+)
AND RL.ITEM_ID = IR.INVENTORY_ITEM_ID(+)
AND NVL(IR.ORGANIZATION_ID
, FP.INVENTORY_ORGANIZATION_ID) = FP.INVENTORY_ORGANIZATION_ID
AND RL.ITEM_ID = SI.INVENTORY_ITEM_ID(+)
AND NVL(SI.ORGANIZATION_ID
, FP.INVENTORY_ORGANIZATION_ID) = FP.INVENTORY_ORGANIZATION_ID
AND RL.LINE_TYPE_ID = LT.LINE_TYPE_ID(+)
AND RL.UNIT_MEAS_LOOKUP_CODE = UM.UNIT_OF_MEASURE(+)
AND RL.SOURCE_ORGANIZATION_ID = SO.ORGANIZATION_ID(+)
AND RL.SOURCE_ORGANIZATION_ID = SC.ORGANIZATION_ID(+)
AND RL.DESTINATION_ORGANIZATION_ID = DO.ORGANIZATION_ID(+)
AND RL.DESTINATION_ORGANIZATION_ID = DC.ORGANIZATION_ID(+)
AND RL.DESTINATION_SUBINVENTORY = SU.SECONDARY_INVENTORY_NAME(+)
AND RL.DESTINATION_ORGANIZATION_ID = SU.ORGANIZATION_ID(+)
AND RL.SUGGESTED_BUYER_ID = SA.PERSON_ID(+)
AND SA.EFFECTIVE_START_DATE(+) <= TRUNC(SYSDATE)
AND SA.EFFECTIVE_END_DATE(+) >= TRUNC(SYSDATE)
AND RL.BLANKET_PO_HEADER_ID = SH.PO_HEADER_ID(+)
AND RL.BLANKET_PO_HEADER_ID = SL.PO_HEADER_ID(+)
AND RL.BLANKET_PO_LINE_NUM = SL.LINE_NUM(+)
AND RL.LINE_LOCATION_ID = PS.LINE_LOCATION_ID(+)
AND RL.PARENT_REQ_LINE_ID = PL.REQUISITION_LINE_ID(+)
AND RL.HAZARD_CLASS_ID = HC.HAZARD_CLASS_ID(+)
AND RL.UN_NUMBER_ID = UN.UN_NUMBER_ID(+)
AND RL.WIP_ENTITY_ID = WE.WIP_ENTITY_ID(+)
AND RL.DESTINATION_ORGANIZATION_ID = WE.ORGANIZATION_ID(+)
AND RL.WIP_LINE_ID = WL.LINE_ID(+)
AND RL.DESTINATION_ORGANIZATION_ID = WL.ORGANIZATION_ID(+)
AND RL.WIP_ENTITY_ID = WO.WIP_ENTITY_ID(+)
AND RL.DESTINATION_ORGANIZATION_ID = WO.ORGANIZATION_ID(+)
AND RL.WIP_OPERATION_SEQ_NUM = WO.OPERATION_SEQ_NUM(+)
AND RL.WIP_REPETITIVE_SCHEDULE_ID = WO.REPETITIVE_SCHEDULE_ID(+)
AND RL.WIP_ENTITY_ID = WR.WIP_ENTITY_ID(+)
AND RL.DESTINATION_ORGANIZATION_ID = WR.ORGANIZATION_ID(+)
AND RL.WIP_OPERATION_SEQ_NUM = WR.OPERATION_SEQ_NUM(+)
AND RL.WIP_RESOURCE_SEQ_NUM = WR.RESOURCE_SEQ_NUM(+)
AND RL.WIP_REPETITIVE_SCHEDULE_ID = WR.REPETITIVE_SCHEDULE_ID(+)
AND RL.OKE_CONTRACT_HEADER_ID = OKH.ID(+)
AND OKH.ID = OKL.CHR_ID(+)
AND OKH.ID = OKV.CHR_ID(+)
AND PJVL.JOB_ID (+) = RL.JOB_ID
AND '_SEC:RL.ORG_ID' IS NOT NULL WITH READ ONLY

Columns