APPS.OPI_DBI_INV_VALUE_OPM_INIT_PKG dependencies on GL_SUBR_LED

Line 109: each co_code represented in gl_subr_led. Each purge will be for a single company, so this is the

105: l_stmt_num := 20;
106:
107: /*
108: The following insert statement creates OPM Inception Balance rows in opi_dbi_inv_value_log, one for
109: each co_code represented in gl_subr_led. Each purge will be for a single company, so this is the
110: right level of granularity. If the global_start_date precedes the available data, it is important
111: that all of a company's rows be preserved. In such a case, if one company has less history than another,
112: then we need to know the shortenned history so that the correct costing date is used.
113: */

Line 140: gl_subr_led led

136: g_user_id last_updated_by,
137: g_login_id last_update_login
138: FROM
139: sy_orgn_mst c,
140: gl_subr_led led
141: WHERE
142: c.orgn_code = led.co_code
143: GROUP BY c.organization_id;
144:

Line 737: gl_subr_led l,

733: select
734: l.doc_id, h.wip_whse_code whse_code,
735: sum(l.amount_base * l.debit_credit_sign) amount_base
736: from
737: gl_subr_led l,
738: gme_batch_header h
739: where
740: l.doc_type = 'PROD'
741: and l.acct_ttl_type = 1530

Line 751: gl_subr_led l,

747: select
748: l.doc_id, h.wip_whse_code whse_code,
749: -1 * sum(amount_base * debit_credit_sign) amount_base
750: from
751: gl_subr_led l,
752: gme_batch_header h,
753: ic_whse_mst w,
754: sy_orgn_mst o,
755: opi_dbi_inv_value_log log