DBA Data[Home] [Help]

APPS.OPI_EDW_JOB_RSRC_F_SZ dependencies on GL_SETS_OF_BOOKS

Line 18: GL_SETS_OF_BOOKS gsob,

14: WIP_OPERATIONS wo,
15: WIP_ENTITIES we,
16: BOM_DEPARTMENTS bd,
17: HR_ORGANIZATION_INFORMATION hoi,
18: GL_SETS_OF_BOOKS gsob,
19: WIP_DISCRETE_JOBS wdj,
20: WIP_REPETITIVE_SCHEDULES wrs,
21: EDW_LOCAL_INSTANCE inst,
22: MTL_SYSTEM_ITEMS msi

Line 62: GL_SETS_OF_BOOKS gsob,

58: WIP_TRANSACTIONS wt,
59: WIP_TRANSACTION_ACCOUNTS wta,
60: BOM_DEPARTMENTS bd,
61: HR_ORGANIZATION_INFORMATION hoi,
62: GL_SETS_OF_BOOKS gsob,
63: WIP_FLOW_SCHEDULES wfs,
64: BOM_OPERATIONAL_ROUTINGS bor,
65: BOM_OPERATION_SEQUENCES bos,
66: EDW_LOCAL_INSTANCE inst,

Line 283: gl_sets_of_books gsob

279: CURSOR c_7 is
280: SELECT avg(nvl(vsize(gsob.currency_code), 0))
281: FROM hr_all_organization_units hou,
282: hr_organization_information hoi,
283: gl_sets_of_books gsob
284: WHERE hou.organization_id = hoi.organization_id
285: AND ( hoi.org_information_context || '') ='Accounting Information'
286: AND hoi.org_information1 = to_char(gsob.set_of_books_id) ;
287: --WHERE hou.last_update_date between