DBA Data[Home] [Help]

APPS.JA_JAINBOER_XMLP_PKG dependencies on JAI_CMN_BOE_WRITEOFFS

Line 49: JAI_CMN_BOE_WRITEOFFS

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;

Line 109: JAI_CMN_BOE_WRITEOFFS WRT,

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