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.GMF_LOT_COSTING_PUB dependencies on MTL_PARAMETERS

Line 488: organization_id mtl_parameters.organization_id%TYPE

484: l_uncostable_batches_tab uncostable_batches_tab;
485:
486: TYPE org_coll_typ IS RECORD
487: (
488: organization_id mtl_parameters.organization_id%TYPE
489: , organization_code mtl_parameters.organization_code%TYPE
490: , process_enabled_flag mtl_parameters.process_enabled_flag%TYPE
491: , le_id hr_organization_information.org_information2%TYPE
492: , ou_id hr_organization_information.org_information3%TYPE

Line 489: , organization_code mtl_parameters.organization_code%TYPE

485:
486: TYPE org_coll_typ IS RECORD
487: (
488: organization_id mtl_parameters.organization_id%TYPE
489: , organization_code mtl_parameters.organization_code%TYPE
490: , process_enabled_flag mtl_parameters.process_enabled_flag%TYPE
491: , le_id hr_organization_information.org_information2%TYPE
492: , ou_id hr_organization_information.org_information3%TYPE
493: );

Line 490: , process_enabled_flag mtl_parameters.process_enabled_flag%TYPE

486: TYPE org_coll_typ IS RECORD
487: (
488: organization_id mtl_parameters.organization_id%TYPE
489: , organization_code mtl_parameters.organization_code%TYPE
490: , process_enabled_flag mtl_parameters.process_enabled_flag%TYPE
491: , le_id hr_organization_information.org_information2%TYPE
492: , ou_id hr_organization_information.org_information3%TYPE
493: );
494: TYPE org_coll_tbl IS TABLE OF org_coll_typ INDEX BY PLS_INTEGER;

Line 522: organization_id mtl_parameters.organization_id%TYPE ,

518: -- Alternate Period cost caching
519: TYPE Alter_cost_typ IS RECORD
520: (
521: inventory_item_id mtl_system_items.Inventory_item_id%type ,
522: organization_id mtl_parameters.organization_id%TYPE ,
523: period_id gmf_period_statuses.period_id%TYPE ,
524: cost_details SYSTEM.gmf_cost_tab ,
525: total_cost NUMBER
526: ) ;

Line 1005: mtl_parameters mp,

1001: mtl_material_transactions mmt,
1002: gme_batch_step_items gbsi,
1003: gme_material_details gmd,
1004: mtl_transaction_lot_numbers mtln,
1005: mtl_parameters mp,
1006: hr_organization_information hoi,
1007: gme_transaction_pairs gtp
1008: WHERE gbsi.batch_id = p_batch_id
1009: AND gbsi.batchstep_id = p_batchstep_id

Line 1101: mtl_parameters mp,

1097: FROM mtl_system_items_b iimb,
1098: mtl_material_transactions mmt,
1099: gme_material_details gmd,
1100: mtl_transaction_lot_numbers mtln,
1101: mtl_parameters mp,
1102: hr_organization_information hoi
1103: WHERE mmt.transaction_source_type_id = 5
1104: AND gmd.line_type IN (-1,2)
1105: AND mtln.transaction_quantity(+) <> 0

Line 1381: FROM cm_whse_asc cstw, mtl_parameters invw

1377: AND gps.start_date <= p_date
1378: AND gps.end_date >= p_date
1379: AND gps.period_id = cst.period_id
1380: AND cst.organization_id = (SELECT NVL (cstw.cost_organization_id, invw.organization_id)
1381: FROM cm_whse_asc cstw, mtl_parameters invw
1382: WHERE cstw.organization_id(+) = invw.organization_id
1383: AND invw.organization_id = p_orgn_id
1384: AND NVL(cstw.eff_start_date(+),p_date) <= p_date -- HALUTHRA Bug 5473138/8533290
1385: AND NVL(cstw.eff_end_date(+),p_date) >= p_date -- HALTURHA Bug 5473138/8533290

Line 1420: FROM cm_whse_asc cstw, mtl_parameters invw

1416: WHERE cst.cost_type_id = p_cost_type_id
1417: AND cst.period_id = p_period_id
1418: AND cst.organization_id =
1419: (SELECT NVL (cstw.cost_organization_id, invw.organization_id)
1420: FROM cm_whse_asc cstw, mtl_parameters invw
1421: WHERE cstw.organization_id(+) = invw.organization_id
1422: AND invw.organization_id = p_orgn_id
1423: AND NVL(cstw.eff_start_date(+),p_date) <= p_date -- HALUTHRA Bug 5473138/8533290
1424: AND NVL(cstw.eff_end_date(+),p_date) >= p_date -- HALUTHRA Bug 5473138/8533290

Line 1462: FROM cm_whse_asc cstw, mtl_parameters invw

1458: AND cst.cost_type_id = p_cost_type_id
1459: AND gps.period_id = cst.period_id
1460: AND cst.organization_id =
1461: (SELECT NVL (cstw.cost_organization_id, invw.organization_id)
1462: FROM cm_whse_asc cstw, mtl_parameters invw
1463: WHERE cstw.organization_id(+) = invw.organization_id
1464: AND invw.organization_id = p_orgn_id
1465: AND NVL(cstw.eff_start_date(+),p_date) <= p_date -- HALUTHRA Bug 5473138/8533290
1466: AND NVL(cstw.eff_end_date(+),p_date) >= p_date -- HALUTHRA Bug 5473138/8533290

Line 10031: FROM mtl_parameters mp,

10027: mp.organization_code,
10028: mp.process_enabled_flag,
10029: ou.org_information2 le_id,
10030: ou.org_information3 ou_id
10031: FROM mtl_parameters mp,
10032: hr_organization_information ou
10033: WHERE ou.org_information_context = 'Accounting Information'
10034: AND mp.organization_id = ou.organization_id
10035: ORDER BY organization_id ;