DBA Data[Home] [Help]

APPS.OPI_PMI_COST dependencies on OPI_PMI_COST_TEMP2_GTMP

Line 209: INSERT INTO opi_pmi_cost_temp2_gtmp

205:
206: -- GET COSTS USING PARAM ORGN_CODE
207:
208: pv_sql := '
209: INSERT INTO opi_pmi_cost_temp2_gtmp
210: (
211: item_id,
212: whse_code,
213: orgn_code,

Line 302: opi_pmi_cost_temp2_gtmp t2,

298: t2.whse_orgn_code,
299: c.acctg_cost,
300: c.last_update_date
301: FROM
302: opi_pmi_cost_temp2_gtmp t2,
303: (select
304: item_id, whse_code, orgn_code, cost_mthd_code,
305: calendar_code, period_code, acctg_cost, last_update_date
306: from

Line 336: opi_pmi_cost_temp2_gtmp

332: item_id, whse_code, orgn_code, trans_date, total_cost, status, last_update_date, period_status)
333: SELECT
334: item_id, whse_code, orgn_code, trans_date, total_cost, 1, last_update_date, period_status
335: FROM
336: opi_pmi_cost_temp2_gtmp
337: WHERE
338: total_cost IS NOT NULL;
339:
340: