[Home] [Help]
View: OKX_BUS_PROCESS_TXNS_V
Product: | OKX - Contracts Integration |
Description: | Transaction types associated with a business process |
Implementation/DBA Data: |
APPS.OKX_BUS_PROCESS_TXNS_V
|
View Text
SELECT BPT.BUSINESS_PROCESS_ID ID1
, BPT.TRANSACTION_TYPE_ID ID2
, NULL NAME
, DECODE(SIGN(TRUNC(SYSDATE)-NVL(BPT.START_DATE_ACTIVE
, TRUNC(SYSDATE)))
, -1
, 'I'
, DECODE(SIGN(TRUNC(SYSDATE) - NVL(BPT.END_DATE_ACTIVE
, TRUNC(SYSDATE)))
, 1
, 'I'
, 'A')) STATUS
, NULL DESCRIPTION
, BPT.START_DATE_ACTIVE START_DATE_ACTIVE
, BPT.END_DATE_ACTIVE END_DATE_ACTIVE
, NULL INVENTORY_ITEM_ID
, NULL ORGANIZATION_ID
, NULL PRIMARY_UOM_CODE
FROM CS_BUS_PROCESS_TXNS BPT
Columns
Name |
ID1 |
ID2 |
NAME |
STATUS |
DESCRIPTION |
START_DATE_ACTIVE |
END_DATE_ACTIVE |
INVENTORY_ITEM_ID |
ORGANIZATION_ID |
PRIMARY_UOM_CODE |