[Home] [Help]
45: SELECT
46: SUM(NVL(WRITE_OFF_AMOUNT
47: ,0))
48: FROM
49: JAI_CMN_BOE_WRITEOFFS
50: WHERE BOE_ID = V_BOE_ID
51: AND TRUNC(WRITE_OFF_DATE) < TRUNC(P_START_DATE)
52: ORDER BY
53: WRITE_OFF_DATE;
105: LOC.ADDRESS_LINE_3,
106: GCC.CHART_OF_ACCOUNTS_ID
107: FROM
108: JAI_CMN_BOE_HDRS HDR,
109: JAI_CMN_BOE_WRITEOFFS WRT,
110: ORG_ORGANIZATION_DEFINITIONS ORG,
111: HR_LOCATIONS LOC,
112: JAI_CMN_INVENTORY_ORGS JHOU,
113: GL_CODE_COMBINATIONS GCC