VIEW: JMF.JMF_SUBCONTRACT_ORDERS#

Source

View Text - Preformatted

select SUBCONTRACT_PO_SHIPMENT_ID SUBCONTRACT_PO_SHIPMENT_ID, SUBCONTRACT_PO_HEADER_ID SUBCONTRACT_PO_HEADER_ID, SUBCONTRACT_PO_LINE_ID SUBCONTRACT_PO_LINE_ID, PROJECT_ID PROJECT_ID, TASK_ID TASK_ID, OEM_ORGANIZATION_ID OEM_ORGANIZATION_ID, TP_ORGANIZATION_ID TP_ORGANIZATION_ID, WIP_ENTITY_ID WIP_ENTITY_ID, OSA_ITEM_ID OSA_ITEM_ID, OSA_ITEM_PRICE OSA_ITEM_PRICE, NEED_BY_DATE NEED_BY_DATE, UOM UOM, CURRENCY CURRENCY, QUANTITY QUANTITY, INTERLOCK_STATUS INTERLOCK_STATUS, BATCH_ID BATCH_ID, REQUEST_ID REQUEST_ID, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, PROGRAM_ID PROGRAM_ID, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID from "JMF"."JMF_SUBCONTRACT_ORDERS"

View Text - HTML Formatted

SELECT SUBCONTRACT_PO_SHIPMENT_ID SUBCONTRACT_PO_SHIPMENT_ID
, SUBCONTRACT_PO_HEADER_ID SUBCONTRACT_PO_HEADER_ID
, SUBCONTRACT_PO_LINE_ID SUBCONTRACT_PO_LINE_ID
, PROJECT_ID PROJECT_ID
, TASK_ID TASK_ID
, OEM_ORGANIZATION_ID OEM_ORGANIZATION_ID
, TP_ORGANIZATION_ID TP_ORGANIZATION_ID
, WIP_ENTITY_ID WIP_ENTITY_ID
, OSA_ITEM_ID OSA_ITEM_ID
, OSA_ITEM_PRICE OSA_ITEM_PRICE
, NEED_BY_DATE NEED_BY_DATE
, UOM UOM
, CURRENCY CURRENCY
, QUANTITY QUANTITY
, INTERLOCK_STATUS INTERLOCK_STATUS
, BATCH_ID BATCH_ID
, REQUEST_ID REQUEST_ID
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, PROGRAM_ID PROGRAM_ID
, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
FROM "JMF"."JMF_SUBCONTRACT_ORDERS"