APPS.INV_LABEL_PVT4 dependencies on MTL_CYCLE_COUNT_ENTRIES

Line 1080: mtl_cycle_count_entries mcce

1076: , inv_project.get_locsegs(milkfv.inventory_location_id, milkfv.organization_id) LOCATOR
1077: , sum(nvl(l_secondary_transaction_qty,mcce.count_quantity_current)) secondary_quantity
1078: , mcce.count_uom_current secondary_uom
1079: FROM wms_license_plate_numbers plpn, cst_cost_groups ccg, mtl_item_locations milkfv,
1080: mtl_cycle_count_entries mcce
1081: WHERE cartonization_flag = 0 -- non Cartonization Flow
1082: AND plpn.lpn_id(+) = p_lpn_id
1083: AND milkfv.organization_id(+) = NVL(p_organization_id, plpn.organization_id)
1084: AND milkfv.subinventory_code(+) = NVL(l_subinventory_code, plpn.subinventory_code)

Line 1116: , mtl_cycle_count_entries mcce

1112: , mcce.parent_lpn_id
1113: , mcch.cycle_count_header_name
1114: , ppf.full_name requestor
1115: FROM mtl_cycle_count_headers mcch
1116: , mtl_cycle_count_entries mcce
1117: , per_people_f ppf
1118: WHERE mcce.cycle_count_entry_id = p_transaction_Id
1119: AND ppf.person_id(+) = mcce.counted_by_employee_id_current
1120: AND mcce.cycle_count_header_id=mcch.cycle_count_header_id;

Line 1128: , mtl_cycle_count_entries mcce

1124: CURSOR cc_det_approval IS
1125: SELECT mcch.cycle_count_header_name
1126: , ppf.full_name requestor
1127: FROM mtl_cycle_count_headers mcch
1128: , mtl_cycle_count_entries mcce
1129: , per_people_f ppf
1130: , mtl_material_transactions_temp mmtt
1131: WHERE mmtt.transaction_temp_id= p_transaction_id
1132: AND mmtt.cycle_count_id = mcce.cycle_count_entry_id