Product: | OKE - Project Contracts |
---|---|
Description: | |
Implementation/DBA Data: | APPS.OKE_DTS_SEARCH_LOV_V |
SELECT OKEDTS.AVAILABLE_FOR_SHIP_FLAG
, OKEDTS.BILLABLE_FLAG
, OKEDTS.CDRL_CATEGORY
, OKEDTS.CFE_REQ_FLAG
, OKEDTS.COMPLETED_FLAG
, OKEDTS.COUNTRY_OF_ORIGIN_CODE
, OKEDTS.CREATE_DEMAND
, OKEDTS.CURRENCY_CODE
, OKEDTS.CUSTOMER_APPROVAL_REQ_FLAG
, OKEDTS.DATA_ITEM_NAME
, OKEDTS.DATA_ITEM_SUBTITLE
, OKEDTS.DATE_OF_FIRST_SUBMISSION
, OKEDTS.DEFAULTED_FLAG
, OKEDTS.DELIVERABLE_NUM
, OKEDTS.DELIVERABLE_ID
, OKEDTS.DELIVERY_DATE
, OKEDTS.DEPENDENCY_FLAG
, OKEDTS.DESTINATION_TYPE_CODE
, POTYPE.DISPLAYED_FIELD DESTINATION_TYPE
, OKEDTS.DIRECTION
, OKEDTS.DROP_SHIPPED_FLAG
, OKEDTS.END_DATE
, OKEDTS.EXPECTED_SHIPMENT_DATE
, OKEDTS.EXPENDITURE_ITEM_DATE
, OKEDTS.EXPENDITURE_ORGANIZATION_ID
, PAXORG.NAME EXPENDITURE_ORG
, OKEDTS.EXPENDITURE_TYPE
, OKEDTS.EXPORT_FLAG
, OKEDTS.EXPORT_LICENSE_NUM
, OKEDTS.EXPORT_LICENSE_RES
, OKEDTS.FREQUENCY
, OKEDTS.IN_PROCESS_FLAG
, OKEDTS.INITIATE_SHIPMENT_DATE
, OKEDTS.INSPECTION_REQ_FLAG
, OKEDTS.INTERIM_RPT_REQ_FLAG
, OKEDTS.ITEM_ID
, OKEITM.NAME ITEM
, OKEDTS.K_LINE_ID
, OKELIN.LINE_NUMBER
, OKEDTS.NDB_SCHEDULE_DESIGNATOR
, OKEDTS.NEED_BY_DATE
, OKEDTS.PRIORITY_CODE
, OKEDTS.PROJECT_ID
, PAXPRJ.SEGMENT1 PROJECT_NUMBER
, OKEDTS.PROMISED_SHIPMENT_DATE
, OKEDTS.QUANTITY
, OKEDTS.READY_TO_BILL
, OKEDTS.READY_TO_PROCURE
, OKEDTS.SHIP_FROM_LOCATION_ID
, OKEDTS.SHIP_FROM_ORG_ID
, OKEDTS.SHIP_TO_LOCATION_ID
, OKEDTS.SHIP_TO_ORG_ID
, OKEDTS.SHIPPABLE_FLAG
, OKEDTS.START_DATE
, OKEDTS.SUBCONTRACTED_FLAG
, OKEDTS.TASK_ID
, PAXTSK.TASK_NUMBER
, OKEDTS.TOTAL_NUM_OF_COPIES
, OKEDTS.UNIT_NUMBER
, OKEDTS.UNIT_PRICE
, OKEDTS.UOM_CODE
, OKEDTS.VOLUME
, OKEDTS.VOLUME_UOM_CODE
, OKEDTS.WEIGHT
, OKEDTS.WEIGHT_UOM_CODE
, OKEDTS.K_HEADER_ID
FROM OKE_K_DELIVERABLES_VL OKEDTS
, PO_LOOKUP_CODES POTYPE
, PA_ORGANIZATIONS_EXPEND_V PAXORG
, OKE_SYSTEM_ITEMS_V OKEITM
, OKC_K_LINES_B OKELIN
, PA_PROJECTS_ALL PAXPRJ
, PA_TASKS PAXTSK
WHERE POTYPE.LOOKUP_TYPE = 'DESTINATION TYPE'
AND POTYPE.LOOKUP_CODE(+) = NVL(OKEDTS.DESTINATION_TYPE_CODE
, 'INVENTORY')
AND PAXORG.ORGANIZATION_ID(+) = OKEDTS.EXPENDITURE_ORGANIZATION_ID
AND OKEITM.ID1(+) = OKEDTS.ITEM_ID
AND OKEITM.ID2(+) = OKEDTS.INVENTORY_ORG_ID
AND OKELIN.ID(+) = OKEDTS.K_LINE_ID
AND PAXPRJ.PROJECT_ID(+) = OKEDTS.PROJECT_ID
AND PAXTSK.TASK_ID(+) = OKEDTS.TASK_ID