DBA Data[Home] [Help]

APPS.OPI_PMI_COST dependencies on CM_WHSE_ASC

Line 95: opi_pmi_whse_date_gtmp wd, cm_whse_asc cwa

91: INSERT INTO opi_pmi_cost_whse_eff_gtmp (whse_code, trans_date, cost_whse_code)
92: SELECT /*+ ALL_ROWS */
93: wd.whse_code, wd.trans_date, cwa.cost_whse_code
94: FROM
95: opi_pmi_whse_date_gtmp wd, cm_whse_asc cwa
96: WHERE
97: wd.whse_code = cwa.whse_code
98: AND wd.trans_date BETWEEN cwa.eff_start_date AND cwa.eff_end_date
99: AND cwa.delete_mark = 0;