eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OPI_PMI_COST dependencies on OPI_PMI_COST

Line 1: PACKAGE BODY opi_pmi_cost AS

1: PACKAGE BODY opi_pmi_cost AS
2: /* $Header: OPIMCSTB.pls 115.3 2004/05/11 18:35:15 pdong ship $ */
3:
4: PROCEDURE get_cost IS
5:

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 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 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 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 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

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

Line 209: INSERT INTO opi_pmi_cost_temp2_gtmp

205:
206: -- GET COSTS USING PARAM ORGN_CODE
207:
208: pv_sql := '
209: INSERT INTO opi_pmi_cost_temp2_gtmp
210: (
211: item_id,
212: whse_code,
213: 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 270: INSERT INTO opi_pmi_cost_temp3_gtmp

266:
267: -- IF COST WASN'T FOUND USING PARAM-ORG, GET COSTS USING *WAREHOUSE-ORG*
268:
269: pv_sql := '
270: INSERT INTO opi_pmi_cost_temp3_gtmp
271: (
272: item_id,
273: whse_code,
274: orgn_code,

Line 302: opi_pmi_cost_temp2_gtmp t2,

298: t2.whse_orgn_code,
299: c.acctg_cost,
300: c.last_update_date
301: FROM
302: opi_pmi_cost_temp2_gtmp t2,
303: (select
304: item_id, whse_code, orgn_code, cost_mthd_code,
305: calendar_code, period_code, acctg_cost, last_update_date
306: from

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 336: opi_pmi_cost_temp2_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
336: opi_pmi_cost_temp2_gtmp
337: WHERE
338: total_cost IS NOT NULL;
339:
340:

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 350: opi_pmi_cost_temp3_gtmp

346: SELECT
347: item_id, whse_code, orgn_code, trans_date, total_cost,
348: 1, last_update_date, period_status
349: FROM
350: opi_pmi_cost_temp3_gtmp
351: WHERE total_cost IS NOT NULL;
352:
353:
354: -- RETURN STATUS = -1 IF NO COSTS WAS FOUND

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 363: opi_pmi_cost_temp3_gtmp

359: SELECT
360: item_id, whse_code, orgn_code, trans_date, total_cost,
361: -1, last_update_date, period_status
362: FROM
363: opi_pmi_cost_temp3_gtmp
364: WHERE total_cost IS NULL
365: AND cost_basis IS NOT NULL
366: AND item_id IS NOT NULL
367: AND whse_code IS NOT NULL

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 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 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

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

Line 402: END opi_pmi_cost;

398: AND trans_date IS NOT NULL;
399:
400: END get_cost;
401:
402: END opi_pmi_cost;