APPS.OPI_PMI_COST dependencies on OPI_PMI_ORGN_PER_GTMP

Line 137: INSERT INTO opi_pmi_orgn_per_gtmp

133:
134:
135: -- ASSOCIATE THE CORRECT CALENDAR PERIOD, DEPENDING ON COST_BASIS
136:
137: INSERT INTO opi_pmi_orgn_per_gtmp
138: (orgn_code, trans_date, calendar_code, period_code, period_status)
139: SELECT /*+ ALL_ROWS */ o.orgn_code, o.trans_date,
140: c.prior_calendar_code, c.prior_period_code, c.prior_period_status
141: FROM opi_pmi_cldr_sum_gtmp c, opi_pmi_orgn_plcy_gtmp o

Line 150: INSERT INTO opi_pmi_orgn_per_gtmp

146:
147:
148: -- ASSOCIATE THE COST_BASIS=1 CALENDAR PERIOD
149:
150: INSERT INTO opi_pmi_orgn_per_gtmp
151: (orgn_code, trans_date, co_code, cost_mthd, cost_basis,
152: calendar_code, period_code, period_status)
153: SELECT /*+ ALL_ROWS */
154: o.orgn_code, o.trans_date, o.co_code, o.cost_mthd, o.cost_basis,

Line 197: opi_pmi_orgn_per_gtmp per

193: FROM
194: opi_pmi_cost_whse_eff_gtmp cw,
195: ic_whse_mst w,
196: opi_pmi_cost_param_gtmp param,
197: opi_pmi_orgn_per_gtmp per
198: WHERE
199: cw.whse_code = param.whse_code
200: AND cw.trans_date = param.trans_date
201: AND per.orgn_code(+) = param.orgn_code