DBA Data[Home] [Help]

APPS.OPI_PMI_IDS_SUMMARY dependencies on OPI_PMI_COST_PARAM_GTMP

Line 1254: /* Insert parameter to costing procedure in opi_pmi_cost_param_gtmp.

1250: delete and insert of mass transactions are faster than update */
1251: delete OPI_PMI_INV_DAILY_STAT_SUM
1252: WHERE NVL(PERIOD_STATUS,0) <> 2 ;
1253:
1254: /* Insert parameter to costing procedure in opi_pmi_cost_param_gtmp.
1255: Parameter are Organization code, warehouse code, item id, transaction date
1256: after insertion call costing procedure */
1257:
1258: insert into opi_pmi_cost_param_gtmp (orgn_code,

Line 1258: insert into opi_pmi_cost_param_gtmp (orgn_code,

1254: /* Insert parameter to costing procedure in opi_pmi_cost_param_gtmp.
1255: Parameter are Organization code, warehouse code, item id, transaction date
1256: after insertion call costing procedure */
1257:
1258: insert into opi_pmi_cost_param_gtmp (orgn_code,
1259: whse_code,
1260: item_id,
1261: trans_date)
1262: (SELECT distinct orgn_code,