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.INV_LABEL_PVT4 dependencies on MTL_CYCLE_COUNT_ENTRIES

Line 1307: mtl_cycle_count_entries mcce

1303: , inv_project.get_locsegs(milkfv.inventory_location_id, milkfv.organization_id) LOCATOR
1304: , sum(nvl(l_secondary_transaction_qty,mcce.count_quantity_current)) secondary_quantity
1305: , mcce.count_uom_current secondary_uom
1306: FROM wms_license_plate_numbers plpn, cst_cost_groups ccg, mtl_item_locations milkfv,
1307: mtl_cycle_count_entries mcce
1308: WHERE cartonization_flag = 0 -- non Cartonization Flow
1309: AND plpn.lpn_id(+) = p_lpn_id
1310: AND milkfv.organization_id(+) = NVL(p_organization_id, plpn.organization_id)
1311: AND milkfv.subinventory_code(+) = NVL(l_subinventory_code, plpn.subinventory_code)

Line 1343: , mtl_cycle_count_entries mcce

1339: , mcce.parent_lpn_id
1340: , mcch.cycle_count_header_name
1341: , ppf.full_name requestor
1342: FROM mtl_cycle_count_headers mcch
1343: , mtl_cycle_count_entries mcce
1344: , per_people_f ppf
1345: WHERE mcce.cycle_count_entry_id = p_transaction_Id
1346: AND ppf.person_id(+) = mcce.counted_by_employee_id_current
1347: AND ppf.EFFECTIVE_END_DATE(+) >= trunc(sysdate)

Line 1356: , mtl_cycle_count_entries mcce

1352: CURSOR cc_det_approval IS
1353: SELECT mcch.cycle_count_header_name
1354: , ppf.full_name requestor
1355: FROM mtl_cycle_count_headers mcch
1356: , mtl_cycle_count_entries mcce
1357: , per_people_f ppf
1358: , mtl_material_transactions_temp mmtt
1359: WHERE mmtt.transaction_temp_id= p_transaction_id
1360: AND mmtt.cycle_count_id = mcce.cycle_count_entry_id