APPS.PA_IC_INV_UTILS dependencies on GL_ALC_LEDGER_RSHIPS_V

Line 38: new table gl_alc_ledger_rships_v and corresponding columns

34: ) IS
35:
36:
37: /* R12 : Ledger Architecture Changes : The table gl_mc_reporting_options will obsoleted, replace with
38: new table gl_alc_ledger_rships_v and corresponding columns
39: Also remove the date validation, If we add application id and relationship_enabled_flag check then no need to
40: check the date. */
41:
42: /* cursor c_reporting_sob(p_sob_id in number,p_org_id in number) is

Line 57: from gl_alc_ledger_rships_v

53:
54: cursor c_reporting_sob(p_sob_id in number,p_org_id in number) is
55: select ledger_id reporting_set_of_books_id ,
56: currency_code reporting_currency_code
57: from gl_alc_ledger_rships_v
58: where source_ledger_id = p_sob_id
59: and (org_id = -99 OR org_id = p_org_id)
60: and application_id = 275
61: and relationship_enabled_flag ='Y';