BUSINESS_UNITPrompt Table: SP_BU_AM_NONVW
Default Value: BUS_UNIT_TBL_FS.DESCR
AM_WC_DPCLSE_VW(SQL View) |
Index Back |
|---|---|
View for DPCLOSEView for WorkCenter. Record DPCLOSEpending rows. |
| SELECT DISTINCT D.BUSINESS_UNIT , D.BOOK , C.FISCAL_YEAR , C.ACCOUNTING_PERIOD , E.DESCR FROM PS_BU_BOOK_TBL A , PS_SET_CNTRL_REC B , PS_CAL_DETP_TBL C , PS_OPEN_TRANS D , PS_BUS_UNIT_TBL_FS E , PS_ASSET F WHERE B.SETCNTRLVALUE = A.BUSINESS_UNIT AND B.RECNAME = 'CAL_DETP_TBL' AND B.SETID = C.SETID AND A.DISTRIBUTION_SW = 'Y' AND A.CAL_DEPR_PD = C.CALENDAR_ID AND D.CALC_DEPR_STATUS = 'C' AND (D.TRANS_TYPE = 'ADD' OR ( D.TRANS_TYPE = 'TRF' AND D.TRANS_IN_OUT = 'I')) AND D.ACCOUNTING_DT <= C.END_DT AND D.BUSINESS_UNIT = E.BUSINESS_UNIT AND D.BUSINESS_UNIT = A.BUSINESS_UNIT AND D.BOOK = A.BOOK AND D.BUSINESS_UNIT = F.BUSINESS_UNIT AND D.ASSET_ID = F.ASSET_ID AND F.ASSET_STATUS = 'I' AND C.FISCAL_YEAR = ( SELECT MAX(D1.FISCAL_YEAR) FROM PS_AM_WC_BKCLSE_VW D1 WHERE D1.BUSINESS_UNIT = D.BUSINESS_UNIT AND D1.BOOK = D.BOOK ) AND C.ACCOUNTING_PERIOD = ( SELECT MAX(D1.ACCOUNTING_PERIOD) FROM PS_AM_WC_BKCLSE_VW D1 WHERE D1.BUSINESS_UNIT = D.BUSINESS_UNIT AND D1.BOOK = D.BOOK AND D1.FISCAL_YEAR = C.FISCAL_YEAR ) AND NOT EXISTS ( SELECT 'X' FROM PS_DIST_LN C1 WHERE C1.BUSINESS_UNIT = D.BUSINESS_UNIT AND C1.ASSET_ID = D.ASSET_ID AND C1.BOOK = D.BOOK AND C1.TRANS_TYPE IN ('DPR','PDP','LPY','PLP','ACR') AND C1.ACCOUNTING_DT BETWEEN C.BEGIN_DT AND C.END_DT) AND EXISTS ( SELECT 'X' FROM PS_DEPRECIATION C2 WHERE C2.BUSINESS_UNIT = D.BUSINESS_UNIT AND C2.ASSET_ID = D.ASSET_ID AND C2.BOOK = D.BOOK AND C2.FISCAL_YEAR = C.FISCAL_YEAR AND C2.END_PD >= C.ACCOUNTING_PERIOD) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Prompt Table: SP_BU_AM_NONVW |
| 2 | BOOK | Character(10) | VARCHAR2(10) NOT NULL | Asset Book Name |
| 3 | FISCAL_YEAR | Number(4,0) | SMALLINT NOT NULL | Fiscal Year |
| 4 | ACCOUNTING_PERIOD | Number(3,0) | SMALLINT NOT NULL | Identifies a time period to which you post transactions. Typically, an accounting period represents a month, but it can also represent a week, a day, or any user-defined interval. An accounting period has a beginning date and an ending date, and is defined in the calendar table. |
| 5 | DESCR30 | Character(30) | VARCHAR2(30) NOT NULL |
Description
Default Value: BUS_UNIT_TBL_FS.DESCR |