eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

VIEW: PJM.PJM_DEFAULT_TASKS#

Source

View Text - Preformatted


select ASSIGNMENT_TYPE ASSIGNMENT_TYPE, PROJECT_ID PROJECT_ID, TASK_ID TASK_ID, ORGANIZATION_ID ORGANIZATION_ID, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, INVENTORY_ITEM_ID INVENTORY_ITEM_ID, CATEGORY_ID CATEGORY_ID, PO_HEADER_ID PO_HEADER_ID, SUBINVENTORY_CODE SUBINVENTORY_CODE, PROCURE_FLAG PROCURE_FLAG, STANDARD_OPERATION_ID STANDARD_OPERATION_ID, ASSEMBLY_ITEM_ID ASSEMBLY_ITEM_ID, DEPARTMENT_ID DEPARTMENT_ID, WIP_ENTITY_PATTERN WIP_ENTITY_PATTERN, TO_ORGANIZATION_ID TO_ORGANIZATION_ID, COMMENTS COMMENTS, TASK_ATTRIBUTE_CATEGORY TASK_ATTRIBUTE_CATEGORY, TASK_ATTRIBUTE1 TASK_ATTRIBUTE1, TASK_ATTRIBUTE2 TASK_ATTRIBUTE2, TASK_ATTRIBUTE3 TASK_ATTRIBUTE3, TASK_ATTRIBUTE4 TASK_ATTRIBUTE4, TASK_ATTRIBUTE5 TASK_ATTRIBUTE5, TASK_ATTRIBUTE6 TASK_ATTRIBUTE6, TASK_ATTRIBUTE7 TASK_ATTRIBUTE7, TASK_ATTRIBUTE8 TASK_ATTRIBUTE8, TASK_ATTRIBUTE9 TASK_ATTRIBUTE9, TASK_ATTRIBUTE10 TASK_ATTRIBUTE10, TASK_ATTRIBUTE11 TASK_ATTRIBUTE11, TASK_ATTRIBUTE12 TASK_ATTRIBUTE12, TASK_ATTRIBUTE13 TASK_ATTRIBUTE13, TASK_ATTRIBUTE14 TASK_ATTRIBUTE14, TASK_ATTRIBUTE15 TASK_ATTRIBUTE15, WIP_MATL_TXN_TYPE WIP_MATL_TXN_TYPE from "PJM"."PJM_DEFAULT_TASKS"

View Text - HTML Formatted

SELECT ASSIGNMENT_TYPE ASSIGNMENT_TYPE
, PROJECT_ID PROJECT_ID
, TASK_ID TASK_ID
, ORGANIZATION_ID ORGANIZATION_ID
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, INVENTORY_ITEM_ID INVENTORY_ITEM_ID
, CATEGORY_ID CATEGORY_ID
, PO_HEADER_ID PO_HEADER_ID
, SUBINVENTORY_CODE SUBINVENTORY_CODE
, PROCURE_FLAG PROCURE_FLAG
, STANDARD_OPERATION_ID STANDARD_OPERATION_ID
, ASSEMBLY_ITEM_ID ASSEMBLY_ITEM_ID
, DEPARTMENT_ID DEPARTMENT_ID
, WIP_ENTITY_PATTERN WIP_ENTITY_PATTERN
, TO_ORGANIZATION_ID TO_ORGANIZATION_ID
, COMMENTS COMMENTS
, TASK_ATTRIBUTE_CATEGORY TASK_ATTRIBUTE_CATEGORY
, TASK_ATTRIBUTE1 TASK_ATTRIBUTE1
, TASK_ATTRIBUTE2 TASK_ATTRIBUTE2
, TASK_ATTRIBUTE3 TASK_ATTRIBUTE3
, TASK_ATTRIBUTE4 TASK_ATTRIBUTE4
, TASK_ATTRIBUTE5 TASK_ATTRIBUTE5
, TASK_ATTRIBUTE6 TASK_ATTRIBUTE6
, TASK_ATTRIBUTE7 TASK_ATTRIBUTE7
, TASK_ATTRIBUTE8 TASK_ATTRIBUTE8
, TASK_ATTRIBUTE9 TASK_ATTRIBUTE9
, TASK_ATTRIBUTE10 TASK_ATTRIBUTE10
, TASK_ATTRIBUTE11 TASK_ATTRIBUTE11
, TASK_ATTRIBUTE12 TASK_ATTRIBUTE12
, TASK_ATTRIBUTE13 TASK_ATTRIBUTE13
, TASK_ATTRIBUTE14 TASK_ATTRIBUTE14
, TASK_ATTRIBUTE15 TASK_ATTRIBUTE15
, WIP_MATL_TXN_TYPE WIP_MATL_TXN_TYPE
FROM "PJM"."PJM_DEFAULT_TASKS"