APPS.OPI_PMI_COST dependencies on OPI_PMI_COST_WHSE_EFF_GTMP

Line 91: INSERT INTO opi_pmi_cost_whse_eff_gtmp (whse_code, trans_date, cost_whse_code)

87:
88:
89: -- GET EFFECTIVE COST WAREHOUSE
90:
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

Line 104: INSERT INTO opi_pmi_cost_whse_eff_gtmp (whse_code, trans_date, cost_whse_code)

100:
101:
102: -- ADD SELF WAREHOUSE IF NO COST WAREHOUSE
103:
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

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;

Line 194: opi_pmi_cost_whse_eff_gtmp cw,

190: per.period_code,
191: per.period_status,
192: w.orgn_code
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