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.GME_COMMON_PVT dependencies on MTL_SYSTEM_ITEMS

Line 615: FROM mtl_system_items_b i, gme_parameters g

611: ,NVL (i.process_supply_locator_id
612: ,g.supply_locator_id)
613: ,i.restrict_subinventories_code, NVL(i.location_control_code,1)
614: ,i.restrict_locators_code
615: FROM mtl_system_items_b i, gme_parameters g
616: WHERE i.organization_id = v_org_id
617: AND i.inventory_item_id = v_inventory_item_id
618: AND g.organization_id = v_org_id;
619:

Line 742: FROM mtl_system_items_b i, gme_parameters g

738: ,NVL (i.process_yield_locator_id
739: ,g.yield_locator_id)
740: ,i.restrict_subinventories_code, NVL(i.location_control_code,1)
741: ,i.restrict_locators_code
742: FROM mtl_system_items_b i, gme_parameters g
743: WHERE i.organization_id = v_org_id
744: AND i.inventory_item_id = v_inventory_item_id
745: AND g.organization_id = v_org_id;
746:

Line 846: ,p_item_master_rec IN mtl_system_items_kfv%ROWTYPE

842: END get_yield_defaults;
843:
844: PROCEDURE construct_material_detail (
845: p_formula_detail_rec IN fm_matl_dtl%ROWTYPE
846: ,p_item_master_rec IN mtl_system_items_kfv%ROWTYPE
847: ,p_batch_header_rec IN gme_batch_header%ROWTYPE
848: ,x_material_detail_rec OUT NOCOPY gme_material_details%ROWTYPE
849: ,x_return_status OUT NOCOPY VARCHAR2)
850: IS

Line 1411: FROM mtl_system_items_b

1407: -- Bug 13721430 - Add std lot size.
1408: CURSOR cur_common_rules (v_org_id NUMBER, v_inventory_item_id NUMBER)
1409: IS
1410: SELECT std_lot_size, fixed_lead_time, variable_lead_time
1411: FROM mtl_system_items_b
1412: WHERE organization_id = v_org_id
1413: AND inventory_item_id = v_inventory_item_id;
1414:
1415: l_rule_rec cur_common_rules%ROWTYPE;

Line 1899: FROM mtl_system_items_b

1895: /* Bug 5441643 Added NVL condition for location control code*/
1896: CURSOR cur_item_details (v_org_id NUMBER, v_inventory_item_id NUMBER)
1897: IS
1898: SELECT NVL(location_control_code,1), restrict_locators_code
1899: FROM mtl_system_items_b
1900: WHERE organization_id = v_org_id
1901: AND inventory_item_id = v_inventory_item_id;
1902:
1903: org_info_not_provided EXCEPTION;

Line 2118: FROM mtl_system_items_b

2114:
2115: CURSOR cur_item_control
2116: IS
2117: SELECT restrict_subinventories_code
2118: FROM mtl_system_items_b
2119: WHERE organization_id = p_organization_id
2120: AND inventory_item_id = p_inventory_item_id;
2121:
2122: l_item_restict_subinv NUMBER;

Line 2230: FROM mtl_system_items_kfv

2226:
2227: CURSOR cur_item_no (v_org_id NUMBER, v_inventory_item_id NUMBER)
2228: IS
2229: SELECT concatenated_segments
2230: FROM mtl_system_items_kfv
2231: WHERE organization_id = v_org_id
2232: AND inventory_item_id = v_inventory_item_id;
2233:
2234: l_validity_rec gmd_recipe_validity_rules%ROWTYPE;

Line 2483: FROM gme_material_details d, mtl_system_items_b i

2479: ,x_exception_tbl OUT NOCOPY gme_common_pvt.exceptions_tab) IS
2480: /* Bug 5212165 added line_no in the order by */
2481: CURSOR cur_get_materials IS
2482: SELECT d.*
2483: FROM gme_material_details d, mtl_system_items_b i
2484: WHERE d.batch_id IN (SELECT DISTINCT batch_id
2485: FROM gme_material_details
2486: START WITH batch_id = p_batch_id
2487: CONNECT BY batch_id = PRIOR phantom_id)

Line 2505: FROM mtl_system_items_kfv

2501: IS
2502: SELECT concatenated_segments, NVL(location_control_code,1) location_control_code,
2503: restrict_locators_code, primary_uom_code,
2504: reservable_type
2505: FROM mtl_system_items_kfv
2506: WHERE organization_id = v_org_id
2507: AND inventory_item_id = v_inventory_item_id;
2508:
2509: CURSOR cur_get_onhand (

Line 2568: --l_item_rec mtl_system_items_kfv%ROWTYPE;

2564: l_subinventory VARCHAR2 (10);
2565: l_return_status VARCHAR2 (1);
2566: l_mtl_dtl_rec gme_material_details%ROWTYPE;
2567: --FPbug#4912179
2568: --l_item_rec mtl_system_items_kfv%ROWTYPE;
2569: l_item_rec cur_get_item%ROWTYPE;
2570: l_exception_rec gme_exceptions_gtmp%ROWTYPE;
2571: setup_failure EXCEPTION;
2572: get_open_qty_err EXCEPTION;

Line 2990: FROM mtl_system_items_b

2986: /* Bug 5441643 Added NVL condition for location control code*/
2987: CURSOR cur_item_controls (v_org_id NUMBER, v_inventory_item_id NUMBER)
2988: IS
2989: SELECT NVL(location_control_code,1), restrict_locators_code
2990: FROM mtl_system_items_b
2991: WHERE organization_id = v_org_id
2992: AND inventory_item_id = v_inventory_item_id;
2993:
2994: l_item_loc_control NUMBER;