VIEW: APPS.OKE_DTS_SEARCH_LOV_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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