APPS.OPI_PMI_COST dependencies on OPI_PMI_WHSE_DATE_GTMP

Line 84: INSERT INTO opi_pmi_whse_date_gtmp(whse_code, trans_date)

80:
81:
82: -- EXTRACT DISTINCT WAREHOUSES AND DATES
83:
84: INSERT INTO opi_pmi_whse_date_gtmp(whse_code, trans_date)
85: SELECT /*+ ALL_ROWS */ DISTINCT whse_code, trans_date
86: FROM opi_pmi_cost_param_gtmp;
87:
88:

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;

Line 108: opi_pmi_whse_date_gtmp wd, opi_pmi_cost_whse_eff_gtmp e

104: INSERT INTO opi_pmi_cost_whse_eff_gtmp (whse_code, trans_date, cost_whse_code)
105: SELECT /*+ ALL_ROWS */
106: wd.whse_code, wd.trans_date, wd.whse_code
107: FROM
108: opi_pmi_whse_date_gtmp wd, opi_pmi_cost_whse_eff_gtmp e
109: WHERE
110: wd.whse_code = e.whse_code(+)
111: AND wd.trans_date = e.trans_date(+)
112: AND e.cost_whse_code IS NULL;