APPS.OPI_PMI_COST dependencies on OPI_PMI_COST_TEMP1_GTMP

Line 166: INSERT INTO opi_pmi_cost_temp1_gtmp

162:
163: -- ASSIGN GL POLICY, CALENDAR PERIOD, COST WAREHOUSE,
164: -- AND WAREHOUSE-ORG TO EACH PARAMETER ROW
165:
166: INSERT INTO opi_pmi_cost_temp1_gtmp
167: (
168: item_id,
169: whse_code,
170: orgn_code,

Line 241: opi_pmi_cost_temp1_gtmp t1,

237: t1.whse_orgn_code,
238: c.acctg_cost,
239: c.last_update_date
240: FROM
241: opi_pmi_cost_temp1_gtmp t1,
242: (select
243: item_id, whse_code, orgn_code, cost_mthd_code,
244: calendar_code, period_code, acctg_cost, last_update_date
245: from

Line 379: opi_pmi_cost_temp1_gtmp

375: item_id, whse_code, orgn_code, trans_date, total_cost, status)
376: SELECT
377: item_id, whse_code, orgn_code, trans_date, NULL, -2
378: FROM
379: opi_pmi_cost_temp1_gtmp
380: WHERE item_id IS NULL
381: OR whse_code IS NULL
382: OR orgn_code IS NULL
383: OR trans_date IS NULL;

Line 393: opi_pmi_cost_temp1_gtmp

389: item_id, whse_code, orgn_code, trans_date, total_cost, status)
390: SELECT
391: item_id, whse_code, orgn_code, trans_date, NULL, -3
392: FROM
393: opi_pmi_cost_temp1_gtmp
394: WHERE cost_basis IS NULL
395: AND item_id IS NOT NULL
396: AND whse_code IS NOT NULL
397: AND orgn_code IS NOT NULL