VIEW: PO.PO_RETRIEVED_TIMECARDS#

Source

View Text - Preformatted

select VENDOR_ID VENDOR_ID, VENDOR_SITE_ID VENDOR_SITE_ID, VENDOR_CONTACT_ID VENDOR_CONTACT_ID, PO_HEADER_ID PO_HEADER_ID, PO_NUMBER PO_NUMBER, PO_LINE_ID PO_LINE_ID, PO_LINE_NUMBER PO_LINE_NUMBER, ORG_ID ORG_ID, PO_CREATION_DATE PO_CREATION_DATE, PO_CONTRACTOR_FULL_NAME PO_CONTRACTOR_FULL_NAME, PROJECT_ID PROJECT_ID, PROJECT_NAME PROJECT_NAME, TASK_ID TASK_ID, TASK_NAME TASK_NAME, TC_ID TC_ID, TC_DAY_ID TC_DAY_ID, TC_DETAIL_ID TC_DETAIL_ID, TC_UOM TC_UOM, TC_START_DATE TC_START_DATE, TC_END_DATE TC_END_DATE, TC_ENTRY_DATE TC_ENTRY_DATE, TC_TIME_RECEIVED TC_TIME_RECEIVED, TC_SUBMISSION_DATE TC_SUBMISSION_DATE, TC_APPROVAL_STATUS TC_APPROVAL_STATUS, TC_APPROVED_DATE TC_APPROVED_DATE, TC_SCOPE TC_SCOPE, CONTINGENT_WORKER_ID CONTINGENT_WORKER_ID, TC_COMMENT_TEXT TC_COMMENT_TEXT, LINE_RATE_TYPE LINE_RATE_TYPE, LINE_RATE LINE_RATE, LINE_RATE_CURRENCY LINE_RATE_CURRENCY, PO_CONTRACTOR_LAST_NAME PO_CONTRACTOR_LAST_NAME, PO_CONTRACTOR_FIRST_NAME PO_CONTRACTOR_FIRST_NAME, INTERFACE_TRANSACTION_ID INTERFACE_TRANSACTION_ID, ACTION_FLAG ACTION_FLAG, TC_ENTRY_SEQUENCE TC_ENTRY_SEQUENCE from "PO"."PO_RETRIEVED_TIMECARDS"

View Text - HTML Formatted

SELECT VENDOR_ID VENDOR_ID
, VENDOR_SITE_ID VENDOR_SITE_ID
, VENDOR_CONTACT_ID VENDOR_CONTACT_ID
, PO_HEADER_ID PO_HEADER_ID
, PO_NUMBER PO_NUMBER
, PO_LINE_ID PO_LINE_ID
, PO_LINE_NUMBER PO_LINE_NUMBER
, ORG_ID ORG_ID
, PO_CREATION_DATE PO_CREATION_DATE
, PO_CONTRACTOR_FULL_NAME PO_CONTRACTOR_FULL_NAME
, PROJECT_ID PROJECT_ID
, PROJECT_NAME PROJECT_NAME
, TASK_ID TASK_ID
, TASK_NAME TASK_NAME
, TC_ID TC_ID
, TC_DAY_ID TC_DAY_ID
, TC_DETAIL_ID TC_DETAIL_ID
, TC_UOM TC_UOM
, TC_START_DATE TC_START_DATE
, TC_END_DATE TC_END_DATE
, TC_ENTRY_DATE TC_ENTRY_DATE
, TC_TIME_RECEIVED TC_TIME_RECEIVED
, TC_SUBMISSION_DATE TC_SUBMISSION_DATE
, TC_APPROVAL_STATUS TC_APPROVAL_STATUS
, TC_APPROVED_DATE TC_APPROVED_DATE
, TC_SCOPE TC_SCOPE
, CONTINGENT_WORKER_ID CONTINGENT_WORKER_ID
, TC_COMMENT_TEXT TC_COMMENT_TEXT
, LINE_RATE_TYPE LINE_RATE_TYPE
, LINE_RATE LINE_RATE
, LINE_RATE_CURRENCY LINE_RATE_CURRENCY
, PO_CONTRACTOR_LAST_NAME PO_CONTRACTOR_LAST_NAME
, PO_CONTRACTOR_FIRST_NAME PO_CONTRACTOR_FIRST_NAME
, INTERFACE_TRANSACTION_ID INTERFACE_TRANSACTION_ID
, ACTION_FLAG ACTION_FLAG
, TC_ENTRY_SEQUENCE TC_ENTRY_SEQUENCE
FROM "PO"."PO_RETRIEVED_TIMECARDS"