APPS.OPIMPXWI dependencies on MTL_PARAMETERS

Line 384: from mtl_parameters mp

380: -- between the from and to date.
381:
382: cursor c_inv_org is
383: select mp.organization_id
384: from mtl_parameters mp
385: where
386: mp.process_enabled_flag <> 'Y' AND
387: exists
388: (select 'there are transactions'

Line 406: mtl_parameters mp,

402: -- orgs in MOQ.
403:
404: cursor c_inv_org_first_push is
405: select mp.organization_id from
406: mtl_parameters mp,
407: (select distinct organization_id
408: from mtl_material_transactions
409: where transaction_date >= l_from_date
410: UNION

Line 424: from mtl_parameters mp

420: --testing purpose rjin
421: /*
422: CURSOR c_inv_org IS
423: SELECT mp.organization_id
424: from mtl_parameters mp
425: WHERE organization_id IN (606);
426:
427: CURSOR c_inv_org_first_push IS
428: SELECT mp.organization_id

Line 429: from mtl_parameters mp

425: WHERE organization_id IN (606);
426:
427: CURSOR c_inv_org_first_push IS
428: SELECT mp.organization_id
429: from mtl_parameters mp
430: WHERE organization_id IN (606);
431: */
432: -- Cursor to get the transaction dates from the latest push of each org.
433: -- When a fetch is performed, the oldest of those dates will be selected

Line 525: from mtl_parameters mp

521:
522: if (p_org_code IS NOT NULL) then
523: BEGIN
524: select mp.organization_id into org_id
525: from mtl_parameters mp
526: where organization_code = p_org_code
527: and mp.process_enabled_flag <> 'Y';
528: l_exit := 0;
529: EXCEPTION

Line 1549: FROM mtl_parameters

1545: */
1546:
1547: SELECT primary_cost_method
1548: INTO cost_method
1549: FROM mtl_parameters
1550: WHERE Organization_id=p_organization_id;
1551:
1552:
1553: OPEN last_trx;

Line 2025: FROM mtl_parameters

2021: BEGIN
2022:
2023: SELECT primary_cost_method
2024: INTO cost_method
2025: FROM mtl_parameters
2026: WHERE Organization_id=Org_id;
2027:
2028: OPEN beg_inv_balance;
2029:

Line 2572: from mtl_parameters where organization_id = l_organization_id;

2568: l_avg_int_qty := (l_beg_int_qty + l_end_int_qty)/2;
2569: l_avg_int_val_b := (l_beg_int_val_b + l_end_int_val_b)/2;
2570:
2571: select process_enabled_flag into l_process_org
2572: from mtl_parameters where organization_id = l_organization_id;
2573:
2574: if l_process_org <> 'Y' then
2575: INSERT INTO opi_ids_push_log
2576: (ids_key,