APPS.OPI_PMI_COST dependencies on OPI_PMI_COST_RESULT_GTMP

Line 331: INSERT INTO opi_pmi_cost_result_gtmp (

327:
328:
329: -- RETURN COSTS FOUND USING PARAM-ORG
330:
331: INSERT INTO opi_pmi_cost_result_gtmp (
332: item_id, whse_code, orgn_code, trans_date, total_cost, status, last_update_date, period_status)
333: SELECT
334: item_id, whse_code, orgn_code, trans_date, total_cost, 1, last_update_date, period_status
335: FROM

Line 343: INSERT INTO opi_pmi_cost_result_gtmp (

339:
340:
341: -- RETURN COSTS FOUND USING WHSE-ORG.
342:
343: INSERT INTO opi_pmi_cost_result_gtmp (
344: item_id, whse_code, orgn_code, trans_date, total_cost,
345: status, last_update_date, period_status)
346: SELECT
347: item_id, whse_code, orgn_code, trans_date, total_cost,

Line 356: INSERT INTO opi_pmi_cost_result_gtmp (

352:
353:
354: -- RETURN STATUS = -1 IF NO COSTS WAS FOUND
355:
356: INSERT INTO opi_pmi_cost_result_gtmp (
357: item_id, whse_code, orgn_code, trans_date, total_cost,
358: status, last_update_date, period_status)
359: SELECT
360: item_id, whse_code, orgn_code, trans_date, total_cost,

Line 374: INSERT INTO opi_pmi_cost_result_gtmp (

370:
371:
372: -- IF ANY PARAMETERS WERE MISSING, RETURN STATUS = -2 .
373:
374: INSERT INTO opi_pmi_cost_result_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

Line 388: INSERT INTO opi_pmi_cost_result_gtmp (

384:
385:
386: -- IF GL POLICY WAS NOT FOUND, RETURN STATUS = -3
387:
388: INSERT INTO opi_pmi_cost_result_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