[Home] [Help] [Dependency Information]
Object Name: | PA_COMMITMENT_TXNS# |
---|---|
Object Type: | VIEW |
Owner: | PA |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
CMT_LINE_ID | NUMBER | (15) | Yes | |
PROJECT_ID | NUMBER | (15) | Yes | |
TASK_ID | NUMBER | (15) | Yes | |
TRANSACTION_SOURCE | VARCHAR2 | (30) | Yes | |
LINE_TYPE | VARCHAR2 | (1) | Yes | |
CMT_NUMBER | VARCHAR2 | (240) | ||
CMT_DISTRIBUTION_ID | NUMBER | |||
DESCRIPTION | VARCHAR2 | (255) | ||
EXPENDITURE_ITEM_DATE | DATE | Yes | ||
PA_PERIOD | VARCHAR2 | (20) | Yes | |
GL_PERIOD | VARCHAR2 | (15) | Yes | |
CMT_LINE_NUMBER | NUMBER | |||
CMT_CREATION_DATE | DATE | |||
CMT_APPROVED_DATE | DATE | |||
CMT_REQUESTOR_NAME | VARCHAR2 | (240) | ||
CMT_BUYER_NAME | VARCHAR2 | (240) | ||
CMT_APPROVED_FLAG | VARCHAR2 | (1) | ||
CMT_PROMISED_DATE | DATE | |||
CMT_NEED_BY_DATE | DATE | |||
CMT_HEADER_ID | NUMBER | |||
ORGANIZATION_ID | NUMBER | |||
VENDOR_ID | NUMBER | |||
VENDOR_NAME | VARCHAR2 | (240) | ||
EXPENDITURE_TYPE | VARCHAR2 | (30) | Yes | |
EXPENDITURE_CATEGORY | VARCHAR2 | (30) | Yes | |
REVENUE_CATEGORY | VARCHAR2 | (30) | Yes | |
SYSTEM_LINKAGE_FUNCTION | VARCHAR2 | (30) | Yes | |
UNIT_OF_MEASURE | VARCHAR2 | (30) | ||
UNIT_PRICE | NUMBER | |||
CMT_IND_COMPILED_SET_ID | NUMBER | (15) | ||
TOT_CMT_RAW_COST | NUMBER | |||
TOT_CMT_BURDENED_COST | NUMBER | |||
TOT_CMT_QUANTITY | NUMBER | |||
QUANTITY_ORDERED | NUMBER | |||
AMOUNT_ORDERED | NUMBER | |||
ORIGINAL_QUANTITY_ORDERED | NUMBER | |||
ORIGINAL_AMOUNT_ORDERED | NUMBER | |||
QUANTITY_CANCELLED | NUMBER | |||
AMOUNT_CANCELLED | NUMBER | |||
QUANTITY_DELIVERED | NUMBER | |||
AMOUNT_DELIVERED | NUMBER | |||
QUANTITY_INVOICED | NUMBER | |||
AMOUNT_INVOICED | NUMBER | |||
QUANTITY_OUTSTANDING_DELIVERY | NUMBER | |||
AMOUNT_OUTSTANDING_DELIVERY | NUMBER | |||
QUANTITY_OUTSTANDING_INVOICE | NUMBER | |||
AMOUNT_OUTSTANDING_INVOICE | NUMBER | |||
QUANTITY_OVERBILLED | NUMBER | |||
AMOUNT_OVERBILLED | NUMBER | |||
ORIGINAL_TXN_REFERENCE1 | VARCHAR2 | (30) | ||
ORIGINAL_TXN_REFERENCE2 | VARCHAR2 | (15) | ||
ORIGINAL_TXN_REFERENCE3 | VARCHAR2 | (15) | ||
LAST_UPDATED_BY | NUMBER | Yes | ||
LAST_UPDATE_DATE | DATE | Yes | ||
CREATION_DATE | DATE | Yes | ||
CREATED_BY | NUMBER | Yes | ||
LAST_UPDATE_LOGIN | NUMBER | Yes | ||
REQUEST_ID | NUMBER | |||
PROGRAM_APPLICATION_ID | NUMBER | |||
PROGRAM_ID | NUMBER | |||
PROGRAM_UPDATE_DATE | DATE | |||
BURDEN_SUM_SOURCE_RUN_ID | NUMBER | (15) | ||
BURDEN_SUM_DEST_RUN_ID | NUMBER | (15) | ||
BURDEN_SUM_REJECTION_CODE | VARCHAR2 | (30) | ||
RECEIPT_CURRENCY_CODE | VARCHAR2 | (15) | ||
RECEIPT_CURRENCY_AMOUNT | NUMBER | |||
RECEIPT_EXCHANGE_RATE | NUMBER | |||
DENOM_CURRENCY_CODE | VARCHAR2 | (15) | ||
DENOM_RAW_COST | NUMBER | |||
DENOM_BURDENED_COST | NUMBER | |||
ACCT_CURRENCY_CODE | VARCHAR2 | (15) | ||
ACCT_RAW_COST | NUMBER | |||
ACCT_BURDENED_COST | NUMBER | |||
ACCT_RATE_DATE | DATE | |||
ACCT_RATE_TYPE | VARCHAR2 | (30) | ||
ACCT_EXCHANGE_RATE | NUMBER | |||
PROJECT_CURRENCY_CODE | VARCHAR2 | (15) | ||
PROJECT_RATE_DATE | DATE | |||
PROJECT_RATE_TYPE | VARCHAR2 | (30) | ||
PROJECT_EXCHANGE_RATE | NUMBER | |||
CMT_REJECTION_CODE | VARCHAR2 | (80) | ||
GENERATION_ERROR_FLAG | VARCHAR2 | (1) | ||
INVENTORY_ITEM_ID | NUMBER | (15) | ||
BOM_LABOR_RESOURCE_ID | NUMBER | (15) | ||
BOM_EQUIPMENT_RESOURCE_ID | NUMBER | (15) | ||
PROJ_RAW_COST | NUMBER | |||
PROJ_BURDENED_COST | NUMBER | |||
PROJ_CURRENCY_CODE | VARCHAR2 | (15) | ||
PROJ_RATE_DATE | DATE | |||
PROJ_RATE_TYPE | VARCHAR2 | (30) | ||
PROJ_EXCHANGE_RATE | NUMBER | |||
UOM_CODE | VARCHAR2 | (30) | ||
RESOURCE_CLASS | VARCHAR2 | (30) | ||
SRC_SYSTEM_LINKAGE_FUNCTION | VARCHAR2 | (3) | ||
CBS_ELEMENT_ID | NUMBER | (15) |
Cut, paste (and edit) the following text to query this object:
SELECT CMT_LINE_ID
, PROJECT_ID
, TASK_ID
, TRANSACTION_SOURCE
, LINE_TYPE
, CMT_NUMBER
, CMT_DISTRIBUTION_ID
, DESCRIPTION
, EXPENDITURE_ITEM_DATE
, PA_PERIOD
, GL_PERIOD
, CMT_LINE_NUMBER
, CMT_CREATION_DATE
, CMT_APPROVED_DATE
, CMT_REQUESTOR_NAME
, CMT_BUYER_NAME
, CMT_APPROVED_FLAG
, CMT_PROMISED_DATE
, CMT_NEED_BY_DATE
, CMT_HEADER_ID
, ORGANIZATION_ID
, VENDOR_ID
, VENDOR_NAME
, EXPENDITURE_TYPE
, EXPENDITURE_CATEGORY
, REVENUE_CATEGORY
, SYSTEM_LINKAGE_FUNCTION
, UNIT_OF_MEASURE
, UNIT_PRICE
, CMT_IND_COMPILED_SET_ID
, TOT_CMT_RAW_COST
, TOT_CMT_BURDENED_COST
, TOT_CMT_QUANTITY
, QUANTITY_ORDERED
, AMOUNT_ORDERED
, ORIGINAL_QUANTITY_ORDERED
, ORIGINAL_AMOUNT_ORDERED
, QUANTITY_CANCELLED
, AMOUNT_CANCELLED
, QUANTITY_DELIVERED
, AMOUNT_DELIVERED
, QUANTITY_INVOICED
, AMOUNT_INVOICED
, QUANTITY_OUTSTANDING_DELIVERY
, AMOUNT_OUTSTANDING_DELIVERY
, QUANTITY_OUTSTANDING_INVOICE
, AMOUNT_OUTSTANDING_INVOICE
, QUANTITY_OVERBILLED
, AMOUNT_OVERBILLED
, ORIGINAL_TXN_REFERENCE1
, ORIGINAL_TXN_REFERENCE2
, ORIGINAL_TXN_REFERENCE3
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
, REQUEST_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, BURDEN_SUM_SOURCE_RUN_ID
, BURDEN_SUM_DEST_RUN_ID
, BURDEN_SUM_REJECTION_CODE
, RECEIPT_CURRENCY_CODE
, RECEIPT_CURRENCY_AMOUNT
, RECEIPT_EXCHANGE_RATE
, DENOM_CURRENCY_CODE
, DENOM_RAW_COST
, DENOM_BURDENED_COST
, ACCT_CURRENCY_CODE
, ACCT_RAW_COST
, ACCT_BURDENED_COST
, ACCT_RATE_DATE
, ACCT_RATE_TYPE
, ACCT_EXCHANGE_RATE
, PROJECT_CURRENCY_CODE
, PROJECT_RATE_DATE
, PROJECT_RATE_TYPE
, PROJECT_EXCHANGE_RATE
, CMT_REJECTION_CODE
, GENERATION_ERROR_FLAG
, INVENTORY_ITEM_ID
, BOM_LABOR_RESOURCE_ID
, BOM_EQUIPMENT_RESOURCE_ID
, PROJ_RAW_COST
, PROJ_BURDENED_COST
, PROJ_CURRENCY_CODE
, PROJ_RATE_DATE
, PROJ_RATE_TYPE
, PROJ_EXCHANGE_RATE
, UOM_CODE
, RESOURCE_CLASS
, SRC_SYSTEM_LINKAGE_FUNCTION
, CBS_ELEMENT_ID
FROM PA.PA_COMMITMENT_TXNS#;
|
|
|