VIEW: APPS.POFV_REQUISITION_LINES

Source

View Text - Preformatted

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, RL.AT_SOURCING_FLAG 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 WITH READ ONLY

View Text - HTML Formatted

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
, RL.AT_SOURCING_FLAG
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 WITH READ ONLY