APPS.OPI_PMI_COST dependencies on OPI_PMI_COST_PARAM_GTMP

Line 86: FROM opi_pmi_cost_param_gtmp;

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

Line 119: FROM opi_pmi_cost_param_gtmp;

115: -- GET DISTINCT LIST OF ORGANIZATION.DATES (FOR FINDING EFFECTIVE PLCY)
116:
117: INSERT INTO opi_pmi_orgn_date_gtmp(orgn_code, trans_date)
118: SELECT /*+ ALL_ROWS */ DISTINCT orgn_code, trans_date
119: FROM opi_pmi_cost_param_gtmp;
120:
121:
122: -- GET THE FISCAL POLICY FOR EACH ORGANIZATION.DATE
123:

Line 196: opi_pmi_cost_param_gtmp param,

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
199: cw.whse_code = param.whse_code
200: AND cw.trans_date = param.trans_date