[Home] [Help] [Dependency Information]
Object Name: | PO_RETRIEVED_TIMECARDS# |
---|---|
Object Type: | VIEW |
Owner: | PO |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
VENDOR_ID | NUMBER | Yes | ||
VENDOR_SITE_ID | NUMBER | |||
VENDOR_CONTACT_ID | NUMBER | |||
PO_HEADER_ID | NUMBER | Yes | ||
PO_NUMBER | VARCHAR2 | (20) | Yes | |
PO_LINE_ID | NUMBER | Yes | ||
PO_LINE_NUMBER | NUMBER | Yes | ||
ORG_ID | NUMBER | Yes | ||
PO_CREATION_DATE | DATE | Yes | ||
PO_CONTRACTOR_FULL_NAME | VARCHAR2 | (240) | Yes | |
PROJECT_ID | NUMBER | |||
PROJECT_NAME | VARCHAR2 | (240) | ||
TASK_ID | NUMBER | |||
TASK_NAME | VARCHAR2 | (240) | ||
TC_ID | NUMBER | Yes | ||
TC_DAY_ID | NUMBER | Yes | ||
TC_DETAIL_ID | NUMBER | Yes | ||
TC_UOM | VARCHAR2 | (30) | Yes | |
TC_START_DATE | DATE | Yes | ||
TC_END_DATE | DATE | |||
TC_ENTRY_DATE | DATE | Yes | ||
TC_TIME_RECEIVED | NUMBER | |||
TC_SUBMISSION_DATE | DATE | |||
TC_APPROVAL_STATUS | VARCHAR2 | (30) | ||
TC_APPROVED_DATE | DATE | Yes | ||
TC_SCOPE | VARCHAR2 | (30) | ||
CONTINGENT_WORKER_ID | NUMBER | Yes | ||
TC_COMMENT_TEXT | VARCHAR2 | (2000) | ||
LINE_RATE_TYPE | VARCHAR2 | (30) | Yes | |
LINE_RATE | NUMBER | Yes | ||
LINE_RATE_CURRENCY | VARCHAR2 | (3) | Yes | |
PO_CONTRACTOR_LAST_NAME | VARCHAR2 | (240) | ||
PO_CONTRACTOR_FIRST_NAME | VARCHAR2 | (240) | ||
INTERFACE_TRANSACTION_ID | NUMBER | Yes | ||
ACTION_FLAG | VARCHAR2 | (2) | Yes | |
TC_ENTRY_SEQUENCE | NUMBER | Yes |
Cut, paste (and edit) the following text to query this object:
SELECT VENDOR_ID
, VENDOR_SITE_ID
, VENDOR_CONTACT_ID
, PO_HEADER_ID
, PO_NUMBER
, PO_LINE_ID
, PO_LINE_NUMBER
, ORG_ID
, PO_CREATION_DATE
, PO_CONTRACTOR_FULL_NAME
, PROJECT_ID
, PROJECT_NAME
, TASK_ID
, TASK_NAME
, TC_ID
, TC_DAY_ID
, TC_DETAIL_ID
, TC_UOM
, TC_START_DATE
, TC_END_DATE
, TC_ENTRY_DATE
, TC_TIME_RECEIVED
, TC_SUBMISSION_DATE
, TC_APPROVAL_STATUS
, TC_APPROVED_DATE
, TC_SCOPE
, CONTINGENT_WORKER_ID
, TC_COMMENT_TEXT
, LINE_RATE_TYPE
, LINE_RATE
, LINE_RATE_CURRENCY
, PO_CONTRACTOR_LAST_NAME
, PO_CONTRACTOR_FIRST_NAME
, INTERFACE_TRANSACTION_ID
, ACTION_FLAG
, TC_ENTRY_SEQUENCE
FROM PO.PO_RETRIEVED_TIMECARDS#;
|
|
|