VIEW: WIP.WIP_LPN_COMPLETIONS#

Source

View Text - Preformatted

select HEADER_ID HEADER_ID, SOURCE_ID SOURCE_ID, SOURCE_CODE SOURCE_CODE, COMPLETION_STATUS COMPLETION_STATUS, 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_APPLICATION_ID PROGRAM_APPLICATION_ID, PROGRAM_ID PROGRAM_ID, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE, INVENTORY_ITEM_ID INVENTORY_ITEM_ID, ORGANIZATION_ID ORGANIZATION_ID, PRIMARY_QUANTITY PRIMARY_QUANTITY, TRANSACTION_QUANTITY TRANSACTION_QUANTITY, TRANSACTION_UOM TRANSACTION_UOM, TRANSACTION_DATE TRANSACTION_DATE, TRANSACTION_ACTION_ID TRANSACTION_ACTION_ID, TRANSACTION_SOURCE_ID TRANSACTION_SOURCE_ID, TRANSACTION_SOURCE_TYPE_ID TRANSACTION_SOURCE_TYPE_ID, TRANSACTION_TYPE_ID TRANSACTION_TYPE_ID, TRANSACTION_MODE TRANSACTION_MODE, ACCT_PERIOD_ID ACCT_PERIOD_ID, SUBINVENTORY_CODE SUBINVENTORY_CODE, LOCATOR_ID LOCATOR_ID, WIP_ENTITY_ID WIP_ENTITY_ID, WIP_ENTITY_TYPE WIP_ENTITY_TYPE, SCHEDULE_ID SCHEDULE_ID, REPETITIVE_LINE_ID REPETITIVE_LINE_ID, OPERATION_SEQ_NUM OPERATION_SEQ_NUM, BOM_REVISION BOM_REVISION, ROUTING_REVISION ROUTING_REVISION, BOM_REVISION_DATE BOM_REVISION_DATE, ROUTING_REVISION_DATE ROUTING_REVISION_DATE, ALTERNATE_BOM_DESIGNATOR ALTERNATE_BOM_DESIGNATOR, ALTERNATE_ROUTING_DESIGNATOR ALTERNATE_ROUTING_DESIGNATOR, ACCOUNTING_CLASS ACCOUNTING_CLASS, COST_GROUP_ID COST_GROUP_ID, KANBAN_CARD_ID KANBAN_CARD_ID, QA_COLLECTION_ID QA_COLLECTION_ID, LPN_ID LPN_ID, REASON_ID REASON_ID, LOCK_FLAG LOCK_FLAG, ERROR_CODE ERROR_CODE, FINAL_COMPLETION_FLAG FINAL_COMPLETION_FLAG, END_ITEM_UNIT_NUMBER END_ITEM_UNIT_NUMBER, COMPLETION_TRANSACTION_ID COMPLETION_TRANSACTION_ID, ITEM_PROJECT_ID ITEM_PROJECT_ID, ITEM_TASK_ID ITEM_TASK_ID, SOURCE_PROJECT_ID SOURCE_PROJECT_ID, SOURCE_TASK_ID SOURCE_TASK_ID, DEMAND_SOURCE_HEADER_ID DEMAND_SOURCE_HEADER_ID, DEMAND_SOURCE_LINE DEMAND_SOURCE_LINE, DEMAND_SOURCE_DELIVERY DEMAND_SOURCE_DELIVERY from "WIP"."WIP_LPN_COMPLETIONS"

View Text - HTML Formatted

SELECT HEADER_ID HEADER_ID
, SOURCE_ID SOURCE_ID
, SOURCE_CODE SOURCE_CODE
, COMPLETION_STATUS COMPLETION_STATUS
, 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_APPLICATION_ID PROGRAM_APPLICATION_ID
, PROGRAM_ID PROGRAM_ID
, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, INVENTORY_ITEM_ID INVENTORY_ITEM_ID
, ORGANIZATION_ID ORGANIZATION_ID
, PRIMARY_QUANTITY PRIMARY_QUANTITY
, TRANSACTION_QUANTITY TRANSACTION_QUANTITY
, TRANSACTION_UOM TRANSACTION_UOM
, TRANSACTION_DATE TRANSACTION_DATE
, TRANSACTION_ACTION_ID TRANSACTION_ACTION_ID
, TRANSACTION_SOURCE_ID TRANSACTION_SOURCE_ID
, TRANSACTION_SOURCE_TYPE_ID TRANSACTION_SOURCE_TYPE_ID
, TRANSACTION_TYPE_ID TRANSACTION_TYPE_ID
, TRANSACTION_MODE TRANSACTION_MODE
, ACCT_PERIOD_ID ACCT_PERIOD_ID
, SUBINVENTORY_CODE SUBINVENTORY_CODE
, LOCATOR_ID LOCATOR_ID
, WIP_ENTITY_ID WIP_ENTITY_ID
, WIP_ENTITY_TYPE WIP_ENTITY_TYPE
, SCHEDULE_ID SCHEDULE_ID
, REPETITIVE_LINE_ID REPETITIVE_LINE_ID
, OPERATION_SEQ_NUM OPERATION_SEQ_NUM
, BOM_REVISION BOM_REVISION
, ROUTING_REVISION ROUTING_REVISION
, BOM_REVISION_DATE BOM_REVISION_DATE
, ROUTING_REVISION_DATE ROUTING_REVISION_DATE
, ALTERNATE_BOM_DESIGNATOR ALTERNATE_BOM_DESIGNATOR
, ALTERNATE_ROUTING_DESIGNATOR ALTERNATE_ROUTING_DESIGNATOR
, ACCOUNTING_CLASS ACCOUNTING_CLASS
, COST_GROUP_ID COST_GROUP_ID
, KANBAN_CARD_ID KANBAN_CARD_ID
, QA_COLLECTION_ID QA_COLLECTION_ID
, LPN_ID LPN_ID
, REASON_ID REASON_ID
, LOCK_FLAG LOCK_FLAG
, ERROR_CODE ERROR_CODE
, FINAL_COMPLETION_FLAG FINAL_COMPLETION_FLAG
, END_ITEM_UNIT_NUMBER END_ITEM_UNIT_NUMBER
, COMPLETION_TRANSACTION_ID COMPLETION_TRANSACTION_ID
, ITEM_PROJECT_ID ITEM_PROJECT_ID
, ITEM_TASK_ID ITEM_TASK_ID
, SOURCE_PROJECT_ID SOURCE_PROJECT_ID
, SOURCE_TASK_ID SOURCE_TASK_ID
, DEMAND_SOURCE_HEADER_ID DEMAND_SOURCE_HEADER_ID
, DEMAND_SOURCE_LINE DEMAND_SOURCE_LINE
, DEMAND_SOURCE_DELIVERY DEMAND_SOURCE_DELIVERY
FROM "WIP"."WIP_LPN_COMPLETIONS"